ERROR 1290 (HY000): The MySQL server is running with the --sql-replica-on option so it cannot execute this statement

Scenario

When an SQL statement was executed, the following error information was displayed:

mysql> create database test;
ERROR 1290 (HY000): The MySQL server is running with the --sql-replica-on option so it cannot execute this statement

Possible Causes

A read replica received requests to add, delete, and modify data, but the sql_replica_on parameter was set to on to prohibit these operations.

Solution

Check whether the client connection IP address for write operations is correct. You are advised to connect to the floating IP address of the DB instance or the read/write IP address of the proxy instance.