| 1 |
############################### |
| 2 |
# Test Setup |
| 3 |
############################### |
| 4 |
set @a=UNIX_TIMESTAMP("1970-01-21 15:32:22"); |
| 5 |
SET timestamp=@a; |
| 6 |
RESET MASTER; |
| 7 |
SET @@session.gtid_domain_id= 0; |
| 8 |
SET @@session.server_id= 1; |
| 9 |
CREATE TABLE t1 (a int); |
| 10 |
SET @@session.server_id= 2; |
| 11 |
CREATE TABLE t2 (a int); |
| 12 |
INSERT INTO t2 values (3); |
| 13 |
SET @@session.gtid_domain_id= 1; |
| 14 |
SET @@session.server_id= 1; |
| 15 |
CREATE TABLE t3 (a int); |
| 16 |
INSERT INTO t3 values (4); |
| 17 |
SET @@session.server_id= 3; |
| 18 |
SET timestamp=@a+1; |
| 19 |
CREATE TABLE t4 (a int); |
| 20 |
SET timestamp=@a+2; |
| 21 |
INSERT INTO t4 values (5); |
| 22 |
SET @@session.gtid_domain_id= 0; |
| 23 |
SET @@session.server_id= 1; |
| 24 |
INSERT INTO t1 values (1); |
| 25 |
SET @@session.gtid_domain_id= 2; |
| 26 |
SET @@session.server_id= 1; |
| 27 |
CREATE TABLE t5 (a int); |
| 28 |
INSERT INTO t5 values (6); |
| 29 |
SET @@session.gtid_domain_id= 0; |
| 30 |
SET @@session.server_id= 1; |
| 31 |
INSERT INTO t1 values (2); |
| 32 |
FLUSH LOGS; |
| 33 |
SET @@session.gtid_domain_id= 0; |
| 34 |
SET @@session.server_id= 2; |
| 35 |
CREATE TABLE t6 (a int); |
| 36 |
INSERT INTO t6 values (1); |
| 37 |
FLUSH LOGS; |
| 38 |
DROP TABLE t1; |
| 39 |
DROP TABLE t2; |
| 40 |
DROP TABLE t3; |
| 41 |
DROP TABLE t4; |
| 42 |
DROP TABLE t5; |
| 43 |
DROP TABLE t6; |
| 44 |
RESET MASTER; |
| 45 |
############################### |
| 46 |
# Test Cases |
| 47 |
############################### |
| 48 |
# |
| 49 |
# Test Case 1) --do-server-ids with a single server id limits output |
| 50 |
# to that single server |
| 51 |
# MYSQL_BINLOG BINLOG_FILE_PARAM --do-server-ids=2 | MYSQL |
| 52 |
DROP TABLE t2; |
| 53 |
# |
| 54 |
# Test Case 2) --do-server-ids with multiple server ids limits output |
| 55 |
# to the provided servers |
| 56 |
# MYSQL_BINLOG BINLOG_FILE_PARAM --do-server-ids=2,3 | MYSQL |
| 57 |
DROP TABLE t2; |
| 58 |
DROP TABLE t4; |
| 59 |
# |
| 60 |
# Test Case 3) --do-server-ids when combined with --do-domain-ids should |
| 61 |
# intersect the results |
| 62 |
# MYSQL_BINLOG BINLOG_FILE_PARAM --do-server-ids=1 --do-domain-ids=0 | MYSQL |
| 63 |
DROP TABLE t1; |
| 64 |
# |
| 65 |
# Test Case 4) --do-server-ids when combined with --ignore-domain-ids should |
| 66 |
# intersect the results |
| 67 |
# MYSQL_BINLOG BINLOG_FILE_PARAM --do-server-ids=1 --ignore-domain-ids=0 | MYSQL |
| 68 |
DROP TABLE t3; |
| 69 |
DROP TABLE t5; |
| 70 |
# |
| 71 |
# Test Case 5) --do-server-ids when combined with a GTID range should |
| 72 |
# intersect the results |
| 73 |
# MYSQL_BINLOG BINLOG_FILE_PARAM --do-server-ids=1 --stop-position=0-1-4 | MYSQL |
| 74 |
DROP TABLE t1; |
| 75 |
# |
| 76 |
# Test Case 6) --do-server-ids when combined with both --ignore-domain-ids |
| 77 |
# and a GTID range should intersect all results |
| 78 |
# MYSQL_BINLOG BINLOG_FILE_PARAM --do-server-ids=1 --ignore-domain-ids=0 --start-position=1-1-0 | MYSQL |
| 79 |
DROP TABLE t3; |
| 80 |
DROP TABLE t5; |
| 81 |
# |
| 82 |
# Test Case 7) --do-server-ids when combined with both --do-domain-ids and |
| 83 |
# a GTID range should intersect all results |
| 84 |
# MYSQL_BINLOG BINLOG_FILE_PARAM --do-server-ids=2 --do-domain-ids=0 --start-position=0-1-0 | MYSQL |
| 85 |
DROP TABLE t2; |
| 86 |
# |
| 87 |
# Test Case 8) --do-server-ids and --offset=<n> skips n events after the |
| 88 |
# first GTID is found |
| 89 |
CREATE TABLE t4 (a int); |
| 90 |
# MYSQL_BINLOG BINLOG_FILE_PARAM --offset=5 --do-server-ids=3 --do-domain-ids=1 | MYSQL |
| 91 |
DROP TABLE t4; |
| 92 |
# |
| 93 |
# Test Case 9) --do-server-ids with --start-datetime=<T> where T occurs |
| 94 |
# after the first GTID is found results in no events before T |
| 95 |
CREATE TABLE t4 (a int); |
| 96 |
# MYSQL_BINLOG BINLOG_FILE_PARAM --start-datetime="1970-01-21 15:32:24" --do-server-ids=3 --do-domain-ids=1 | MYSQL |
| 97 |
DROP TABLE t4; |
| 98 |
# |
| 99 |
# Test Case 10) --do-server-ids works with --read-from-remote-server |
| 100 |
# Setup test specific data |
| 101 |
RESET MASTER; |
| 102 |
SET @@session.gtid_domain_id= 0; |
| 103 |
SET @@session.server_id= 1; |
| 104 |
CREATE TABLE t1 (a int); |
| 105 |
INSERT INTO t1 VALUES (1); |
| 106 |
SET @@session.server_id= 2; |
| 107 |
CREATE TABLE t2 (a int); |
| 108 |
INSERT INTO t2 VALUES (1); |
| 109 |
SET @@session.server_id= 1; |
| 110 |
DROP TABLE t1; |
| 111 |
DROP TABLE t2; |
| 112 |
# MYSQL_BINLOG BINLOG_FILENAME --read-from-remote-server --do-server-ids=2 | MYSQL |
| 113 |
DROP TABLE t2; |
| 114 |
# |
| 115 |
# Test Case 11) --do-server-ids works over multiple binary log input |
| 116 |
# files |
| 117 |
# MYSQL_BINLOG BINLOG_FILE_PARAM BINLOG_FILE_PARAM2 --do-server-ids=2 | MYSQL |
| 118 |
DROP TABLE t2; |
| 119 |
DROP TABLE t6; |
| 120 |
# |
| 121 |
# Test Case 12) --do-server-ids re-specifications should override |
| 122 |
# previous ones |
| 123 |
# MYSQL_BINLOG BINLOG_FILE_PARAM --do-server-ids=1 --do-server-ids=2 | MYSQL |
| 124 |
DROP TABLE t2; |
| 125 |
# |
| 126 |
# Test Case 13) --do-server-ids and --server-id should be aliases and |
| 127 |
# a re-specification of one should override the former |
| 128 |
# MYSQL_BINLOG BINLOG_FILE_PARAM --do-server-ids=1 --server-id=2 | MYSQL |
| 129 |
DROP TABLE t2; |
| 130 |
# |
| 131 |
# Test Case 14) --ignore-server-ids re-specifications should override |
| 132 |
# previous ones |
| 133 |
# MYSQL_BINLOG BINLOG_FILE_PARAM --ignore-server-ids=2 --ignore-server-ids=1,3 | MYSQL |
| 134 |
DROP TABLE t2; |
| 135 |
# |
| 136 |
# Test Case 15) --do-domain-ids re-specifications should override |
| 137 |
# previous ones |
| 138 |
# MYSQL_BINLOG BINLOG_FILE_PARAM --do-domain-ids=1 --do-domain-ids=0 | MYSQL |
| 139 |
DROP TABLE t1,t2; |
| 140 |
# |
| 141 |
# Test Case 16) --ignore-domain-ids re-specifications should override |
| 142 |
# previous ones |
| 143 |
# MYSQL_BINLOG BINLOG_FILE_PARAM --ignore-domain-ids=0 --ignore-domain-ids=1,2 | MYSQL |
| 144 |
DROP TABLE t1,t2; |
| 145 |
############################## |
| 146 |
# Error Cases |
| 147 |
############################## |
| 148 |
# |
| 149 |
# Error Case 1: |
| 150 |
# --ignore-server-ids and --do-server-ids both specified |
| 151 |
# MYSQL_BINLOG BINLOG_FILE_PARAM --do-server-ids=1 --ignore-server-ids=2 |
| 152 |
# |
| 153 |
# Error Case 2: |
| 154 |
# Invalid server ID number provided |
| 155 |
# MYSQL_BINLOG BINLOG_FILE_PARAM --do-server-ids=-1 |
| 156 |
############################## |
| 157 |
# Cleanup |
| 158 |
############################## |
| 159 |
SET @@global.gtid_domain_id= 0; |
| 160 |
SET @@global.server_id= 1; |
| 161 |
# End of tests |