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:
- Create a DB parameter group for your MySQL or MariaDB instance.
- Modify the parameter group.
- 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
- Open the Amazon RDS console.
- In the navigation pane, under Parameter Groups, choose Create Parameter Group.
- For Parameter Group Family, choose the parameter group family.
- For Type, choose DB Parameter Group.
- For Group Name, type the name of the new DB parameter group.
- For Description, type a description for the new DB parameter group.
- Choose Create.
Modify the parameter group
- Open the Amazon RDS console.
- In the navigation pane, under Parameter Groups, select the parameter group that you want to modify.
- Choose Edit Parameters, and then edit the following parameter: read_only = 0
- Choose Save Changes.
Associate your RDS DB instance with the DB parameter group
- Open the Amazon RDS console.
- In the navigation pane, under Instances, select the DB instance that you want to associate with the modified DB parameter group.
- In the Instance Actions menu, choose Modify.
Note: The instance status is Modifying, and the parameter group is Applying. - Under Database Options, choose the parameter group you want to associate with the DB instance.
- 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