Menu
Amazon Relational Database Service
User Guide (API Version 2014-10-31)

Rebooting a DB Instance

You might need to reboot your DB instance, usually for maintenance reasons. For example, if you make certain modifications, or if you change the DB parameter group associated with the DB instance, you must reboot the instance for the changes to take effect.

Rebooting a DB instance restarts the database engine service. Rebooting a DB instance results in a momentary outage, during which the DB instance status is set to rebooting. If the Amazon RDS instance is configured for Multi-AZ, the reboot can be conducted with a failover. An Amazon RDS event is created when the reboot is completed.

If your DB instance is a Multi-AZ deployment, you can force a failover from one availability zone to another when you reboot. When you force a failover of your DB instance, Amazon RDS automatically switches to a standby replica in another Availability Zone, and updates the DNS record for the DB instance to point to the standby DB instance. As a result, you need to clean up and re-establish any existing connections to your DB instance. Rebooting with failover is beneficial when you want to simulate a failure of a DB instance for testing, or restore operations to the original AZ after a failover occurs. For more information, see High Availability (Multi-AZ).

When you reboot the primary instance of an Amazon Aurora DB cluster, RDS also automatically reboots all of the Aurora Replicas in that DB cluster. When you reboot the primary instance of an Aurora DB cluster, no failover occurs. When you reboot an Aurora Replica, no failover occurs. To failover an Aurora DB cluster, call the AWS CLI command failover-db-cluster, or the API action FailoverDBCluster.

You can't reboot your DB instance if it is not in the "Available" state. Your database can be unavailable for several reasons, such as an in-progress backup, a previously requested modification, or a maintenance-window action.

The time required to reboot your DB instance depends on the crash recovery process of your specific database engine. To improve the reboot time, we recommend that you reduce database activity as much as possible during the reboot process. Reducing database activity reduces rollback activity for in-transit transactions.

AWS Management Console

To reboot a DB instance

  1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

  2. In the navigation pane, choose Instances, and then select the DB instance that you want to reboot.

  3. Choose Instance actions and then choose Reboot.

    The Reboot DB Instance page appears.

  4. (Optional) Select Reboot with failover? to force a failover from one AZ to another.

  5. Choose Reboot to reboot your DB instance.

    Alternatively, choose Cancel.

CLI

To reboot a DB instance by using the AWS CLI, call the reboot-db-instance command.

Example Simple Reboot

For Linux, OS X, or Unix:

aws rds reboot-db-instance \ --db-instance-identifier mydbinstance

For Windows:

aws rds reboot-db-instance ^ --db-instance-identifier mydbinstance

Example Reboot with Failover

To force a failover from one AZ to the other, use the --force-failover parameter.

For Linux, OS X, or Unix:

aws rds reboot-db-instance \ --db-instance-identifier mydbinstance \ --force-failover

For Windows:

aws rds reboot-db-instance ^ --db-instance-identifier mydbinstance ^ --force-failover

API

To reboot a DB instance by using the Amazon RDS API, call the RebootDBInstance action.

Example Simple Reboot

https://rds.amazonaws.com/ ?Action=RebootDBInstance &DBInstanceIdentifier=mydbinstance &Version=2014-10-31 &X-Amz-Algorithm=AWS4-HMAC-SHA256 &X-Amz-Credential=AKIADQKE4SARGYLE/20131016/us-west-1/rds/aws4_request &X-Amz-Date=20131016T233051Z &X-Amz-SignedHeaders=content-type;host;user-agent;x-amz-content-sha256;x-amz-date &X-Amz-Signature=087a8eb41cb1ab5f99e81575f23e73757ffc6a1e42d7d2b30b9cc0be988cff97

Example Reboot with Failover

To force a failover from one AZ to the other, set the ForceFailover parameter to true.

https://rds.amazonaws.com/ ?Action=RebootDBInstance &DBInstanceIdentifier=mydbinstance &ForceFailover=true &Version=2014-10-31 &X-Amz-Algorithm=AWS4-HMAC-SHA256 &X-Amz-Credential=AKIADQKE4SARGYLE/20131016/us-west-1/rds/aws4_request &X-Amz-Date=20131016T233051Z &X-Amz-SignedHeaders=content-type;host;user-agent;x-amz-content-sha256;x-amz-date &X-Amz-Signature=087a8eb41cb1ab5f99e81575f23e73757ffc6a1e42d7d2b30b9cc0be988cff97