MySQL Forums
Forum List  »  General

Temporal types and replication
Posted by: Sean Nolan
Date: October 27, 2014 10:08AM

We run MySQL on Amazon RDS and over the weekend they issued an advisory that says there is an issue with replication of datetime and timestamp columns when using row-based replication on MySQL 5.6.21 (the latest version they support), see "Replication Fails After Upgrading to MySQL Version 5.6.21" here
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_MySQL.html#MySQL.Concepts.KnownIssuesAndLimitations

Does anyone know if there are known issues with replication from a 5.6.21 master to a 5.6.21 slave when there are old format datetime or timestamp columns in a table?

We have a number of tables with datetime columns that were created on 5.5 and have not yet been updated to the new format and I'm trying to decide if we can slowly update them over time or if I should be making it a top priority to get them all updated as fast as possible (as the AWS advisory suggests).

Options: ReplyQuote


Subject
Written By
Posted
Temporal types and replication
October 27, 2014 10:08AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.