Planet MySQL HA Blog
Transaction Isolation Levels in Galera Cluster
By now you must have read our documentation on isolation levels and also our Support for Transaction Isolation Levels. It is worth noting that the default transaction isolation level in MySQL 8 is REPEATABLE READ.
Here is a simple example of this, in action (you can test this on two different nodes, even across a 9-node Galera Cluster!).
First we do some simple setup:
CREATE DATABASE isolate; USE isolate; CREATE TABLE products ( id INT PRIMARY KEY, name VARCHAR(50), price DECIMAL(10, 2)Faster MySQL Startup with Many Tables (1M+)
How to migrate a production database to Percona Everest (MySQL) using Clone
The aim of this long article is to give you the instructions and tools to migrate your production database, from your current environment to a solution based on Percona Everest (MySQL).
Nice, you decided to test Percona Everest, and you found that it is the tool you were looking for to manage your private DBaaS. For sure the easiest part will be to run new environments to get better understanding and experience on how the solution works. However, the day when you will look to migrate your existi
Check MySQL InnoDB Settings using MySQL Shell Utility
Check and review recommended MySQL InnoDB setting using MySQL Shell for optimal Performance.