Shulou(Shulou.com)05/31 Report--

Xiaobian to share with you MySQL 5.6 how to upgrade to version 5.7, I believe most people still do not know how to share this article for your reference, I hope you have a lot of harvest after reading this article, let's go to understand it together!

The official recommendations are as follows:

1. in-place upgrade: in-place upgrade method, using the existing datadir directory to upgrade.

2. logical upgrade: logical upgrade method, using mysqldump export import to upgrade.

However, these two methods are rarely used in the actual upgrade process, especially the first one; usually the upgrade is completed by deploying a new slave library (the old version of the master library, the target version of the slave library), so that you only need to stop at the time of switching.

For logical upgrade, export first, then import, and finally run mysql_upgrade to complete the upgrade. In addition, mysql_upgrade can be omitted for minor version upgrade, but in actual production environment, it is recommended to upgrade both minor version and major version.

Run mysql_upgrade.

Note: GTID needs to be disabled when running Mysql_upgrade, because running Mysql_upgrade modifies the mysql engine's system table, which is not a transaction table.

The above is "MySQL 5.6 how to upgrade to version 5.7" all the content of this article, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.