| 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 |
CREATE TABLE t1 ( |
| 7 |
a INT PRIMARY KEY, |
| 8 |
b VARCHAR(32) |
| 9 |
) engine=ndb; |
| 10 |
INSERT INTO t1 VALUES (1, "row 1"); |
| 11 |
include/sync_slave_sql_with_master.inc |
| 12 |
[connection slave] |
| 13 |
SELECT * FROM t1 ORDER BY a; |
| 14 |
a b |
| 15 |
1 row 1 |
| 16 |
# |
| 17 |
# BUG#36054134 Fail to run start_hook error |
| 18 |
# - Starting replica to apply changes when NDB is not ready or started |
| 19 |
# the reported error message is not helpful |
| 20 |
# |
| 21 |
# Stop and reset replica to make it apply everything again |
| 22 |
include/rpl_stop_slaves.inc |
| 23 |
[connection slave] |
| 24 |
include/rpl_reset_slave.inc |
| 25 |
DROP TABLE t1; |
| 26 |
call mtr.add_suppression("An incident event has been written"); |
| 27 |
call mtr.add_suppression("Replica: Connection to NDB not ready"); |
| 28 |
call mtr.add_suppression("Failed to open"); |
| 29 |
call mtr.add_suppression("Could not connect to storage engine"); |
| 30 |
# Stop replica cluster |
| 31 |
Executing RESTART on all nodes. |
| 32 |
Starting shutdown. This may take a while. Please wait... |
| 33 |
All DB nodes are being restarted. |
| 34 |
|
| 35 |
# Start replica and inspect error message |
| 36 |
START REPLICA; |
| 37 |
include/wait_for_slave_sql_error.inc [errno=157] |
| 38 |
# Start cluster |
| 39 |
NDB Cluster is being started. |
| 40 |
|
| 41 |
# Start replica again |
| 42 |
include/rpl_start_slaves.inc |
| 43 |
# Cleanup |
| 44 |
[connection master] |
| 45 |
DROP TABLE t1; |
| 46 |
include/sync_slave_sql_with_master.inc |
| 47 |
include/rpl_end.inc |