Not the answer you need?
Register and ask your own question!

Innodb Settings

candrecandre EntrantCurrent User Role Beginner
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

Comments

  • przemekprzemek Percona Support Engineer Percona Staff Role
    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).
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.