| 1 |
# Includes tests to verify UPDATE and DELETE operations are replicated |
| 2 |
# as expected when the tables are configured with conflict detection |
| 3 |
# and resolution alogrithms. |
| 4 |
|
| 5 |
--connection slave |
| 6 |
--source suite/ndb_rpl/t/ndb_conflict_info_init.inc |
| 7 |
|
| 8 |
--connection master |
| 9 |
|
| 10 |
--eval create table t1 (a int, b varchar(32), X $col_type, d varchar(9), primary key (a, d)) engine ndb |
| 11 |
# Create a similar table without any conflict function configured |
| 12 |
create table t2 (a int, b varchar(32), c int unsigned, d varchar(9), primary key (a, d)) engine ndb; |
| 13 |
|
| 14 |
--echo ************************************************ |
| 15 |
--echo * some basic positive testing, i.e. no conflicts |
| 16 |
--echo ************************************************ |
| 17 |
--connection master |
| 18 |
--echo *** insert some data |
| 19 |
begin; |
| 20 |
insert into t1 values (1, "Master t1 a=1 at X=1", 1, '1'); |
| 21 |
insert into t1 values (2, "Master t1 a=2 at X=1", 1, '12'); |
| 22 |
insert into t1 values (3, "Master t1 a=3 at X=1", 1, '123'); |
| 23 |
insert into t2 values (1, "Master t2 a=1 at c=1", 1, '1'); |
| 24 |
insert into t2 values (2, "Master t2 a=2 at c=1", 1, '12'); |
| 25 |
insert into t2 values (3, "Master t2 a=3 at c=1", 1, '123'); |
| 26 |
commit; |
| 27 |
--sync_slave_with_master |
| 28 |
|
| 29 |
--echo *** master - update all |
| 30 |
--connection master |
| 31 |
begin; |
| 32 |
update t1 set b="Master t1 X=2", X=X+1; |
| 33 |
update t2 set b="Master t2 c=2", c=c+1; |
| 34 |
commit; |
| 35 |
--echo *** slave - check update all |
| 36 |
--sync_slave_with_master |
| 37 |
--connection slave |
| 38 |
select * from t1 order by a, d; |
| 39 |
select * from t2 order by a, d; |
| 40 |
--source suite/ndb_rpl/t/ndb_conflict_info.inc |
| 41 |
|
| 42 |
--echo *** master - update 2 rows in different tables |
| 43 |
--connection master |
| 44 |
update t1 set b="Master t1 a=2 at X=3", X=X+1 where a=2; |
| 45 |
update t2 set b="Master t2 a=3 at c=3", c=c+1 where a=3; |
| 46 |
--echo *** slave - check update 2 rows in different tables |
| 47 |
--sync_slave_with_master |
| 48 |
--connection slave |
| 49 |
select * from t1 order by a, d; |
| 50 |
select * from t2 order by a, d; |
| 51 |
--source suite/ndb_rpl/t/ndb_conflict_info.inc |
| 52 |
|
| 53 |
--echo *** master - delete all |
| 54 |
--connection master |
| 55 |
delete from t1; |
| 56 |
delete from t2; |
| 57 |
--echo *** slave - check delete all |
| 58 |
--sync_slave_with_master |
| 59 |
--connection slave |
| 60 |
select * from t1 order by a, d; |
| 61 |
select * from t2 order by a, d; |
| 62 |
--source suite/ndb_rpl/t/ndb_conflict_info.inc |
| 63 |
--source suite/ndb_rpl/t/ndb_conflict_info_init.inc |
| 64 |
|
| 65 |
--echo ************************ |
| 66 |
--echo * start conflict testing |
| 67 |
--echo ************************ |
| 68 |
--echo *** master - insert some data |
| 69 |
--connection master |
| 70 |
begin; |
| 71 |
insert into t1 values (1, "Master t1 a=1 at X=10", 10, '111'); |
| 72 |
insert into t1 values (2, "Master t1 a=2 at X=10", 10, '111222'); |
| 73 |
insert into t1 values (3, "Master t1 a=3 at X=10", 10, '111222333'); |
| 74 |
insert into t1 values (4, "Master t1 a=4 at X=10", 10, '111222333'); |
| 75 |
insert into t2 values (1, "Master t2 a=1 at c=10", 10, '111'); |
| 76 |
insert into t2 values (2, "Master t2 a=2 at c=10", 10, '111222'); |
| 77 |
insert into t2 values (3, "Master t2 a=3 at c=10", 10, '111222333'); |
| 78 |
insert into t2 values (4, "Master t2 a=4 at c=10", 10, '111222333'); |
| 79 |
commit; |
| 80 |
|
| 81 |
--echo *** slave - check conflict info, no conflicts yet |
| 82 |
--sync_slave_with_master |
| 83 |
--connection slave |
| 84 |
--source suite/ndb_rpl/t/ndb_conflict_info.inc |
| 85 |
|
| 86 |
--echo *** slave - check insert some data |
| 87 |
select * from t1 order by a, d; |
| 88 |
select * from t2 order by a, d; |
| 89 |
|
| 90 |
--echo *** slave - update some data to cause conflicts |
| 91 |
begin; |
| 92 |
update t1 set b="Slave t1 a=1 at X=12", X=12 where a=1 and d='111'; |
| 93 |
update t1 set b="Slave t1 a=2 at X=12", X=12 where a=2 and d='111222'; |
| 94 |
update t1 set b="Slave t1 a=3 at X=12", X=12 where a=3 and d='111222333'; |
| 95 |
update t1 set b="Slave t1 a=4 at X=12", X=12 where a=4 and d='111222333'; |
| 96 |
update t2 set b="Slave t2 a=1 at c=12", c=12 where a=1; |
| 97 |
update t2 set b="Slave t2 a=2 at c=12", c=12 where a=2; |
| 98 |
update t2 set b="Slave t2 a=3 at c=12", c=12 where a=3; |
| 99 |
update t2 set b="Slave t2 a=4 at c=12", c=12 where a=4; |
| 100 |
commit; |
| 101 |
|
| 102 |
--echo *** master - update some data to cause conflicts |
| 103 |
--connection master |
| 104 |
begin; |
| 105 |
update t1 set b="Master t1 a=1 at X=11", X=11 where a=1 and d='111'; |
| 106 |
update t1 set b="Master t1 a=2 at X=11", X=11 where a=2 and d='111222'; |
| 107 |
update t1 set b="Master t1 a=3 at X=11", X=11 where a=3 and d='111222333'; |
| 108 |
delete from t1 where a = 4; |
| 109 |
update t2 set b="Master t2 a=1 at c=11", c=11 where a=1; |
| 110 |
update t2 set b="Master t2 a=2 at c=11", c=11 where a=2; |
| 111 |
update t2 set b="Master t2 a=3 at c=11", c=11 where a=3; |
| 112 |
delete from t2 where a = 4; |
| 113 |
commit; |
| 114 |
|
| 115 |
--echo *** slave - check conflict info, there should be some |
| 116 |
--sync_slave_with_master |
| 117 |
--connection slave |
| 118 |
--source suite/ndb_rpl/t/ndb_conflict_info.inc |
| 119 |
|
| 120 |
--echo *** slave - check update some data that causes conflicts |
| 121 |
select * from t1 order by a, d; |
| 122 |
select * from t2 order by a, d; |
| 123 |
--echo *** slave - correct some data to correspond to the master |
| 124 |
update t1 set b="Slave t1 a=1 at X=11", X=11 where a=1 and d='111'; |
| 125 |
delete from t1 where a = 4; |
| 126 |
|
| 127 |
--echo *** master - update some data, use higher timestamp |
| 128 |
--connection master |
| 129 |
begin; |
| 130 |
update t1 set b="Master t1 a=1 at X=13", X=13 where a=1 and d='111'; |
| 131 |
update t1 set b="Master t1 a=2 at X=13", X=13 where a=2 and d='111222'; |
| 132 |
update t1 set b="Master t1 a=3 at X=13", X=13 where a=3 and d='111222333'; |
| 133 |
update t2 set b="Master t2 a=1 at c=13", c=13 where a=1; |
| 134 |
update t2 set b="Master t2 a=2 at c=13", c=13 where a=2; |
| 135 |
update t2 set b="Master t2 a=3 at c=13", c=13 where a=3; |
| 136 |
commit; |
| 137 |
|
| 138 |
--echo *** slave - check conflict info, change depends on calling test |
| 139 |
--sync_slave_with_master |
| 140 |
--connection slave |
| 141 |
--source suite/ndb_rpl/t/ndb_conflict_info.inc |
| 142 |
|
| 143 |
--echo *** slave - check higer timestamp |
| 144 |
select * from t1 order by a, d; |
| 145 |
select * from t2 order by a, d; |
| 146 |
|
| 147 |
--connection master |
| 148 |
drop table t1, t2; |