[MDEV-9785] Galera node cant connect to cluster Created: 2016-03-24 Updated: 2016-03-30 Resolved: 2016-03-30 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Galera, Galera SST |
| Affects Version/s: | 10.1.12 |
| Fix Version/s: | 10.1.13 |
| Type: | Bug | Priority: | Major |
| Reporter: | Alexey Teterin | Assignee: | Nirbhay Choubey (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | galera, sst, xtrabackup | ||
| Environment: |
ubuntu 14.04 x64 |
||
| Issue Links: |
|
||||||||
| 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. BUT sometimes, when disconnected nodes down few days i cant connect they to cluster. after few tries im 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 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 |
| Comments |
| Comment by Nirbhay Choubey (Inactive) [ 2016-03-24 ] |
|
at@rustex.ru Could share some more details?
Also, why isn't rsync SST working for you? |
| Comment by Alexey Teterin [ 2016-03-25 ] |
|
it working but very terrible. DB size is 6.5 Gb.
in my case xtrabackup-v2 feels more stable and easy. Nirbay, please tell me - do you have some ideas about my trouble? |