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

Bug: gtid-mode broken in MySQL 8.0

0

In MySQL 5.7 parameter groups, gtid-mode is modifiable. However, in MySQL 8.0 parameter groups, there are two separate gtid-mode parameters: gtid-mode and gtid_mode. Only one is modifiable, and it has no effect. The one stuck on OFF is the one that takes effect.

Edited by: PaulNamePros on Feb 11, 2019 6:22 PM

Topics
Migration & ModernizationAnalyticsDatabase
Tags
Amazon Relational Database Service
Language
English
paul
asked 5 years ago227 views
1 Answer
0

AWS support has responded that GTID mode isn't supported in 8.0 at the moment, per the note on https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/mysql-replication-gtid.html, emphasis mine:

GTID-based replication is supported for Amazon RDS MySQL version 5.7.23 and later MySQL 5.7 versions. All Amazon RDS MySQL DB instances in a replication configuration must meet this requirement. GTID-based replication is not supported for Amazon RDS MySQL 5.5, 5.6, or 8.0.

Support wasn't able to provide info on when the feature might be available.

Edited by: PaulNamePros on Feb 14, 2019 3:33 PM

paul
answered 5 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.

Guidelines for Answering Questions

Relevant content