Help with replication filters - RDS Mysql

Question

Hello,

We are trying setup a read replica with specific usecase. For that usecase, we need to replicate the subset of database tables and not all tables. We are trying to achive this selective table replication using replication filter.

As per documentation, these parameters should be available in parameter group configuration file.
But we are unable to find these parameters.

An error occurred (InvalidParameterValue) when calling the ModifyDBParameterGroup operation: Could not find parameter with name: replicate-do-table

AWS Documentation : https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_MySQL.Replication.ReadReplicas.html#USER_MySQL.Replication.ReadReplicas.ReplicationFilters.Configuring

Requesting your assistance regarding same.
Thanks

Accepted Answer

Hello.

I checked the parameters from the management console, and the parameters exist.  
Try changing it from the management console.  
![a](/media/postImages/original/IMldF5h60HReSDCEaU4J6Lgg)

We also confirmed that changes can be made using the AWS CLI.  
Make sure the parameter group you are specifying is for MySQL.  
```
aws rds modify-db-parameter-group \
  --db-parameter-group-name test-mysql \
  --parameters "ParameterName=replicate-do-table,ParameterValue='mydb1.table1,mydb1.table2',ApplyMethod=immediate"
```

Help with replication filters - RDS Mysql

相關內容