mysql测试主从_一篇搞懂MySQL 8.0 Clone技术在线搭建主从复制全过程

root@localhost:(none) 03:34:49 >SELECT * FROM performance_schema.clone_progress;

±-----±----------±----------±---------------------------±---------------------------±--------±----------±----------±----------±-----------±--------------+

| ID | STAGE | STATE | BEGIN_TIME | END_TIME | THREADS | ESTIMATE | DATA | NETWORK | DATA_SPEED | NETWORK_SPEED |

±-----±----------±----------±---------------------------±---------------------------±--------±----------±----------±----------±-----------±--------------+

| 1 | DROP DATA | Completed | 2020-03-12 15:29:15.385694 | 2020-03-12 15:29:15.634609 | 1 | 0 | 0 | 0 | 0 | 0 |

| 1 | FILE COPY | Completed | 2020-03-12 15:29:15.634765 | 2020-03-12 15:29:17.452961 | 1 | 465800520 | 465800520 | 465833356 | 0 | 0 |

| 1 | PAGE COPY | Completed | 2020-03-12 15:29:17.453144 | 2020-03-12 15:29:17.554224 | 1 | 0 | 0 | 99 | 0 | 0 |

| 1 | REDO COPY | Completed | 2020-03-12 15:29:17.554413 | 2020-03-12 15:29:17.654430 | 1 | 2560 | 2560 | 3031 | 0 | 0 |

| 1 | FILE SYNC | Completed | 2020-03-12 15:29:17.654596 | 2020-03-12 15:29:17.730172 | 1 | 0 | 0 | 0 | 0 | 0 |

| 1 | RESTART | Completed | 2020-03-12 15:29:17.730172 | 2020-03-12 15:29:22.160372 | 0 | 0 | 0 | 0 | 0 | 0 |

| 1 | RECOVERY | Completed | 2020-03-12 15:29:22.160372 | 2020-03-12 15:29:22.478889 | 0 | 0 | 0 | 0 | 0 | 0 |

±-----±----------±----------±---------------------------±---------------------------±--------±----------±----------±----------±-----------±--------------+

7 rows in set (0.00 sec)

root@localhost:(none) 03:34:52 >SELECT * FROM performance_schema.clone_status\G

*************************** 1. row ***************************

ID: 1

PID: 0

STATE: Completed

BEGIN_TIME: 2020-03-12 15:29:15.385

END_TIME: 2020-03-12 15:29:22.479

SOURCE: 192.168.3.133:3307

DESTINATION: LOCAL INSTANCE

ERROR_NO: 0

ERROR_MESSAGE:

BINLOG_FILE: mysql-bin.000002

BINLOG_POSITION: 421

GTID_EXECUTED: 3e75bf2f-6401-11ea-8995-000c29db65a6:1

1 row in set (0.00 sec)