Skip to content

Rate this page
Thanks for your feedback
Thank you! The feedback has been submitted.

Get free database assistance or contact our experts for personalized support.

MySQL Replica node is not configured as READ-ONLY

Description

To prevent accidental writes that may lead to data inconsistency, a replica node must have the READ-ONLY flag active.

The current node has a READ-ONLY value of 0 and is at high risk.

Resolution

Set the value of READ-ONLY to 1, to prevent writes on this node. SET GLOBAL READ-ONLY=1;

Need more support from Percona?

Percona experts bring years of experience in tackling tough database performance issues and design challenges.