MySQL Forums
Forum List  »  Replication

Re: master replication
Posted by: Veerasamy Kaunder
Date: September 29, 2014 05:27AM

Hello,

Do not update slave if it is one way replication.
you can have both DB server and Application server having local mysql db as Master & master. i.e. both will be master and slave of each other. it is two way replication.

In that case, when the main DB is down or not reachable, you can point your app to the local DB.

Before pointing the application to local db, ensure that the db has all data by using slave status command.
This way when the main DB server becomes reachable, the slave thread in main db will read the local DB and update itself.


Veerasamy.

Options: ReplyQuote


Subject
Views
Written By
Posted
1590
September 16, 2014 03:40AM
1013
September 16, 2014 11:37PM
Re: master replication
986
September 29, 2014 05:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.