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

Renaming a DB Instance

You can rename a DB instance by using the AWS Management Console, the AWS CLI modify-db-instance command, or the Amazon RDS API ModifyDBInstance action. Renaming a DB instance can have far-reaching effects; the following is a list of things you should know before you rename a DB instance.

  • When you rename a DB instance, the endpoint for the DB instance changes, because the URL includes the name you assigned to the DB instance. You should always redirect traffic from the old URL to the new one.

  • When you rename a DB instance, the old DNS name that was used by the DB instance is immediately deleted, although it could remain cached for a few minutes. The new DNS name for the renamed DB instance becomes effective in about 10 minutes. The renamed DB instance is not available until the new name becomes effective.

  • You cannot use an existing DB instance name when renaming an instance.

  • All read replicas associated with a DB instance remain associated with that instance after it is renamed. For example, suppose you have a DB instance that serves your production database and the instance has several associated read replicas. If you rename the DB instance and then replace it in the production environment with a DB snapshot, the DB instance that you renamed will still have the read replicas associated with it.

  • Metrics and events associated with the name of a DB instance will be maintained if you reuse a DB instance name. For example, if you promote a Read Replica and rename it to be the name of the previous master, the events and metrics associated with the master will be associated with the renamed instance.

  • DB instance tags remain with the DB instance, regardless of renaming.

  • DB snapshots are retained for a renamed DB instance.

Renaming to Replace an Existing DB Instance

The most common reasons for renaming a DB instance are that you are promoting a Read Replica or you are restoring data from a DB snapshot or PITR. By renaming the database, you can replace the DB instance without having to change any application code that references the DB instance. In these cases, you would do the following:

  1. Stop all traffic going to the master DB instance. This can involve redirecting traffic from accessing the databases on the DB instance or some other way you want to use to prevent traffic from accessing your databases on the DB instance.

  2. Rename the master DB instance to a name that indicates it is no longer the master as described later in this topic.

  3. Create a new master DB instance by restoring from a DB snapshot or by promoting a read replica, and then give the new instance the name of the previous master DB instance.

  4. Associate any read replicas with the new master DB instance.

If you delete the old master DB instance, you are responsible for deleting any unwanted DB snapshots of the old master instance.

For information about promoting a Read Replica, see Promoting a Read Replica to Be a DB Instance.

AWS Management Console

To rename 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, select DB Instances.

  3. Select the check box next to the DB instance you want to rename.

  4. From the Instance Actions dropdown menu, select Modify.

  5. Enter a new name in the DB Instance Identifier text box. Select the Apply Immediately check box, and then click Continue.

  6. Click Modify DB Instance to complete the change.

CLI

To rename a DB instance, use the AWS CLI command modify-db-instance. Provide the current --db-instance-identifier value and --new-db-instance-identifier parameter with the new name of the DB instance.

Example

For Linux, OS X, or Unix:

Copy
aws rds modify-db-instance \ --db-instance-identifier DBInstanceIdentifier \ --new-db-instance-identifier NewDBInstanceIdentifier

For Windows:

Copy
aws rds modify-db-instance ^ --db-instance-identifier DBInstanceIdentifier ^ --new-db-instance-identifier NewDBInstanceIdentifier

API

To rename a DB instance, call Amazon RDS API function ModifyDBInstance with the following parameters:

  • DBInstanceIdentifier = existing name for the instance

  • NewDBInstanceIdentifier = new name for the instance

Copy
https://rds.amazonaws.com/ ?Action=ModifyDBInstance &DBInstanceIdentifier=mydbinstance &NewDBInstanceIdentifier=mynewdbinstanceidentifier &Version=2012-01-15 &SignatureVersion=2 &SignatureMethod=HmacSHA256 &Timestamp=2012-01-20T22%3A06%3A23.624Z &AWSAccessKeyId=<AWS Access Key ID> &Signature=<Signature>

Related Topics