pt-online-schema-change
5.8#22 in database migration toolsFree planFree planLinuxSelf-hosted
Visitpt-online-schema-change vs Skeema
What both publish
| Fact | pt-online-schema-change | Skeema |
|---|---|---|
| Founded | 2006 | 2016 |
| Intended users | Percona describes the Toolkit as advanced open-source command-line tools for DBAs and database operations. | Skeema Community is described as free open-source software, while Premium Plus is positioned for startups and smaller teams and Max for larger organizations. |
| Purpose | pt-online-schema-change alters MySQL table structures without blocking reads or writes by building and populating a copy of the table, then replacing the original. | Skeema is a declarative SQL-based schema management utility that applies changes expressed as CREATE statements in a repository to MySQL and MariaDB tables and routines. |
| Support | Percona says its Community Forum service is free and response times vary with the complexity of the question. | Public technical support is available to all CLI users through GitHub issues, while private technical support is included with Max. |
pt-online-schema-change plans
- Percona Toolkit (includes pt-online-schema-change)Free
Skeema plans
- CommunityFree
- Plus$124 a month
- Max$499 a month
- Skeema Cloud Linter$649 a year
- Plus$1,238 a year
- Max$4,988 a year
Pick pt-online-schema-change if…
This tool suits database administrators and database operations teams changing MySQL tables who need reads and writes to continue during the process. It is aimed at users comfortable with command-line tools and its database requirements.
Pick Skeema if…
Skeema suits teams managing MySQL or MariaDB schema changes through SQL files and repository workflows. Its sharding and drift features may be useful where schemas span multiple servers or databases.