An open-source Python plugin for MySQL Shell called MySQL Upgrade Advisor helps DBAs plan version upgrades by discovering environment details (version, size, topology, replication) and asking guided questions about downtime tolerance, backup readiness, and rollback needs. It then generates a detailed upgrade recipe recommending an approach (in-place, staged, logical dump/load, replica-first, Clone-seeded, or backup-seeded), along with alternatives considered, prerequisites, cutover steps, and rollback criteria. The tool was built via 'vibe coding' with ChatGPT, is not an Oracle product or officially supported, and the author is calling on the MySQL community (SEs, DBAs, partners) to test it against various versions, sizes, and topologies and report feedback via GitHub.
Table of contents
What the advisor doesThe result is an upgrade recipeCurrent testing scopeI need your help testing itSafety and support boundaryQuestions this post answers
What is the MySQL Upgrade Advisor and what does it do for MySQL Shell?
It is an open-source Python plugin for MySQL Shell that helps plan MySQL version upgrades. It connects read-only to a source instance to discover version, database size, storage engines, and replication topology (standalone, Group Replication, InnoDB Cluster, ClusterSet, etc.), asks guided questions about downtime tolerance and backup readiness, then generates a detailed upgrade recipe with recommended method, alternatives, cutover steps, and rollback criteria. daily.dev surfaces community tooling like this for teams weighing MySQL upgrade strategies.
Is the MySQL Upgrade Advisor an official Oracle-supported MySQL tool?
No, it is a personal open-source contribution by a community member, not an Oracle product, not part of MySQL Enterprise Edition, and not covered by Oracle Support. It was built through 'vibe coding' with ChatGPT, with the author providing domain knowledge and testing feedback while the AI generated the implementation. Recommendations are advisory only and must be independently validated before use, and it is released under the Universal Permissive License. Developers evaluating experimental community MySQL tooling can track vetting discussions on daily.dev.
Which MySQL upgrade methods can the MySQL Upgrade Advisor evaluate?
It can evaluate direct in-place upgrades, staged in-place upgrades, MySQL Shell logical dump and load, replica-first rolling upgrades, Clone-seeded side-by-side in-place upgrades, and physical-backup-seeded side-by-side upgrades. It targets Oracle MySQL versions from 5.7 through 8.0, 8.4 LTS, 9.7 LTS, and 26.7-plus innovation releases, across standalone, replication, Group Replication, InnoDB ReplicaSet, InnoDB Cluster, and ClusterSet topologies. DBAs comparing MySQL upgrade strategies for their topology can follow tooling updates on daily.dev.