Read-only

Hello,

We are using Percona for replication. Although, one of our nodes has read-only option activated. Can this cause any trouble in our replication?

Enabling the read-only option on a slave is a best practice, and will not interfere with replication.

Keep in mind that if a user has the SUPER privilege, they will be able to modify data regardless of if the server is set to read-only or not.

Hi,

As Scott said, read_only option should be enable on slave as a best practice and to avoid duplicate entry errors on slave. I would suggest you to read below.
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_read_only
Thanks.

Thank’s,

Your help was very efficient.