dasini.net – Diary of a MySQL expert

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.

I’ve made a short video that will give you tips and tricks to successfully upgrade to MySQL 8

Presentation of some of the new features of MySQL 8.0.21 released on July 13th, 2020.

Presentation of some of the new features of MySQL 8.0.20 released on April 27th, 2020.

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

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

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

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.

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

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