cancel
Showing results for 
Search instead for 
Did you mean: 

Prolems with MySQL Master-Slave

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

Prolems with MySQL Master-Slave

Dear all, 

I have implemented master-slave for my Magento website,

Master: 192.168.1.1

Slave:192.168.1.2

It works well

but I have a problem that when the slave server goes down, then Magento said "can't connect to database server", even the master server's still live.  

So the question is, can I configure Magento to auto switch defaut_read to MySQL Master server when slave go down? or anything else to fix this thing?
Thank you,
Dat Trinh