Dr. Mario's 2nd 🧠

Home

❯

pages

❯

MySQL replication

MySQL replication

1 min read

  • Typically you will want the MIXED format (vs. statement-based and row-based). Mixed format is kind of the best of both worlds (safer than statement-based but doesn’t generate as much data as row-based).
  • In Aurora, gtid_mode in 5.7 is defined as OFF_PERMISSIVE, while in 5.6 it is OFF. Theoreticaly, according to MySQL :: MySQL 5.7 Reference Manual :: 16.1.4.1 Replication Mode Concepts, you should be able to replicate from an OFF_PERMISSIVE in 5.7 to a 5.6 in OFF, but it’s not true: MySQL Bugs: #75769: 5.6 with GTID_MODE=X cant connect to 5.7.6 with GTID_MODE=X_PERMISSIVE.

Webmentions

Loading webmentions...

Unable to load webmentions. Please try again later.

❤️ Likes

🔄 Reposts

💬 Replies

🔗 Mentions

No webmentions found for this post yet. Be the first to mention it!

Graph View

Created with Quartz v4.5.1 © 2025