MySQL SHELL – The new era

December 17, 2020

In one of our previous articles – Setting up Replication with various methods for MySQL 8 – we reviewed how to create a replica with multiple tools.
Now, it is time to perform the same action but with MySQL Shell.

4

Automatic connection failover for Asynchronous Replication

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.

4

MySQL 8.0.18 New Features Summary

November 26, 2019
Tags: , ,

Presentation of some of the new features of MySQL 8.0.18 released on October 14, 2019.

3

MySQL 8.0.17 – New Features Summary

September 19, 2019

This presentation is a summary of the MySQL 8.0.17 new features.

3

MySQL InnoDB Cluster – Easy Recovering and provisioning

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.

1

MySQL InnoDB Cluster – Recovering and provisioning with MySQL Enterprise Backup

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.

2

MySQL InnoDB Cluster – Recovering and provisioning with mysqldump

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 🙂

2

MySQL 8.0.16 New Features Summary

June 5, 2019

Presentation of some of the new features of MySQL 8.0.16 released on April 25, 2019

4

MySQL InnoDB Cluster – HowTo #2 – Validate an instance

May 21, 2019

Q: Validate an instance for MySQL InnoDB Cluster usage?

A: Use check_instance_configuration()

1

MySQL InnoDB Cluster – HowTo #1 – Monitor your cluster

April 11, 2019

MySQL InnoDB Cluster – HowTo #1 – Monitor your cluster

Q: How do I monitor the status & the configuration of my cluster?

A: Use status() or status({extended:true}) or status({queryMembers:true})?

5