Recently, I saw many interest in understanding and getting information about database locking. MySQL InnoDB’s locking can be complex and having an overview not always simple. For more information about how InnoDB locking is working, I can only recommend this…
MySQL InnoDB Cluster is the official High Availability solution for and from MySQL. MySQL InnoDB Cluster is composed by MySQL Server, MySQL Group Replication, MySQL Router and MySQL Shell. Before InnoDB Cluster there was no standard solution for MySQL Availability…
When you use MySQL Shell with extra Python plugins (like these available on GitHub), sometimes, you could need extra Python modules. Some of my plugins require requests and prettytable for example. MySQL 8.0.26 uses embedded Python 3.9 and if your…
I’m active on multiple platforms (mail, slack, forums, …) and often, when people are looking for help, the first 5 or 10 questions are always the same: which version of MySQL are you running ? which OS ? is it…
In previous posts we already saw how to export data from PostgreSQL and AWS RedShift, and import it on MySQL Database Service in OCI using MySQL Shell importTable utility: How to import data from PostgreSQL to MySQL Database Service How…