| 1 |
connection node_2; |
| 2 |
connection node_1; |
| 3 |
connection node_1; |
| 4 |
connection node_2; |
| 5 |
# Case 1 : MariaBackup SST |
| 6 |
connection node_1; |
| 7 |
CREATE TABLE t(i INT NOT NULL PRIMARY KEY) ENGINE INNODB; |
| 8 |
INSERT INTO t VALUES(1); |
| 9 |
# Restart node_2, force SST. |
| 10 |
connection node_2; |
| 11 |
connection node_1; |
| 12 |
connection node_2; |
| 13 |
Starting server ... |
| 14 |
connection node_1; |
| 15 |
# Both should return NOT FOUND as we have mariabackup with backup locks |
| 16 |
NOT FOUND /Desyncing and pausing the provider/ in mysqld.1.err |
| 17 |
NOT FOUND /Resuming and resyncing the provider/ in mysqld.1.err |
| 18 |
connection node_1; |
| 19 |
SET GLOBAL wsrep_mode = "BF_ABORT_MARIABACKUP"; |
| 20 |
# Restart node_2, force SST. |
| 21 |
connection node_2; |
| 22 |
connection node_1; |
| 23 |
INSERT INTO t VALUES(2); |
| 24 |
connection node_2; |
| 25 |
Starting server ... |
| 26 |
connection node_2; |
| 27 |
connection node_1; |
| 28 |
# Both should return NOT FOUND as we have mariabackup with backup locks |
| 29 |
NOT FOUND /Desyncing and pausing the provider/ in mysqld.1.err |
| 30 |
NOT FOUND /Resuming and resyncing the provider/ in mysqld.1.err |
| 31 |
SET GLOBAL wsrep_mode = ""; |
| 32 |
DROP TABLE t; |
| 33 |
# Case 2: MariaBackup backup from node_2 |
| 34 |
connection node_1; |
| 35 |
CREATE TABLE t(i INT NOT NULL PRIMARY KEY) ENGINE INNODB; |
| 36 |
INSERT INTO t VALUES(1),(2),(3),(4),(5); |
| 37 |
connection node_2; |
| 38 |
SET GLOBAL wsrep_mode = ""; |
| 39 |
SELECT @@wsrep_mode; |
| 40 |
@@wsrep_mode |
| 41 |
|
| 42 |
# Both should return FOUND 1 as we have backup |
| 43 |
FOUND 1 /Desyncing and pausing the provider/ in mysqld.2.err |
| 44 |
FOUND 1 /Resuming and resyncing the provider/ in mysqld.2.err |
| 45 |
SET GLOBAL wsrep_mode = "BF_ABORT_MARIABACKUP"; |
| 46 |
SELECT @@wsrep_mode; |
| 47 |
@@wsrep_mode |
| 48 |
BF_ABORT_MARIABACKUP |
| 49 |
# Both should return FOUND 2 because both backups do desync but on different points |
| 50 |
FOUND 2 /Desyncing and pausing the provider/ in mysqld.2.err |
| 51 |
FOUND 2 /Resuming and resyncing the provider/ in mysqld.2.err |
| 52 |
# Should return FOUND 1 as server did not desync at BLOCK_DDL |
| 53 |
FOUND 1 /Server not desynched from group at BLOCK_DDL because WSREP_MODE_BF_MARIABACKUP is used./ in mysqld.2.err |
| 54 |
# Should return FOUND 1 as server did desync and pause at BLOCK_COMMIT |
| 55 |
FOUND 1 /Server desynched from group during BACKUP STAGE BLOCK_COMMIT./ in mysqld.2.err |
| 56 |
SET GLOBAL wsrep_mode = DEFAULT; |
| 57 |
connection node_1; |
| 58 |
DROP TABLE t; |
| 59 |
disconnect node_2; |
| 60 |
disconnect node_1; |