I have 3 servers running Percona 5.6 which are in a cluster.
I have innodb_log_block_size=4096 set on each one of them. The disks are SSD running ext4 filesystems formatted at 512 bytes. I chose innodb_log_block_size=4096 because several manuals mentioned that it’s a better option for SSD disks.
I tried to perform a in-place upgrade from 5.6 to 5.7 (according to https://www.percona.com/doc/percona-…ide_56_57.html).
It failed because innodb_log_block_size is set to 4096 (innodb_log_block_size was removed in 5.7):
The manual (https://www.percona.com/doc/percona-…ged_in_57.html) states that I need to shutdown mysql, remove the variable from my.cnf configuration, remove the old logs and start the service again before doing the upgrade.
But since I’m running in a cluster, won’t it cause problems during the upgrade? If I shutdown mysql, remove this option and remove the logs, won’t the logs be syncronised back from other nodes once I start mysql back up?