The SHOW MIGRATION SOURCE STORAGE UNITS syntax is used to query the registered migration source storage units
ShowStorageUnit ::=
'SHOW' 'MIGRATION' 'SOURCE' 'STORAGE' 'UNITS'
| Column | Description |
|---|---|
| name | Storage unit name |
| type | Storage unit type |
| host | Storage unit host |
| port | Storage unit port |
| db | Database name |
| attribute | Storage unit attribute |
SHOW MIGRATION SOURCE STORAGE UNITS;
mysql> SHOW MIGRATION SOURCE STORAGE UNITS;
+------+-------+-----------+------+----------------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+------------------+
| name | type | host | port | db | connection_timeout_milliseconds | idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size | min_pool_size | read_only | other_attributes |
+------+-------+-----------+------+----------------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+------------------+
| su_1 | MySQL | 127.0.0.1 | 3306 | migration_ds_0 | | | | | | | |
+------+-------+-----------+------+----------------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+------------------+
1 row in set (0.01 sec)
SHOW, MIGRATION, SOURCE, STORAGE, UNITS