By default, SQL statements exceeding 1 second are defined as a slow log; you can modify the long_query_time parameter in the parameter setting to customize the slow log time. For details, refer to Modify parameters.

How long can primary/secondary switchover logs be stored?

Primary/secondary switchover logs can be stored for 30 days.

What are the precautions for switching primary node?

Please make sure that your applications have automatic reconnection mechanisms.

If a read-only node is mounted under the instance, the data of the read-only node can be delayed for several minutes after primary/secondary switchover, because it must rebuild the replication link and synchronize the incremental data.

Switchover can be completed within 5 seconds without a delay in primary/secondary replication.

tip

Note for more details on primary/secondary switchover, refer to Switching primary node.

Last updated: 2025.11.17 16:15:12

Public security network record in Beijing: No. 11010802032137