MySQL 8 Galera with a Slave silently continues after SST

Question

MySQL 8 Galera with a Slave silently continues after SST

shinguz opened this issue 2 years ago · 4 comments

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!

Answer 1 · 2022-09-17T16:22:13.000Z

wsrep_sst_method = rsync

Answer 2 · 2022-09-17T16:23:50.000Z

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

Answer 3 · 2022-09-17T16:24:48.000Z

And we are NOT working with GTID...

Answer 4 · 2022-09-17T16:48:30.000Z

Seems to work with GTID!