I need to configure my Amazon Relational Database Service (Amazon RDS) DB instance read replica so that it can be written to. How can I do this?

Amazon RDS DB instance read replicas are read-only by design. In some scenarios, you might need to configure a DB instance read replica so that it is modifiable.

If you're using Amazon RDS for MySQL or MariaDB, you can configure a DB instance read replica to be read/write by setting the read_only parameter to false for the DB parameter group associated with your DB instance. The read_only parameter cannot be modified for other Amazon RDS engines, such as Amazon Aurora.

To configure your Amazon RDS DB instance read replica to be read/write, follow these steps:

1.    Create a DB parameter group for your MySQL or MariaDB instance.

2.    Modify the parameter group.

3.    Associate your RDS DB instance with the DB parameter group.

Note: If you create a DB instance without specifying a DB parameter group, a default DB parameter group is created, and default parameter groups cannot be modified. For more information about DB parameter groups, see Working with DB Parameter Groups.

Create a DB parameter group

1.    Open the Amazon RDS console.

2.    In the navigation pane, under Parameter Groups, choose Create Parameter Group.

3.    For Parameter Group Family, choose the parameter group family.

4.    For Type, choose DB Parameter Group.

5.    For Group Name, type the name of the new DB parameter group.

6.    For Description, type a description for the new DB parameter group.

7.    Choose Create.

Modify the parameter group

1.    Open the Amazon RDS console.

2.    In the navigation pane, under Parameter Groups, select the parameter group that you want to modify.

3.    Choose Edit Parameters and edit the following parameter: read_only = 0

4.    Choose Save Changes.
Note: Wait at least five minutes before creating a DB instance that uses the new DB parameter group.

Associate your RDS DB instance with the DB parameter group

1.    Open the Amazon RDS console.

2.    In the navigation pane, under Instances, select the DB instance that you want to associate with the modified DB parameter group.

3.    In the Instance Actions menu, choose Modify.

4.    Under Database Options, choose the parameter group you want to associate with the DB instance.

5.    To apply these changes, reboot the instance.
Note: The parameter group name changes immediately, but changes to the parameter are not applied until you reboot the instance without failover.


Did this page help you? Yes | No

Back to the AWS Support Knowledge Center

Need help? Visit the AWS Support Center.

Published: 2015-29-06

Updated: 2018-18-01