Tag - schema changes

How pt-online-schema-change Handles Foreign Keys

pt-online-schema-change

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 explain why foreign keys have to be handled at all before […]

Read more

Using gh-ost with Amazon Aurora for MySQL

gh-ost online schema change

In this day and age of agile methodologies and fast-paced development methods, database schema changes are as inevitable as the growth of data. We have been thoroughly familiar with the effectivity of pt-online-schema-change for the last couple of years but it has one limitation. If the table is too hot to acquire metadata locks […]

Read more

Schema changes in MySQL for OpenStack Trove users

People using OpenStack Trove instances can hit a common issue in the MySQL world: how to perform schema change operations while minimizing the impact on the database server? Let’s explore the options that can allow online schema changes.
Summary
With MySQL 5.5, pt-online-schema-change from Percona Toolkit is your best option for large tables while regular ALTER […]

Read more