November 5, 2020
Since MySQL 8.0.22 there is a mechanism in asynchronous replication that makes the receiver automatically try to re-establish an asynchronous replication connection to another sender, in case the current connection gets interrupted due to the failure of the current sender.
Like this:
Like Loading...
February 17, 2020
Presentation of some of the new features of MySQL 8.0.19 released on January 13, 2020.
Like this:
Like Loading...
December 16, 2019
This webinar will cover the advantages and process for migrating from MariaDB/Galera cluster to MySQL InnoDB Cluster.
Like this:
Like Loading...
November 26, 2019
Presentation of some of the new features of MySQL 8.0.18 released on October 14, 2019.
Like this:
Like Loading...
September 19, 2019
This presentation is a summary of the MySQL 8.0.17 new features.
Like this:
Like Loading...
September 10, 2019
Up to MySQL 8.0.16, to perform these tasks you could:
– Use MySQL Enterprise Backup :
– Use mysqldump
Starting with MySQL 8.0.17, the easiest and recommended method is to use the CLONE feature.
Like this:
Like Loading...
July 11, 2019
Like I stated in my previous article – MySQL InnoDB Cluster – Recovering and provisioning with mysqldump :
“As the administrator of a cluster, among others tasks, you should be able to restore failed nodes and to add (or remove) new nodes”.
Well, I still agree with myself 🙂
MySQL customers using a Commercial Edition have access to MySQL Enterprise Backup (MEB) which provide enterprise-grade physical backup and recovery for MySQL.
MEB delivers hot, online, non-blocking backups on multiple platforms including Linux, Windows, Mac & Solaris.
Like this:
Like Loading...
July 9, 2019
As the administrator of a cluster, among other tasks, you should be able to restore failed nodes and grow (or shrink) your cluster by adding (or removing) new nodes.
In MySQL, as a backup tool (and if your amount of data is not too big), you can use mysqldump a client utility that performs logical backups.
The results are SQL statements that reproduce the original schema objects and data.
For substantial amounts of data however, a physical backup solution such as MySQL Enterprise Backup is faster, particularly for the restore operation.
But this is the topic of my next blog post 🙂
Like this:
Like Loading...
June 5, 2019
Presentation of some of the new features of MySQL 8.0.16 released on April 25, 2019
Like this:
Like Loading...
May 21, 2019
Q: Validate an instance for MySQL InnoDB Cluster usage?
A: Use check_instance_configuration()
Like this:
Like Loading...