Tag - schema change inconsistencies

13 Mar 2019

Live MySQL Slave Rebuild with Percona Toolkit

By Vinicius Grippa MySQL, Percona Software , , , , 3 Comments
MySQL slave data out of sync

Recently, we had an edge case where a MySQL slave went out-of-sync but it couldn’t be rebuilt from scratch. The slave was acting as a master server to some applications and it had data was being written to it. It was a design error, and this is not recommended, but it happened. So how do […]

Read more
21 Jul 2014

A schema change inconsistency with Galera Cluster for MySQL

By Stephane Combaudon Insight for DBAs, MySQL, Percona Software , , 8 Comments

I recently worked on a case where one node of a Galera cluster had its schema desynchronized with the other nodes. And that was although Total Order Isolation method was in effect to perform the schema changes. Let’s see what happened.
Background
For those of you who are not familiar with how Galera can perform schema […]

Read more

Upcoming Webinars

All Webinars »


MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners. Proudly running Percona Server for MySQL. Copyright © 2006-2019 Percona LLC.

Terms of Use | Privacy | Copyright | Legal