Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

BUG: MySQL Aurora replica of RDS MySQL instance doesn't propagate permissions

0

I have a RDS Mysql Leader, followed by a RDS Mysql Replica (both 8.0.34) and a RDS Aurora replica. (8.0.mysql_aurora.3.07.0)

When I change permissions in the MySQL Leader (by deleting a row from themysql.tables_priv table), those changes get propagated to my MySQL replica but not to my Aurora Replica. Furthermore, I can't make the changes manually on the aurora replica with the admin user.

I've confirmed other changes get propagated from the leader to the aurora replica.

Is there any way of propagating these permission changes without recreating the aurora replica from scratch?

Topics
AnalyticsMigration & ModernizationDatabase
Tags
Aurora MySQLAmazon Relational Database ServiceMySQLAmazon Aurora
Language
English
asked 2 years ago919 views
1 Answer
1

Hi,

Thank you for asking your question.

Aurora MySQL logical replication support for the following Data Control Language (DCL) statements: GRANT/REVOKE and CREATE/DROP/ALTER/RENAME USER since Aurora MySQL 3.03.2. Could you please use those statement(s) to revoke the privilege(s) instead of directly delete from mysql.tables_priv table?

I hope this might help.

AWS
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content