Galera - data lost in cluster

[YungHee]

Dear Sir ,

I have 3 database servers with MariaDB 10.1.24: s1, s2, s3 in CentOS7.

s1 is the primary and the cluster works perfectly until we found one issue recently.

When we create new database and table structure in s3, it can sync to s1 and s2.

However, when we insert new record into new table created, it cannot sync to s1 and s2.

Found the following as highlighted when the data is not sync in mysqld.log:

2017-07-03 11:58:10 140084206549760 [Note] WSREP: Set WSREPXid for InnoDB:  a447d33a-031a-11e7-b1ad-4a248c99f1ef:133616616

2017-07-03 11:58:10 140084206549760 [Note] WSREP: Set WSREPXid for InnoDB:  a447d33a-031a-11e7-b1ad-4a248c99f1ef:133616617

2017-07-03 11:58:12 140084116953856 [Note] WSREP: cleanup transaction for LOCAL_STATE: INSERT INTO `table1` (`field1`, `field2`, `field3`, `field4`) VALUES ('8', '', '', '')

2017-07-03 11:58:12 140084116953856 [Note] WSREP: cleanup transaction for LOCAL_STATE: SELECT COUNT(*) FROM `sdb3`.`table1`

2017-07-03 11:58:13 140084206549760 [Note] WSREP: Set WSREPXid for InnoDB:  a447d33a-031a-11e7-b1ad-4a248c99f1ef:133616809

2017-07-03 11:58:13 140084206549760 [Note] WSREP: Set WSREPXid for InnoDB:  a447d33a-031a-11e7-b1ad-4a248c99f1ef:133616814

I couldn't find the solution / explanation of this error in Google. 

Appreciate if any hints or anything I can do to check in further.

Thanks in advance!

 

[Seppo Jaakola]

Is this new table InnoDB table or some other storage engine? Only Innodb transactions will be replicated, by default.

-seppo

[Yung Hee Lee]

Dear Sir,

Thanks for your response. All tables are Innodb. 

The culprit was bin-log-db. It seems we dont need to configure bin-log-db in master anymore..

 

--
You received this message because you are subscribed to a topic in the Google Groups "codership" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/codership-team/NKg6cz4I_e0/unsubscribe.
To unsubscribe from this group and all its topics, send an email to codership-team+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.