The idea is to upgrade the read replica of your server to 5.7 first and later failover your application to point to read replica and make it a new primary. You can perform minimal downtime major version upgrade from MySQL 5.6 to MySQL 5.7 by utilizing read replicas. Perform minimal downtime major version upgrade from MySQL 5.6 to MySQL 5.7 using read replicas Now go to your primary server and Perform major version upgrade on it. In the Upgrade section, select OK to upgrade Azure database for MySQL 5.6 read replica server to 5.7 server.Ī notification will confirm that upgrade is successful.įrom the Overview page, confirm that your Azure database for MySQL read replica server version is 5.7. In the Azure portal, select your existing Azure Database for MySQL 5.6 read replica server.įrom the Overview page, click the Upgrade button in the toolbar. Perform major version upgrade from MySQL 5.6 to MySQL 5.7 on read replica using Azure portal After this message is no longer displayed, the version upgrade is complete. The command prompt shows the "-Running" message. To upgrade to the latest version, run az upgrade.Īfter you sign in, run the az mysql server upgrade command: az mysql server upgrade -name testsvr -resource-group testgroup -subscription MySubscription -target-server-version 5.7" Run az version to find the version and dependent libraries that are installed. If using Azure Cloud Shell, the latest version is already installed. This upgrade requires version 2.16.0 or later of the Azure CLI. Install Azure CLI for Windows or use Azure CLI in Azure Cloud Shell to run the upgrade commands. See how to perform point-in-time restore. We recommend to perform upgrade first on restored copy of the server rather than upgrading production directly.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |