Christiaan shows you how
to make your RDS MySQL
read replica writeable

Christiaan_CPT1018

I need to perform both read and write operations in my Amazon Relational Database Service (Amazon RDS) for MariaDB or MySQL DB instance read replica. 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 the replica 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 that is associated with your DB instance. The read_only parameter can't be modified when using 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 can't be modified. If you already have a custom parameter group that is associated with the instance, you don't need to create a new parameter group. 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 then edit the following parameter: read_only = 0
  4. Choose Save Changes.

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.
    Note: The instance status is Modifying, and the parameter group is Applying.
  4. Under Database Options, choose the parameter group you want to associate with the DB instance.
  5. After the instance status is Available and the parameter group is Pending-reboot, reboot the instance without failover.
    Note: The parameter group name changes immediately, but changes to the parameter aren't 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-10-31