pt-online-schema-change
pt-online-schema-change: A focused open-source utility for altering large MySQL tables while clients stay active. Ranked #28 of 32 in Database Migration Tools by our editors (6.1/10); pricing: Free plan; best for mySQL teams altering large tables online.
At a glance
- Editor score6.1 / 10
- PricingFree plan
- Best forMySQL teams altering large tables online
- Free planYes
- Paid fromFree
- Founded2006
- Facts checked20 Sep 2026
Where it wins
- Copy-and-swap operations keep tables synchronized with triggers
- Lag and load controls can pause or abort operations
- Dry runs, progress reporting, resumption, and plugins support operations
Where it doesn't
- Focused on MySQL table-structure changes
- Listed platform support is limited to Linux
- Command-line operation requires database administration expertise
Our verdict on pt-online-schema-change
pt-online-schema-change is an open-source command-line utility in Percona Toolkit for modifying MySQL table structures while clients continue reading and writing. It is intended for database administrators working with large tables in self-managed or cloud-hosted environments. The utility creates and alters a copy of the table, copies rows in chunks, synchronizes ongoing changes with triggers, and swaps the new table into place after copying completes. Its published category specifications include self-hosting, SQL migration format, and CI/CD automation.
The main strength is operational control during long-running schema changes. A dry-run mode allows teams to inspect an operation before execution, while load thresholds and replication-lag checks can pause or abort the process. Progress reporting and statistics output provide visibility as rows are copied, and an interrupted operation can resume from the last completed chunk. Custom plugins and lifecycle hooks add extension points for teams with specialized migration workflows. The tool is distributed as free, open-source software, which suits organizations that prefer to run and automate database utilities within their own environments.
This narrow focus is also the key boundary. pt-online-schema-change is designed for MySQL table alterations rather than a broad database-migration suite, so teams looking for wider database coverage or a graphical migration workspace should consider a different category fit. Its Linux platform listing and command-line workflow also favor teams comfortable managing database operations directly. Choose it when online copy-and-swap changes, throttling, lag controls, and resumable execution matter; choose another tool when the priority is a broader migration surface or a less administration-oriented workflow.
Your product? Our editors can test pt-online-schema-change in depth and publish a review, labelled as paid · from $149/mo →
pt-online-schema-change pricing
pt-online-schema-change fact sheet
| Free plan | Yes |
|---|---|
| Paid from | Free |
| Rollback support | Not verified |
| Schema diff | Not verified |
| CI/CD automation | Yes |
| Supported databases | Not verified |
| Drift detection | Not verified |
| Self-hosted option | Yes |
| Migration format | Sql |
| Deployment | Self-hosted |
| Platforms | Linux |
| Support | Community, Docs |
| Built for | Mid-market, Enterprise (editorial estimate) |
| Pricing | Free plan |
| Website | docs.percona.com |
| Facts checked | 20 Sep 2026 |
Alternatives to pt-online-schema-change
- FlywayA broad migration platform with free core commands and deeper controls in paid editions.9.4
- AtlasAffordable schema automation with strong migration controls and CI/CD support.9.2
- LiquibaseA governed migration workflow with changelogs, rollback, drift detection, and a free tier.9.1
See all pt-online-schema-change alternatives →
Used pt-online-schema-change? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used pt-online-schema-change for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
pt-online-schema-change is listed in our Database Migration Tools directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/pt-online-schema-change/"><img src="https://www.itechguides.com/best/badge/pt-online-schema-change.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.
Last updated · How we research and update