Details
-
New Feature
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
Specification:
1. Support performance_schema.clone_status table in recipient server to show currently running or last clone status with following columns.
+-----------------+--------------+------+-----+---------+-------+
|
| Field | Type | Null | Key | Default | Extra |
|
+-----------------+--------------+------+-----+---------+-------+
|
| ID | int | YES | | NULL | |
|
| PID | int | YES | | NULL | |
|
| STATE | char(16) | YES | | NULL | |
|
| BEGIN_TIME | timestamp(3) | YES | | NULL | |
|
| END_TIME | timestamp(3) | YES | | NULL | |
|
| SOURCE | varchar(512) | YES | | NULL | |
|
| DESTINATION | varchar(512) | YES | | NULL | |
|
| ERROR_NO | int | YES | | NULL | |
|
| ERROR_MESSAGE | varchar(512) | YES | | NULL | |
|
| BINLOG_FILE | varchar(512) | YES | | NULL | |
|
| BINLOG_POSITION | bigint | YES | | NULL | |
|
| GTID_EXECUTED | longtext | YES | | NULL | |
|
+-----------------+--------------+------+-----+---------+-------+
|
2. Support performance_schema.clone_progress table to show clone progress information and time consumed in each stages.
+---------------+--------------+------+-----+---------+-------+
|
| Field | Type | Null | Key | Default | Extra |
|
+---------------+--------------+------+-----+---------+-------+
|
| ID | int | YES | | NULL | |
|
| STAGE | char(32) | YES | | NULL | |
|
| STATE | char(16) | YES | | NULL | |
|
| BEGIN_TIME | timestamp(6) | YES | | NULL | |
|
| END_TIME | timestamp(6) | YES | | NULL | |
|
| THREADS | int | YES | | NULL | |
|
| ESTIMATE | bigint | YES | | NULL | |
|
| DATA | bigint | YES | | NULL | |
|
| NETWORK | bigint | YES | | NULL | |
|
| DATA_SPEED | int | YES | | NULL | |
|
| NETWORK_SPEED | int | YES | | NULL | |
|
+---------------+--------------+------+-----+---------+-------+
|
Limitations:
Binary Log position and GTID are not cloned.
Development Note:
Clone plugin code for PFS is disabled in main-MDEV-35248 prototype branch as it needs dynamic performance schema table feature from MySQL. We need to port the feature from MySQL.
Attachments
Issue Links
- blocks
-
-
- Open
-
- is blocked by
-
-
- Open
-