-
Archives
-
Meta
Category Archives: MySQL 8
MySQL InnoDB Cluster Disaster Recovery contingency via a Group Replication Replica
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 8.0.20, disaster recovery, group replication, MySQL, MySQL Enterprise Monitor, mysql innodb cluster, mysql router, mysql shell, mysql_clone
Leave a comment
InnoDB Cluster: Recovering an instance with MySQL Enterprise Backup.
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 enterprise backup, innodb cluster, instance restore, MEB, MySQL, MySQL Enterprise Backup, MySQL Enterprise Edition, mysql innodb cluster, mysqlbackup, Recovery
Leave a comment
MySQL TDE: Online key store migration
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