Percona XtraDB Cluster node recovery

view full story

http://serverfault.com – I have been reviewing XtraDB clustering and produced a P.o.C. environment on Openstack using 4 instances, which has fallen over during my resilience testing. Per the pxc documentation: http://www.percona.com/doc/percona-xtradb-cluster/howtos/virt_sandbox.html which covers a 3 node install I opted for a 4th. Initial setup complete data loading tests passed, with all nodes being updates synchronously using a 1.6GB test sql file to load a database. Failiure and restore of nodes commenced, this test entailed stoping the mysql service on a node, creating and subsequently dropping a database to t (HowTos)