I am working on a drupal version 7 project and I would like to know what is the best practice for the database resilience of Drupal.
We are going to use MySQL 5.6 entreprise edition on physical servers, in an master-master replication with one master read only.
I wanted to know how most of you are dealing with the failover of the database? Ideally we would like to be able to failover automatically in a disaster recovery scenario. I was thinking of using our loadbalancer to detect the failover and redirect the traffic using netscaler datastream in an active passive scenario. For the point of view of MySQL, we would like to have a MySQL ha solution which monitor the database back ends.
The content side of the drupal application is using a gluster solution in an active active node which is mounted to all the app server.
If you have any implemented solution I will be happy to hear about it.