What's new in MySQL 8
Compared to MySQL 5.6, MySQL 5.7 and MySQL 8 have some nice features you might want to use. For example:
- Improved JSON support: Directly manipulate JSON data within your MySQL database
- Emoji support: 🤩
- Better handling of GeoSpatial data types for working with geographic data
Many of our clients are using a CMS like Craft CMS or WordPress. In that case, you might not need to bother too much about this. For Symfony or Laravel users building custom applications the new features might come in handy, and the effort required to update your application might be worth the time.
- All existing Pro Apps will stay on MySQL 5.6 (for now)
- All new Apps created on the Pro Stack will run on MySQL 8
- To upgrade your App see the Upgrade section below
- Universal Apps will receive the same upgrade at a later date when we have ensured that everything works well
- We plan to phase out MySQL 5.6 at some point (see EOL section below)
We recommend the following workflow to get your App up and running with the new version of MySQL:
- Create a new App with the fortrabbit Dashboard
- Push your existing code to the new App (and import database)
- (Update your local development environment setup to MySQL 8)
- Test if everything is working correctly
- Once you know it works, switch the domain
- After that, delete the old App - it's not required any more
Please ping us if your have any questions along the way. We are also happy to give you an individual discount so that you don't have to pay double during the migration period.
Take this as an opportunity to update the rest of your application as well.
We will eventually switch off MySQL 5.6 at some point. The official End Of Life for MySQL 5.6 is February 2021. We plan to support it longer than that, but no date for deprecation has been set yet. Further communication from us on the topic will follow.
Heads-up for Sequel Pro users
On macOS the free MySQL client Sequel Pro is very popular. There are some issues with MySQL 8 and Sequel Pro: see this StackOverflow question.
We suggest using a different local MySQL client. Sequel Ace is a Sequel Pro fork with MySQL 8 support, for example.