as our servers (Ubuntu 16.04.1) run on SSDs with 4k blocks (ext4), I tried to change the InnoDB page size from 16K to 4K as suggested in several performance guides. As this is a new server, there is no data which can get lost. I tried it this way:
- Install XtraDB Cluster (https://www.percona.com/doc/percona-xtradb-cluster/LATEST/install/apt.html) and run
- Created an own my.cnf with
- Delete MySQL data with
- Initialize new MySQL Instance
This fails with the following error:
[ERROR] InnoDB: Invalid page size=4096
Is there another way to change the innodb-page-size for the XtraDB Cluster? I’m just curious, because this works for Standard MySQL 5.7 Server.