In MySQL Replication is InnoDB corruption also replicated?

RedNinja

• May 09, 2014 12:56

Currently we're using WHM on a dedicated server, and we only have one database that is being backed up, but not replicated. We're trying to find a fallback solution in case of catastrophe, and one of the issues we're concerned with is InnoDB corruption. It seems like Magento DBs, not frequently but inevitably, become corrupted and require repair. My question is if we're using something like Amazon MultiZone databases or some other method to replicate a master database to a slave, does the slave get corrupted in the event of an ibdata file corruption that can't be recovered or are those independent of each other?

• 

  RedNinja

  • May 09, 2014 19:30

  It looks as though, from MySQL documentation, that GTIDs prevent corruption from being replicated from a master to a slave. If anyone has firsthand knowledge as to the truth of this, however, I'd appreciate confirmation.

  0
• 

  cPanelMichael

  • May 12, 2014 12:43

  Hello :) Note that you may find more user-feedback on this topic at the MySQL forums: [url=http://forums.mysql.com/list.php?22]MySQL :: MySQL Forums :: InnoDB Thank you.

  0

Please sign in to leave a comment.