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

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년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인