January 26, 2021
MySQL Replication is a very common topology, widely used in various architecture.
People use it, among others, for High Availability, Read Scalability or Geographic Redundancy.
Another use case is to use MySQL Replication to seamlessly integrate a newer version of the server in your architecture.
Let’s say you are running MySQL 5.7 then you can easily setup a 8.0 instance as a replica of your 5.7.
Extending this idea it is also possible to replicate your MySQL 5.7 (or 8.0 obviously) to a MySQL Database Service instance, the true MySQL PaaS on Oracle Cloud Infrastructure.
Like this:
Like Loading...
Filed under:
MySQL by Olivier DASINI
December 10, 2020
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
Like this:
Like Loading...
November 10, 2020
Presentation of some of the new features of MySQL 8.0.22 released on October 19th, 2020.
Like this:
Like Loading...
Filed under:
MySQL,
New by Olivier DASINI
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...
October 21, 2020
I’ve made a short video that will give you tips and tricks to successfully upgrade to MySQL 8
Like this:
Like Loading...
August 27, 2020
Presentation of some of the new features of MySQL 8.0.21 released on July 13th, 2020.
Like this:
Like Loading...
Filed under:
MySQL,
New by Olivier DASINI
May 26, 2020
Presentation of some of the new features of MySQL 8.0.20 released on April 27th, 2020.
Like this:
Like Loading...
May 19, 2020
Dual-password capability makes it possible to seamlessly perform credential changes without downtime.
Like this:
Like Loading...
May 12, 2020
DBA can configure user accounts such that too many consecutive login failures cause temporary account locking.
Like this:
Like Loading...
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.
Like this:
Like Loading...