Our product is an enterprise application with MySQL Enterprise version 5.5.42 deployed in many customer datacenters. We're planning to migrate the MySQL db (bundled with our product) to version 5.7.13. So, when our customers upgrade from X version of product to Y version of our product, we need to upgrade their MySQL 5.5.42 to 5.7.13. Customers would hate to have downtime on this important software.
It appears that we need to migrate first to 5.6 and then to 5.7.
Some questions regarding the upgrade:
- Is there a way to have zero downtime without requiring duplicate hardware?
- Are there ways to reduce the downtime to a minimum ? If yes, what additional storage requirements will this add?
What else should I know?