Mysql upgrade 5.6.30 to 5.7

3294497

Folks,

Greetings!

i am in the process of upgrading Mysql 5.6.03  replication setup to 5.7. I find a generic document to upgrade using RPM's.

Would want to check here if any of you have already done this or a prior release upgrade and can provide a document for the same. Thank you

Dave Stokes-MySQL Community Team-Oracle

Check out https://dev.mysql.com/doc/refman/5.7/en/replication-upgrade.html

After the slaves have been upgraded, shut down the master, upgrade it to the same 5.7.x release as the slaves, and restart it. If you had temporarily changed the master to row-based logging, change it back to statement-based logging. The 5.7 master is able to read the old binary logs written prior to the upgrade and to send them to the 5.7 slaves. The slaves recognize the old format and handle it properly. Binary logs created by the master subsequent to the upgrade are in 5.7 format. These too are recognized by the 5.7 slaves.

Satishbabu Gunukula

I always follow the mysql doc, and it is very straight forward and able to upgrade.

If you face any issues let us know, we will help