Hi Bertrand, you should always have an odd number of servers (3, 5, 7) - even number is a risk of split brain, or use weights so you give priority to specific servers. You should also use a load balancer which redirects query to an available node, ex: HAProxy, MaxScale, GLBD... Does the split brain happen because of network issues? 2015-10-24 15:34 GMT+02:00 Bertrand Caplet <bertrand.caplet@chunkz.net>:

Hi all, I have a galera cluster of 4 MariaDB server and sometimes a node fail. But when a node fail, others nodes doesn't want to respond to query. I have in log : "MYSQL: query failed: WSREP has not yet prepared node for application use" It's really embarrassing, because it happen like once a week.

Is there a parameter to modify to get this working even when split brain ? Like If 2 of the 4 server are ok, I can still make query ?

Thanks in advance,

-- CHUNKZ.NET - script kiddie and computer technician Bertrand Caplet, Flers (FR) Feel free to send encrypted/signed messages Key ID: 37F70C30 GPG FP: 134A 4027 518B 5F4D D409 558D BA9B 7BF0 37F7 0C30

_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp