This section describes how to restart an RDS for MySQL instance.
Application Scenarios
If the number of connections reaches the upper limit or the instance has any performance issues, you can manually reboot the database instance through the Console page.
Prerequisites
You can only restart the instances with the database status of Running.
Constraints and Restrictions
1. If the database instance status is Abnormal, the restart may fail.
2. Restarting a database instance will cause the database engine service to be restarted. Restarting a database instance will cause service interruption for a short period. During the restart process, the database instance status is Restarting.
3. Restarting will cause the instance unavailability. After restarting, the instance will automatically clear the cache in memory. Please restart during the off-peak period of service to minimize disruption during peak service hours.
Affect
• Make sure that automatic reconnection is supported because restarting the MySQL instance can cause service interruption. Alternatively, you can perform a manual connection after the database restart is complete. It is recommended to stop write operations before the instance restarts. Please operate with caution.
• For primary/standby instances, the corresponding standby instance will also be restarted synchronously and the service will also be interrupted.
• If the primary instance contains read-only instances, restarting the primary instance does not cause the read-only instances to restart. The replication relationship is automatically restored after restarting.
Procedure
1. Log in to the Console.
2. Click in the upper left corner of the Console, and select Region and Project.
3. Select Database > Relational database... Go to the MySQL Console.
4. On the Instance Management page, select the specified instance, and click More and Restart. For primary/standby instances, the corresponding standby instance will also be restarted synchronously and the service will also be interrupted.
5. In the Restart Instance pop-up box, click OK to restart the instance.
6. After the instance restart is complete, the instance status is Running.