As you may have noticed by now, we are continuously improving and enhancing the experience of managing a MySQL server. Furthermore, we have also released tools, such as MySQL shell, that make advanced and distributed setups like creating, deploying, and running clusters of InnoDB instances, seamless to the end user.…
Tweet Google Plus Share
We are less than 48h before the more and more popular pre-FOSDEM MySQL Day !
Unfortunately one of our speaker won’t be able to deliver his talk. Indeed, Giuseppe had ton cancel is talk on containers (Automating MySQL operations with containers) but he will be present during the day and during the Community Dinner, so if you have questions, I’m sure he will gladly answer them.
So we have replace this great speaker by another great one: Shlomi Noach !
Shlomi will present a very new session: Un-split brain (aka Move Back in Time) MySQL.
Here is the updated …
[Read more]Replication topologies, whether master-slave or group replication setups, may be composed of servers using different MySQL versions.
In MySQL 8.0.14, each transaction’s immediate and original server versions are now visible in the binary log as session variables. These two new variables, fully managed by the replication infrastructure, are used to support cross-version replication by transmitting the MySQL server release numbers associated with each transaction through the replication topology:
…
As we showed on the introduction post, in MySQL 8.0.14 Group Replication was once again improved. Now the developer can specify which is the consistency level of all group transactions or even of a single transaction.
Note that this is about consistency in terms of the global synchronization of transactions in the group.…
The MySQL Group Replication (GR) feature is a multi-primary update anywhere or single-primary replication plugin for MySQL with built-in conflict detection and resolution, automatic distributed recovery, and group membership.
Its goal it is to make high-availability (HA) simple with off-the-shelf hardware, not only to new applications but also existing ones – that was one of the motivations of the single-primary mode.…
The encrypted binary log file format introduced in MySQL version 8.0.14 was designed to allow a “manual” decryption of the file data when the value of the key that encrypted its file password is known.
Each encrypted binary (or relay) log file is composed by an encrypted binary log file header and the encrypted binary log content (the file data).…
Starting in version 8.0.14, MySQL server can encrypt all new binary and relay
log files on disk. In order to do so, you just need to enable
the new binlog_encryption option (and also
ensure that you have a keyring).…
MySQL 8.0.14 is out and it contains some new and very interesting replication enhancements. As always, we are very pleased to share with you the details about the exciting new features in this release.
This blog post will provide you a summary of the features and subsequent blog posts will dive into the mechanics and details of each one.…
Some time ago I wrote a script to manage asynchronous replication links between Percona XtraDB clusters. The original post can be found here. The script worked well with Percona XtraDB Cluster but it wasn’t working well with MariaDB®. Finally, the replication manager works with MariaDB.
First, let’s review the purpose of the script. Managing replication links between Galera based clusters is a tedious task. There are many potential slaves and many potential masters. Furthermore, each replication link must have only a single slave. Just try to imagine how you would maintain the following replication topology:
A complex replication topology
The above topology consists of five clusters and four …
[Read more]I had the pleasure to receive a nice educative video from my colleague Narendra Singh Chauhan, working in the QA team for MySQL Replication.
If you are curious to understand how all this works, please take a look at the video, like it and share it