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.
With MySQL 5.5,
pt-online-schema-change from Percona
Toolkit is your best option for large tables while regular
ALTER TABLE statements are only acceptable for small
tables. Also beware of metadata locks.
With MySQL 5.6, almost all types of …[Read more...]