Percona Toolkit for Safer MySQL Schema Changes

Harness Database DevOps has integrated Percona Toolkit for MySQL to enable safer and more efficient schema changes, utilizing pt-online-schema-change to minimize the risks associated with native MySQL ALTER TABLE operations. This integration allows modifications to be made during business hours by creating a shadow table with the new schema and copying data over in small chunks, reducing lock time and maintaining synchronization with triggers before an atomic swap. Users can activate this feature by selecting Liquibase as the schema configuration in Harness DB DevOps and checking the option to use Percona Toolkit. However, caution is advised as certain DDL operations, like adding or dropping foreign keys, may not be suitable for this process, and proper database user privileges are necessary. This advancement aims to eliminate the need for scheduling schema changes during off-hours and encourages testing in non-critical environments before full deployment. Jesse Wang, the Product Marketing Manager for Harness Database DevOps, emphasizes the potential for zero downtime database schema migrations with this tool.