| 1 |
Test completed |
| 2 |
# Save source binlog position |
| 3 |
## Connect to second mysqld, then start replicating from first mysqld |
| 4 |
CHANGE REPLICATION SOURCE TO |
| 5 |
SOURCE_HOST='127.0.0.1', |
| 6 |
SOURCE_PORT=13001; |
| 7 |
START REPLICA IO_THREAD |
| 8 |
USER = 'root' |
| 9 |
PASSWORD = ''; |
| 10 |
Warnings: |
| 11 |
Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 12 |
# |
| 13 |
# Wait for IO thread to fetch all binlog |
| 14 |
# |
| 15 |
The IO thread has fetched all binlog! |
| 16 |
START REPLICA SQL_THREAD; |
| 17 |
Detected first replica commit; |
| 18 |
# |
| 19 |
# Wait for SQL thread to apply binlog |
| 20 |
# |
| 21 |
The SQL thread has fetched all binlog! |
| 22 |
STOP REPLICA; |