MySQL Database on Azure supports version 5.7!

MySQL Database on Azure is now fully open to support for 5.7. From the admin portal, you can choose the 5.7 version to experience when the MySQL database server is created. MySQL version 5.7 is currently the latest version of MySQL, not only in a certain scenario has a great performance improvement, but also added and improved a lot of features, mainly including the native JSON data format support, and built-in JSON functions to facilitate the document storage query update, while increasing the support for GIS and so on. Visit MySQL Database on Azure to learn more.

How do I create an instance of MySQL 5.7 on the admin portal?

On the admin portal, click "New" in the bottom left corner, select MySQL Database on Azure for quick creation and select 5.7 in MySQL version.

I already have MySQL on Azure db instance, but 5.5 or 5.6 version, how should I upgrade to 5.7?

It is recommended that you understand the 5.7 release before you upgrade, and then upgrade your version after testing the application and database compatibility. If you are a production environment, it is recommended that you upgrade your database during lower business hours by following these steps:

Step 1. Optionally, if you are concerned about the impact of the post-upgrade compatibility issue on your production environment, you can use the Database recovery feature to restore the current database to a new instance, as described in how to restore the MySQL databases on Azure backup and recovery. It is recommended that you take a snapshot of the current database server using the immediate Backup feature, and then restore the snapshot on another new instance.

Step 2. Export the current database server data: You can use MySQL management tools, such as MySQL Workbench, or MySQL utility:mysqldump to export the database to the current database server:mysqldump--databa SES < database name >--single-transaction--order-by-primary-r < backup file name >--routines-h< server address >-p< port number >–u < user name >-p< password >.

Step 3. On the Admin portal, create 5.7 instances and create an account: On the admin portal, click "New" in the bottom left corner, select MySQL Database on Azure for quick creation and select 5.7 in MySQL version. And the accounts in the original DB instance are created through the management portal.

Step 4. importing data into 5.7 instances you can use the MySQL Common management tool Workbench or use SQL statements: Source < backup file name >, Data Import. After you complete the steps above, you can switch the connection string for the application tier to the new server to start using.

Note: for compatibility, it is recommended that you do not cross-version upgrades, and if you are using an 5.5 version of the instance , first upgrade to 5.6 by this method . Then upgrade the 5.6 instance to 5.7.

Visit http://market.azure.cn Now

MySQL Database on Azure supports version 5.7!