cancel
Showing results for 
Search instead for 
Did you mean: 

Prolems with MySQL Master-Slave

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