Sample Header Ad - 728x90

Aurora RDS async replication to historical MySQL cluster

1 vote
1 answer
33 views
I was trying to do https://dev.mysql.com/doc/refman/8.0/en/replication-howto-masterstatus.html until the command to pause all writes gets access denied on my test db FLUSH TABLES WITH READ LOCK; Error Code 1045. Access denied for user 'admin'@'%' So in Aurora RDS, how do I pause all writes, grab the binary log filename and offset, take snapshot, and then unpause all writes? Then, I can restore the snapshot, and I hope setup to start replicating from that offset to catch up to the source database.
Asked by Dean Hiller (115 rep)
Feb 7, 2024, 09:03 AM
Last activity: Feb 7, 2024, 10:23 PM