Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
shinguz opened this issue Sep 17, 2022 · 4 comments
Open

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

shinguz opened this issue Sep 17, 2022 · 4 comments

Comments

@shinguz
Copy link

shinguz commented Sep 17, 2022

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
Copy link
Author

shinguz commented Sep 17, 2022

wsrep_sst_method = rsync

@shinguz
Copy link
Author

shinguz commented Sep 17, 2022

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

@shinguz
Copy link
Author

shinguz commented Sep 17, 2022

And we are NOT working with GTID...

@shinguz
Copy link
Author

shinguz commented Sep 17, 2022

Seems to work with GTID!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant