Re: [replication driver] Expected behaviour when the master is down/unreachable

[vinay pothnis]

Thanks Alex!

Couple of follow up questions on that:

If I have only 1 master and 1 slave, and the slave goes down, will I be able to failover to the master?

From the documentation and code, it looks like the failover only happens among the slaves when there are more than 1 slaves like this:

jdbc:mysql:replication://master,slave1,slave2/db

Since the master can also handle reads, do you think that if a slave goes down, the master should be able to take over?

I tried something like this:
jdbc:mysql:replication://master,slave1,master/db

In this case, when the slave1 went down, the connections failed over to the master. But when the slave came back up, the connections did not fall back.

Is the above configuration (master,slave,master) recommended/workable?

Thanks
Vinay