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 in…

innodb_flush_log_at_trx_commit

mrkamel July 22, 2014, 3:48am 6

Check [url]Redirecting to Google Groups as i asked there as well

Topic		Replies	Views
innodb_flush_log_at_trx_commit - is this important Percona XtraDB Cluster 5.x	0	711	October 19, 2012
Falling PXC 5.6 after a successful SST Percona XtraDB Cluster 5.x	3	571	September 2, 2017
XtraDB 8.0.29 Bug Related? PS-8292 Percona XtraDB Cluster 8.x	7	796	August 31, 2023
Falling PXC 5.6 after a successful SST Percona XtraDB Cluster 5.x	1	514	January 4, 2021
recovery issues (IST\SST) on Docker Percona XtraDB Cluster 5.x	0	477	October 24, 2016