Debian Codegraph @

mysql-test/suite/mariabackup/rpl_slave_info.test

raw
1 --source include/master-slave.inc
2
3 --connection slave
4
5 --echo ###############
6 --echo # If Using_Gtid != 'No', backup gtid_slave_pos
7 --echo ########################
8
9 --source include/stop_slave.inc
10 change master to master_use_gtid=slave_pos;
11 --source include/start_slave.inc
12
13 --connection master
14 CREATE TABLE t(i INT);
15 --sync_slave_with_master
16
17 --let $using_gtid=query_get_value(SHOW SLAVE STATUS,Using_Gtid,1)
18 --echo "using_gtid: $using_gtid"
19
20 --let $targetdir=$MYSQLTEST_VARDIR/tmp/backup
21 --disable_result_log
22 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --defaults-group-suffix=.2 --slave-info --backup --target-dir=$targetdir;
23 --enable_result_log
24
25 --let SEARCH_FILE=$targetdir/mariadb_backup_slave_info
26 --let SEARCH_PATTERN=gtid_slave_pos
27 --source include/search_pattern_in_file.inc
28 --let SEARCH_PATTERN=MASTER_LOG_FILE
29 --source include/search_pattern_in_file.inc
30 --source include/show_xtrabackup_slave_info.inc
31
32 rmdir $targetdir;
33
34 --echo ###############
35 --echo # If Using_Gtid != 'No' and !gtid_slave_pos, backup master position
36 --echo ########################
37
38 --source include/stop_slave.inc
39 --disable_warnings
40 SET GLOBAL gtid_slave_pos="";
41 --enable_warnings
42
43 --let $targetdir=$MYSQLTEST_VARDIR/tmp/backup
44 --disable_result_log
45 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --defaults-group-suffix=.2 --slave-info --backup --target-dir=$targetdir;
46 --enable_result_log
47
48 --let SEARCH_FILE=$targetdir/mariadb_backup_slave_info
49 --let SEARCH_PATTERN=gtid_slave_pos
50 --source include/search_pattern_in_file.inc
51 --let SEARCH_PATTERN=MASTER_LOG_FILE
52 --source include/search_pattern_in_file.inc
53 --source include/show_xtrabackup_slave_info.inc
54
55 rmdir $targetdir;
56
57 --echo ###############
58 --echo # If Using_Gtid == 'No', backup Exec_Master_Log_Pos
59 --echo ########################
60
61 change master to master_use_gtid=no;
62 --source include/start_slave.inc
63
64 --connection master
65 INSERT INTO t VALUES(1);
66 --sync_slave_with_master
67
68 --let $using_gtid=query_get_value(SHOW SLAVE STATUS,Using_Gtid,1)
69 --echo "using_gtid: $using_gtid"
70
71 --let $targetdir=$MYSQLTEST_VARDIR/tmp/backup
72 --disable_result_log
73 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --defaults-group-suffix=.2 --slave-info --backup --target-dir=$targetdir;
74 --enable_result_log
75
76 --let SEARCH_FILE=$targetdir/mariadb_backup_slave_info
77 --let SEARCH_PATTERN=gtid_slave_pos
78 --source include/search_pattern_in_file.inc
79 --let SEARCH_PATTERN=MASTER_LOG_FILE
80 --source include/search_pattern_in_file.inc
81 --source include/show_xtrabackup_slave_info.inc
82
83 rmdir $targetdir;
84
85 # Cleanup
86 --connection master
87 DROP TABLE t;
88 --sync_slave_with_master
89 --source include/rpl_end.inc