GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Innodb Settings

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Innodb Settings

    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

  • #2
    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).

    Comment

    Working...
    X