| 1 |
include/master-slave.inc |
| 2 |
Warnings: |
| 3 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 4 |
Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information. |
| 5 |
[connection master] |
| 6 |
Setup circular replication |
| 7 |
SLAVE_SERVER_ID: 3 |
| 8 |
Warnings: |
| 9 |
Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 10 |
Note 1760 Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information. |
| 11 |
Warnings: |
| 12 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 13 |
MASTER_SERVER_ID: 1 |
| 14 |
Setup ndb_replication and t1 exceptions table |
| 15 |
Populate ndb_replication table as necessary |
| 16 |
create table test.t1 ( |
| 17 |
a int primary key, |
| 18 |
b int, |
| 19 |
c varchar(2000)) engine=ndb; |
| 20 |
insert into test.t1 values (1,1,repeat("B", 1000)); |
| 21 |
Stopping Primary -> Secondary replication |
| 22 |
stop slave; |
| 23 |
Warnings: |
| 24 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 25 |
Stopping Secondary -> Primary replication |
| 26 |
stop slave; |
| 27 |
Warnings: |
| 28 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 29 |
Making change on Primary |
| 30 |
update test.t1 set b=2 where a=1; |
| 31 |
Making conflicting change on Secondary |
| 32 |
begin; |
| 33 |
update test.t1 set b=3 where a=1; |
| 34 |
insert into test.t1 values (2,2,repeat("A", 1000)); |
| 35 |
commit; |
| 36 |
Capturing session epoch from Master |
| 37 |
Show that last_conflict_epoch is 0 |
| 38 |
Variable_name Value |
| 39 |
Ndb_conflict_last_conflict_epoch 0 |
| 40 |
Restart Secondary->Primary replication |
| 41 |
Warnings: |
| 42 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 43 |
Check that max_replicated_epoch is |
| 44 |
still < the saved session epoch |
| 45 |
Max replicated epoch should be < committed epoch |
| 46 |
@max_replicated_epoch < @master_session_epoch |
| 47 |
1 |
| 48 |
Some invariants : |
| 49 |
@conflict_detected_epoch != 0 |
| 50 |
1 |
| 51 |
@conflict_detected_epoch > @max_replicated_epoch |
| 52 |
1 |
| 53 |
Primary has detected the problem, but Secondary |
| 54 |
is unaware as the slave is offline. |
| 55 |
Now bring it back |
| 56 |
Warnings: |
| 57 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 58 |
Now sync up |
| 59 |
Now lets check that the max replicated epoch |
| 60 |
on the Primary is == the last_conflict_epoch |
| 61 |
@max_replicated_epoch = @conflict_detected_epoch |
| 62 |
1 |
| 63 |
Cleanup |
| 64 |
Warnings: |
| 65 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 66 |
include/rpl_end.inc |