1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
|
--source include/have_tokudb_backup.inc
--source include/not_gtid_enabled.inc
--let $MASTER_STATE_FILE=tokubackup_binlog_info
--let $BACKUP_DIR_MASTER=$MYSQL_TMP_DIR/tokudb_backup_master
--let $MASTER_STATE_FILE_PATH=$BACKUP_DIR_MASTER/$MASTER_STATE_FILE
--let DDIR=$BACKUP_DIR_MASTER
# Settings for include/filter_file.inc
--delimiter |
let $script=
s{filename: [^,]+,}{filename: ####,};
s{position: [^,]+,}{position: ####,};
s{GTID of last change: [^ ]+}{GTID of last change: #####};
|
--delimiter ;
--let $input_file = $MASTER_STATE_FILE_PATH
--let $skip_column_names= 1
--echo ### Create backup dir
--mkdir $BACKUP_DIR_MASTER
--source include/master-slave.inc
--connection master
--echo ### Check for settings
SELECT @@gtid_mode;
--echo ### Generate some binlog events
CREATE TABLE t1(a INT) ENGINE=TokuDB;
DROP TABLE t1;
--echo ### Master backup
--disable_query_log
--eval SET SESSION tokudb_backup_dir='$BACKUP_DIR_MASTER'
--enable_query_log
--source include/filter_file.inc
--echo ### $MASTER_STATE_FILE content:
--cat_file $MASTER_STATE_FILE_PATH
--echo ### Delete backup dir
--perl
use File::Path 'rmtree';
$DDIR=$ENV{"DDIR"};
rmtree([ "$DDIR" ]);
EOF
--echo ### Create backup dir
--mkdir $BACKUP_DIR_MASTER
--echo ### GTID-mode on
--let $rpl_server_numbers= 1,2
--let $rpl_set_enforce_gtid_consistency= 1
--source include/rpl_set_gtid_mode.inc
--echo ### Check for settings
SELECT @@gtid_mode;
--echo ### Generate some binlog events
CREATE TABLE t1(a INT) ENGINE=TokuDB;
DROP TABLE t1;
--echo ### Master backup
--disable_query_log
--eval SET SESSION tokudb_backup_dir='$BACKUP_DIR_MASTER'
--enable_query_log
--source include/filter_file.inc
--echo ### $MASTER_STATE_FILE content:
--cat_file $MASTER_STATE_FILE_PATH
--echo ### Delete backup dir
--perl
use File::Path 'rmtree';
$DDIR=$ENV{"DDIR"};
rmtree([ "$DDIR" ]);
EOF
--echo ### GTID-mode off
--let $rpl_gtid_mode= OFF
--let $rpl_set_enforce_gtid_consistency= 0
--let $rpl_server_numbers= 1,2
--source include/rpl_set_gtid_mode.inc
--source include/rpl_end.inc
|
