by Marco Tusa | Apr 22, 2022 | Cloud, Insight for DBAs, MySQL, Percona Software
In the last quarter of 2021, AWS released Aurora version 3. This new version aligns Aurora with the latest MySQL 8 version, porting many of the advantages MySQL 8 has over previous versions. While this brings a lot of new interesting features for Aurora, what we are...
by Marco Tusa | Jan 11, 2022 | MySQL, Percona Software
In April 2021, I wrote an article about Online DDL and Group Replication. At that time we were dealing with MySQL 8.0.23 and also opened a bug report which did not have the right answer to the case presented. Anyhow, in that article I have shown how an online DDL was...
by Marco Tusa | Dec 9, 2021 | Insight for DBAs, MySQL, Percona Software
Percona XtraDB Cluster 8.0.25 (PXC) has introduced a new option to perform online schema modifications: NBO (Non-Blocking Operation). When using PXC, the cluster relies on the wsrep_OSU_method parameter to define the Online Schema Upgrade (OSU) method the node uses to...
by Uday Varagani | Jun 7, 2019 | MySQL
Foreign key related issues are very common when dealing with DDL changes in MySQL using Percona toolkit. In this blog post, I will explain how the tool (pt-online-schema-change) handles foreign key constraints when executing a DDL change. First of all, I would like to...
by Przemysław Malkowski | Mar 25, 2019 | Insight for DBAs, MySQL, Percona Software
If you are using Galera replication, you know that schema changes may be a serious problem. With its current implementation, there is no way even a simple ALTER will be unobtrusive for live production traffic. It is a fact that with the default TOI alter method,...
by Przemysław Malkowski | Jul 5, 2013 | Insight for DBAs, MySQL
Among many of the improvements you can enjoy in MySQL 5.6, there is one that addresses a huge operational problem that most DBAs and System Administrators encounter in their life: schema changes. While it is usually not a problem for small tables or those in early...
by Stewart Smith | Apr 8, 2013 | MySQL
This post was initially going to be two sets of polls: “What is the maximum number of columns in MySQL?” and “What is the minimum maximum number of columns in MySQL?”. Before you read on, ponder those questions and come up with your own...
by Ovais Tariq | Feb 1, 2013 | Insight for DBAs, Insight for Developers, MySQL
While most of the talk recently has mostly been around the new changes in MySQL 5.6 (and that is understandable), I have had lately some very interesting cases to deal with, with respect to the Metadata Locking related changes that were introduced in MySQL 5.5.3. It...
