Dear all,
we run a galera cluster with 6 masters, configuration of galera looks like this:
[galera]
wsrep_on = ON
wsrep_provider = /usr/lib/libgalera_smm.so
wsrep_cluster_address = "gcomm://
10.1.0.4,10.2.0.4,10.3.0.4,10.4.0.4,10.5.0.4,10.6.0.4"
binlog_format = row
default_storage_engine = InnoDB
innodb_autoinc_lock_mode = 2
bind-address = 0.0.0.0
I would like to understand, if we use simple insert into records (content,ttl,prio,type,domain_id,disabled,name,ordername,auth) values (?,?,?,?,?,?,?,?,?)")
statements, is there any possibility to know, when the replication to all other nodes has succeeded?
I read about Certification based Replication, but there was explicit mentioning of transactions, not simple INSERT statements.
Will the call to INSERT (we will be using node.js and the mysql driver) return as soon as it is sent to the first server or return once all servers received the record?
Is there any setting, that can enforce a synchronous update?
Thanks,
Michael.