Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Supporting MySQL failover
- Abhijat Vatsyayan
June 11, 2008, 5:15 am
rate this thread
I am looking for a MySQL driver (or configuration) for PHP which will
support fail-over to a slave database in case of a master failure (we
have a MySQL master-slave replication setup). I have already looked at
MySQL proxy and if nothing works, I will end up using it but I was
hoping that PHP has some kind of built in support (through the driver or
otherwise) for MySQL fail-over (like MySQL JDBC driver has). We would
prefer not to change the application to support fail-over (to slave in
case of master crash).
If you want to see the MySQL JDBC driver configuration for automatic
fail-over, see :
Re: Supporting MySQL failover
But if the application were well designed, you would only need to change
one file (the database class you wrote).
Remove the "x" from my email address
JDS Computer Training Corp.