Is it possible for the client to use the slave when the master is down in mysql replication?
I have already set up a simple MySQL replication having a master and a slave.
The client connects to the master to access the database; any changes made to the master server is replicated onto the slave. How shall I configure the client so that when the master server is down, the client automatically connects to the slave server?
I am using MySQL Server 5.1 and MySQL workbench 5.2 CE. I edited the my.ini files for both master and slave.
The client uses a J2EE application.
What additional commands must I input in the master my.ini file to make the changes?
Also is there a way to increase or decrease the time interval between replications?