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:

Query performance is essential in making any application
successful. In order to finely tune your queries you first need
to understand how MySQL executes them, and what tools are
available to help identify problems.

Some years ago, Peter Z wrote a blogpost about using MySQL Sandbox to deploy
multiple server versions. Last February,
Giuseppe introduced us to its successor: dbdeployer. In this blogpost we will demonstrate
how to use it. There is a lot of information in Giuseppe’s post, so head there if you want a
deeper dive.

First step is to install it, which is really easy to do now since
it’s developed in Go, and standalone executables are provided.
You can get the latest version …

The configuration for what information Percona Toolkit should
retrieve is not hard-coded in the scripts. Instead, it is
downloaded from v.percona.com. One of the possible parameters was
the name of a binary file to execute with “–version.” This was
fixed by removing the ability to execute arbitrary binary
files with the version parameter. You can find more information
about the benefits of …

Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.