Announcement

Announcement Module
Collapse
No announcement yet.

Read-only

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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?

  • #2
    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.

    Comment


    • #3
      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/...svar_read_only
      Thanks.

      Comment


      • #4
        Thank's,

        Your help was very efficient.

        Comment

        Working...
        X