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.

2

MySQL Security – Dual Password Support

May 19, 2020

Dual-password capability makes it possible to seamlessly perform credential changes without downtime.

2

MySQL Security – Failed-Login Tracking and Temporary Account Locking

May 12, 2020

DBA can configure user accounts such that too many consecutive login failures cause temporary account locking.

4

MySQL Security – Password Verification-Required Policy

May 5, 2020

MySQL 8.0 has introduced an optional behavior that authorize users to change their password only if they could provide the current password.

4

MySQL Security – Password Reuse Policy

April 28, 2020

MySQL provides password-reuse capability, which allows database administrators to determine the number of unique passwords a user must use before they can use an old password again.

3

MySQL Security – Password Expiration Policy

April 21, 2020

MySQL provides password-expiration capability, which enables database administrators to require that users reset their password.

3

MySQL Security – Random Password Generation

April 15, 2020

MySQL has the capability of generating random passwords for user accounts, as an alternative to requiring explicit administrator-specified literal passwords.

4

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