Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9785

Galera node cant connect to cluster

    XMLWordPrintable

Details

    Description

      Hello am using Galera with 10.1.12-MariaDB and SST method is xtrabackup-v2

      please dont recommend SST=rsync it's not work for me

      I have healthy cluster 8 nodes, sometimes one or few nodes goes down.
      im just `service mysql` start on it and they successfully connecting to cluster and all is OK.

      BUT sometimes, when disconnected nodes down few days i cant connect they to cluster.

      after few tries im
      rm -fr /var/lib/mysql/* & rm -fr /var/log/mysql/*
      and nothing too, they have this message in syslog:

      mysqld: [ERROR] Binlog file '/var/log/mysql/mariadb-bin.003079' not found in binlog index, needed for recovery. Aborting.

      i know how work with this, i can recover cluster when i have nodes which can't connect to cluster with message above, so i do this:

      1. shutdown all nodes, and leave only one node
      2. shutdown last node and rm -fr /var/log/mysql/*
      3. bootstrap this last node with deleted binlog
      4. connect other nodes to cluster service mysql start
      5. profit - all is OK

      But problem is:

      I cant down all production nodes, and down last node too, because i have 8 nodes to serve big site traffic and one running node immediately down when all traffic goes to it (of course because overload)

      QUESTION IS:

      Please help me. How connect nodes to cluster when they won't connect and have error
      mysqld: [ERROR] Binlog file '/var/log/mysql/mariadb-bin.003079' not found in binlog index, needed for recovery. Aborting.

      Attachments

        Issue Links

          Activity

            People

              nirbhay_c Nirbhay Choubey (Inactive)
              at@rustex.ru Alexey Teterin
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.