How to switch between database servers?

T

TheDoctor2015-03-28 08:34:40

Database

TheDoctor, 2015-03-28 08:34:40

There are two database servers. By default, the web application works with the first one, but when a second server appears on the network, the application should start using it. If the second server is disconnected from the network, then we use the first one.
How can this be implemented at the mysql DBMS level?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Armenian Radio, 2015-03-28
@TheDoctor

You actually described the switching logic. You can implement it inside the application (periodically trying to contact the second server), or on a separate routing unit - either by changing the network route (similar to how ISP auto-switching is done), or by reconfiguring NAT.
The implementation of auto-switching in the application is more reliable - in this case there is no single point of failure.