Category Archives: MySQL 8

MySQL InnoDB Cluster Disaster Recovery contingency via a Group Replication Replica

Posted on 11/06/2020 by Keith Hollman

Just recently, I have been asked to look into what a Disaster Recovery site for InnoDB Cluster would look like.
If you’re reading this, then I assume you’re familiar with what MySQL InnoDB Cluster is, and how it is configured, components, etc. Continue reading →

Posted in clone, InnoDB, innodb cluster, MySQL, MySQL 8, MySQL Enterprise Edition, MySQL Enterprise Monitor, Oracle, Replication, Uncategorized | Tagged , , , , , , , , | Leave a comment

InnoDB Cluster: Recovering an instance with MySQL Enterprise Backup.

Posted on 31/05/2019 by Keith Hollman

Ok, so if you’re reading this, then I can guess you’ve got a MySQL InnoDB Cluster in an awkard shape, i.e. you need to restore a backup and add the instance back into the cluster, so we have all our instances again. Continue reading →

Posted in Backup, innodb cluster, MEB, MySQL 8, MySQL Enterprise Backup, MySQL Enterprise Edition, Oracle Linux, Recovery, Replication, Uncategorized | Tagged , , , , , , , , , | Leave a comment

MySQL TDE: Online key store migration

Posted on 11/10/2018 by Keith Hollman

So, if we’re applying GDPR to our system, and we’re already making use of MySQL Transparent Data Encryption / keyring, then here’s an example on how to migrate from filed-based keyring to the encrypted keyring. Online. Continue reading →

Posted in Backup, GDPR, MEB, MySQL, MySQL 8, MySQL Enterprise Backup, MySQL Enterprise Edition, Oracle, TDE, Uncategorized | Tagged , , , , , , | Leave a comment