Upgrading your MySQL Server Farm
There are several advantages to keeping up to date with the latest major versions of MySQL. To provide a short example using MySQL 5.7:
- Let application developers benefit from new functionality, e.g. JSON in 5.7
- Use your hardware infrastructure more efficiently with parallel slaves in 5.7
- Improve monitoring or management for DevOps with more performance schema instrumentation in 5.7
- Improve security by using features like transparent data encryption, firewall, auditing, and sha256 authentication in 5.7
- Keep within the EOL window for access to maintenance releases and support
This blog post explains general activities in an upgrade project and what to look out for prior to an upgrade between major MySQL Server releases.…
Source: Upgrading your MySQL Server Farm