Innotop for MySQL 8.0
Recently, I did some maintenance on Innotop and I merged several pull requests including one to support MySQL 8.0 (thank you yoku0825 for the contribution). As you know, Innotop is written in Perl and to be able to use it…
Category MySQL
Deploy an Asynchronous Replication setup with MySQL 8.0 in 2 mins
There are multiple way to setup replication with MySQL 8.0 and our replication offer as never been so rich: asynchronous, semi-synchronous, group replication, multi-source, … and much more options ! But if you want to setup a very quick Master-Replics…
MySQL and Memory: a love story (part 2)
We saw in the previous post that MySQL likes memory. We also saw how to perform operating system checks and some configuration changes for Swap and NUMA. Today, we will check what MySQL server can tell us about its memory…
MySQL and Memory: a love story (part 1)
As you may know, sometimes MySQL can be memory-hungry. Of course having data in memory is always better than disk… RAM is still much faster than any SSD disk. This is the reason why we recommended to have the working…
sysbench for MySQL 8.0
Alexey made this amazing tool that the majority of MySQL DBAs are using, but if you use sysbench provided with your GNU/Linux distribution or its repository on packagecloud.io you won’t be able to use it with the new default authentication…
