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

Setting up Replication with various methods for MySQL 8

December 10, 2020

In the world of the Databases, one of the most important value that we are all trying to achieve is High Availability. Not to loose our valuable data or in case one server fails to always have another to step in and take control.

So, it is critical to have along with our primary database, other identical instances, the replicas.

On this blog post, we will see the most famous ways to set up our replication.

6

Create a Cloud Backup with MySQL Enterprise Backup

December 10, 2020
Tags: ,

Cloud backup is a strategy increasingly used in organizations. Send copies of your data to the cloud, can help you to prevent a devastating IT crisis and ensure business continuity.

Currently, MySQL Enterprise Backup supports the following types of cloud storage services:

– Oracle Cloud Infrastructure (OCI) Object Storage

– OpenStack Swift or compatible object storage services

– Amazon Simple Storage Service (S3) or compatible storage service

Comments Off on Create a Cloud Backup with MySQL Enterprise Backup

MySQL 8.0.22 New Features Summary

November 10, 2020

Presentation of some of the new features of MySQL 8.0.22 released on October 19th, 2020.

Comments Off on MySQL 8.0.22 New Features Summary

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

Plan your MySQL upgrade

October 21, 2020

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

Comments Off on Plan your MySQL upgrade

MySQL 8.0.21 New Features Summary

August 27, 2020

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

1

MySQL 8.0.20 New Features Summary

May 26, 2020

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

3

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