Rebooting DB Instances or Read Replicas

Scenarios

You may need to reboot a DB instance during maintenance. For example, after you modify some parameters, a reboot is required for the modifications to take effect. You can reboot a primary DB instance or a read replica on the management console.

Constraints

• Rebooting a DB instance will roll back its running transactions. Before rebooting a DB instance, reduce the number of its active connections and workload requests to shorten the reboot duration.
• If the DB instance status is Abnormal, the reboot may fail.
• Rebooting a DB instance will cause service interruptions. During this period, the DB instance status is Rebooting.
• Rebooting an instance makes it temporarily unavailable and will release in-memory cache once the reboot is complete. To prevent traffic congestion during peak hours, you are advised to reboot DB instances during off-peak hours.
• After a primary/standby DB instance is rebooted, it takes about one minute to establish the replication relationship. During this period, some operations, such as changing the instance class, cannot be performed.
• A reboot task configured during the current maintenance window will not be executed until the next maintenance window.

Procedure

1. Log in to the management console.
2. Click in the upper left corner and select a region and a project.
3. Click in the upper left corner of the page and choose Database > Relational Database Service.
4. On the Instances page, locate the target DB instance, or click and then locate the target read replica. Choose More > Reboot in the Operation column.

   Alternatively, click the target DB instance on the Instances page to go to the Basic Information page. In the upper right corner, click Reboot.

   For primary/standby DB instances, if you reboot the primary DB instance, the standby DB instance is also rebooted automatically.

5. In the displayed dialog box, choose a scheduled time, select the check box, and click OK.
   • Immediate: RDS reboots the instance immediately.
   • During maintenance window: RDS will reboot the instance during the maintenance window you configured.

     If you select During maintenance window, you can further click Modify under the option to change the maintenance window to a preferred time.

6. Refresh the DB instance list and view the status of the DB instance. If its status is Available, it has rebooted successfully.