Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have been facing issues in my high availability failover (on WAN links) LAMP setup hosting a Drupal CMS based site, approximately after every 2 months both servers suddenly stop responding to http requests, CPU load goes sky very high on both servers until we reboot both the servers and restore Drupal database and reconfigure the Master/Master replication.

I'm putting explanatory diagram of the setup and my.cnf configuration on both servers.

I request to kindly provide your valuable inputs on this issue.


share|improve this question
Did you check any logfiles? Could it be a OS issue and not a mysql issue? What version do you use? What OS? Could it be an attack (like SYN Flood e.g.)? –  da_didi May 7 '14 at 7:28

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.