-
Archives
-
Meta
Category Archives: InnoDB
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
Upgrading MySQL to 8.0.12 with Audit plugin.
As a spin-off from the previous post, https://mysqlmed.wordpress.com/2018/08/23/get-the-auditors-in/, I thought that it would be good to see how well the Audit plugin upgrades to MySQL 8. The big change in auditing is that the tables change from MyISAM to InnoDB, … Continue reading
Get the Auditors in: MySQL Enterprise Audit.
Here I have been looking into using the MySQL Enterprise Edition Audit Log plugin for 5.7. We have many options to audit (filters, encryption, compression, Workbench, rotation & purging, viewing the log, etc.)…. Continue reading
Posted in InnoDB, MySQL, MySQL Enterprise Edition, Oracle, Uncategorized, upgrade
Tagged audit, audit plugin, audit.log, audit_log_filter_set_filter, filters, MySQL, MySQL Enterprise Edition
4 Comments
InnoDB Cluster: setting up Production… for disaster! (2/2)
Ok, so now we’re got our InnoDB Cluster a-clustering, MySQL Router a-routing, now we need some disaster to be a-disaster-recovering… Continue reading
Posted in Backup, InnoDB, innodb cluster, MEB, MySQL, MySQL Enterprise Backup, MySQL Enterprise Edition, numactl, Oracle Linux, PITR, Recovery, Replication
Tagged Database, InnoDB, Linux, MySQL, Oracle, Replication, restore
3 Comments
InnoDB Cluster: setting up Production… for disaster! (1/2)
Want to setup InnoDB Cluster and be prepared for a Disaster Recovery scenario? Get ready: Here’s a way to set up InnoDB Cluster using the 3 environments, on Oracle Linux 7.2, 5.7.19 MySQL Commercial Server, MySQL Shell 8.0.3 DMR, MySQL … Continue reading
Posted in Backup, InnoDB, innodb cluster, MEB, MySQL, MySQL Enterprise Backup, MySQL Enterprise Edition, numactl, Oracle, PITR, Recovery
Tagged Database, group replication, InnoDB, innodb cluster, Linux, MySQL, mysql router, mysql shell, Oracle, python, Replication, restore
1 Comment