Re: General Question about Master - Slave Replication
Posted by:
Rick James
Date: September 18, 2014 04:44PM
> I think the best way is to change the slave to read-only.
Always good for a Slave.
> But we have several employees with Super rights. What happens if the employees are writing to the slave instead of the master?
SUPER privilege allows you to write to the machine. You should ake them out behind the barn an give them a good lashing.
> What is the right method to implement a slave for backup and selects?
Yes, the Slave is a good place for backup and random selects.
The Master must be used for all writes, plus any SELECTs that "support" the writes, such as SELECT FOR UPDATE.
Seriously, give the super-employees another login for doing ad hoc queries and such. Then drill into them the dangers of using "root" on the Slave. If they should still have root access, then give each one a separate SUPER login, and be willing to revoke it if they goof.
Subject
Views
Written By
Posted
1635
September 17, 2014 01:16AM
Re: General Question about Master - Slave Replication
927
September 18, 2014 04:44PM
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.