search

codership / mysql-wsrep

wsrep API patch for MySQL server
Other
64 stars 34 forks source link

MySQL 8 Galera with a Slave silently continues after SST #408

Open shinguz opened 2 years ago

shinguz commented 2 years ago

When we have a Slave attached to a 3 node MySQL 8 Galera Cluster and the Master does a SST the Slave silently reconnects and continues replicating after a while without any issue.

BUT: It looses some data without noticing it!!! IST seems to be fine. Seems to be more of a MySQL than a Galera issue.

Hint: MySQL binary log location is different than $datadir!

All 3 Galera nodes: SQL> select count() from test.test; +----------+ | count() | +----------+ | 12947 | +----------+ Slave: SQL> select count() from test.test; +----------+ | count() | +----------+ | 7129 | +----------+ Before the test the numbers where equal!

shinguz commented 2 years ago

wsrep_sst_method = rsync

shinguz commented 2 years ago

MariaDB (10.7) does it correctly by deleting binary logs...

shinguz commented 2 years ago

And we are NOT working with GTID...

shinguz commented 2 years ago

Seems to work with GTID!