Re: [Maria-discuss] Galera Cluster: Cluster Blocked, when one node down?

2015-12-14 Thread Jamie Gibbard
You should consider using a better method for connecting to your DB servers, than DNS round robin. Think about using a haproxy load balancing node, with the clustercheck script (https://github.com/olafz/percona-clustercheck) This would ensure that a node is not only accessible on its MySQL port

Re: [Maria-discuss] Mariadb 10.1.6, total cluster recovery - gvwstate.dat

2015-08-19 Thread Jamie Gibbard
From: Max Zulio [zulioexpr...@gmail.com] Sent: 19 August 2015 17:40 To: Jamie Gibbard Cc: maria-discuss@lists.launchpad.net Subject: Re: [Maria-discuss] Mariadb 10.1.6, total cluster recovery - gvwstate.dat Hi Jamie, If I kill -9 mysqld on all three of my nodes in the cluster, then

Re: [Maria-discuss] Mariadb 10.1.6, total cluster recovery - gvwstate.dat

2015-08-13 Thread Jamie Gibbard
Hi, Are you sure there are no other errors? I'm not sure that the file being missing is the problem there: When a node stores the Primary Component state to disk, it saves it as the gvwstate.dat file. The node creates and updates this file when the cluster forms or changes the Primary Componen

Re: [Maria-discuss] New Question: backup

2015-07-10 Thread Jamie Gibbard
No-one forced you to join the mailing list. At the end of the day, if you want to waste your own time replying to KB questions that no-one will ever see or care about, then that’s up to you. Don’t be surprised if the rest of us think that you are being ridiculous and stubborn for the sake of it