I have a galera 4 cluster with two MySQL 8 nodes and garbd. I would like to test the new streaming replication feature but can't enable it. As far as know to enable streaming replication I have to set wsrep_trx_fragment_size > 0.
I do not use MariaDB which is found in most of the documentation for this feature.
Isn't it available for MySQL 8?
wsrep_provider -> /usr/lib64/galera-4/libgalera_smm.so
mysql -> 8.0.25 MySQL Community Server
wsrep_trx_fragment_unit = bytes
SET SESSION wsrep_trx_fragment_size=100000;
ERROR 1231 (42000): Variable 'wsrep_trx_fragment_size' can't be set to the value of '100000'
SET SESSION wsrep_trx_fragment_size=1;
ERROR 1231 (42000): Variable 'wsrep_trx_fragment_size' can't be set to the value of '1'
SET SESSION wsrep_trx_fragment_size=0;
Query OK, 0 rows affected (0,01 sec)
I have a galera 4 cluster with two MySQL 8 nodes and garbd. I would like to test the new streaming replication feature but can't enable it. As far as know to enable streaming replication I have to set wsrep_trx_fragment_size > 0. I do not use MariaDB which is found in most of the documentation for this feature.
Isn't it available for MySQL 8?
wsrep_provider -> /usr/lib64/galera-4/libgalera_smm.so mysql -> 8.0.25 MySQL Community Server wsrep_trx_fragment_unit = bytes
SET SESSION wsrep_trx_fragment_size=100000; ERROR 1231 (42000): Variable 'wsrep_trx_fragment_size' can't be set to the value of '100000' SET SESSION wsrep_trx_fragment_size=1; ERROR 1231 (42000): Variable 'wsrep_trx_fragment_size' can't be set to the value of '1' SET SESSION wsrep_trx_fragment_size=0; Query OK, 0 rows affected (0,01 sec)