Error saving: Wrong parameter value '"mysql' for parameter replicate-ignore-dbDatabase names in filter value shouldn't exceed 64 symbols

0

Hi,

I have an RDS instance for MySQL 5.7. I'm want to set mysql, information_schema and performance_schema databases to ignore by replication in my custom parameter group. But when I try to put mysql database string in the value I receive an error:

Error saving: Wrong parameter value 'mysql' for parameter replicate-ignore-dbDatabase names in filter value shouldn't exceed 64 symbols. Supported characters includes all ASCII alphanumeric characters, _, $ and U+0080 .. U+FFFF unquoted or any characters in quotes (excluding commas). (Service: AmazonRDS; Status Code: 400; Error Code: InvalidParameterValue; Request ID: 9ffd2357-2d96-4870-8476-07c886220cd7; Proxy: null)

P.S. Parameter changing works with information_schema and performance_schema, but not when string contain mysql database

rk
已提问 2 年前837 查看次数
1 回答
0

Dear Customer,

I understand that you want to set the parameters 'replicate-ignore-db' to 'mysql' in order to ignore the 'mysql' system database in AWS RDS instance running database MySql version 5.7. However when attempting to set the parameters an error occurs stating the following:

Error saving: Wrong parameter value 'mysql' for parameter replicate-ignore-dbDatabase names in filter value shouldn't exceed 64 symbols. Supported characters includes all ASCII alphanumeric characters, _, $ and U+0080 .. U+FFFF unquoted or any characters in quotes (excluding commas). (Service: AmazonRDS; Status Code: 400; Error Code: InvalidParameterValue; Request ID: 9ffd2357-2d96-4870-8476-07c886220cd7; Proxy: null)

The above error indicates that it is not possible to set 'replicate-ignore-db' to ignore the 'mysql' system database. This is because RDS makes use of certain 'mysql' system database tables for monitoring and architectural purposes. It is thus currently not possible to set the 'replicate-ignore-db' parameter to ignore the 'mysql' system database in AWS RDS.

I hope the above provided information is clear and helpful.

AWS
Omkar_S
已回答 2 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则