Galera Cluster Enterprise Edition (EE) has had support for Non-Blocking Operations (NBO) schema upgradesever since the first release of Galera Cluster Enterprise Edition (EE). It is reasonably well documented, and we think more people will benefit from using it, of course. Schema changes tend to always remain a daunting task when you have large databases to manage.
To compare between Total Order Isolation (TOI), the default, with NBO that is available in Galera Cluster Enterprise Edition (EE), we create a test table:
CREATE TABLE large;
USE large;
CREATE TABLE test_table (
id INT PRIMARY KEY AUTO_INCREMENT,
data VARCHAR(255),
num1 INT,
num2 INT,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
Then we …
[Read more]