Innodb Settings

[candre]

Hello Sirs,

I am just wondering if I change any of the below settings will it have any impact on a multi master cluster that could cause the cluster to go out of sync due to it cacheing something on the nodes and losing power or something else.

innodb_buffer_pool_size = 384M
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 10M
innodb_log_buffer_size = 64M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 180

Thanks

Kind Regards

Chris

[przemek]

These innodb settings have nothing to do with synchronous replication you have in Galera. For example InnoDB buffer pool is needed for your node performance, not for any replication aspect. Btw innodb_log_file_size seems far too small (remember to have the same size on each node though).