You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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!
The text was updated successfully, but these errors were encountered:
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!
The text was updated successfully, but these errors were encountered: