assuming that I have setup the Database (MySQL) Replication using Master-Slave configuration, and have synchronized those Master and Slave servers, how can my C# program know that it has to update the Slave server when the Master server fails? What are the conditions that the C# program switch from the Master server to the Slave server?
I am using MySQL server.
1 answers
i thing that solution can be done as this:
before update do ping command to the server and if you get response than proceed with update (maybe second thread) that will be checking the server connection and when this fails you know that you have to update slave server
(know the theory, the programming is up to you)
P
answered one year ago by:
556