MySQL Forums
Forum List  »  Replication

General Question about Master - Slave Replication
Posted by: Achim Schraud
Date: September 17, 2014 01:16AM

Hello,

i have installed a master slave replication for testing. Everything is working well.
We want to implement the setup into our production environment to take backups or selects from the slave to reduce the load on the master.

I think the best way is to change the slave to read-only. But we have several employees with Super rights. What happens if the employees are writing to the slave instead of the master?

We just tested this and the changes on slave remains. The master is not overwriting the slave. So the Contents of the master and slave are not similiar.

What is the right method to implement a slave for backup and selects? Hope you can help me. Thank you.

Options: ReplyQuote


Subject
Views
Written By
Posted
General Question about Master - Slave Replication
1633
September 17, 2014 01:16AM


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.