Hi,
I’d like to set innodb_flush_log_at_trx_commit = 0 or 2.
is this setting “safe” for xtradb cluster, since the data is (virtually) syncrously replicated?
Especially, in case a node with innodb_flush_log_at_trx_commit = 0 crashes,
do i have to force a SST? or will IST work correctly even if innodb_flush_log_at_trx_commit = 0?
Do i miss any other implications of innodb_flush_log_at_trx_commit = 0 or 2 regarding xtradb cluster?
BTW is removing grastate.dat the best way to force a SST like mentioned here: http://www.percona.com/forums/questions-discussions/percona-xtradb-cluster/9192-problem-both-nodes-not-sync