# How to make database schema changes without downtime in MySQL: complete guide

DevFeed: [How to make database schema changes without downtime in MySQL: complete guide](<https://devfeed.tech/articles/how-to-make-database-schema-changes-without-downtime-in-mysql-complete-guide-85267.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/databases/mysql/how-to-make-database-schema-changes-without-downtime-in-mysql-complete-guide/>)

Author: Lukas Vileikis

Published: 2026-10-12T12:00:00Z

Content type: tutorial

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [Database Migration](<https://devfeed.tech/topics/database-migration.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [zero downtime deployment](<https://devfeed.tech/topics/zero-downtime-deployment.md>), [Percona Server for MySQL](<https://devfeed.tech/topics/percona-server-for-mysql.md>)

Tags: [database](<https://devfeed.tech/tags/database.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [database-schema](<https://devfeed.tech/tags/database-schema.md>), [databases](<https://devfeed.tech/tags/databases.md>), [downtime](<https://devfeed.tech/tags/downtime.md>), [featured](<https://devfeed.tech/tags/featured.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [online-ddl](<https://devfeed.tech/tags/online-ddl.md>), [percona](<https://devfeed.tech/tags/percona.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

This guide explains how to reduce downtime when changing MySQL database schemas. It covers causes of disruption, built-in online DDL, and tools such as Percona Toolkit and gh-ost, with the method depending on the change and use case.

## Source excerpt

Learn how to make MySQL schema changes without downtime. Compare online DDL, Percona Toolkit, and gh-ost to keep your database available during updates.... The post How to make database schema changes without downtime in MySQL: complete guide appeared first on Simple Talk.