The SHOW MIGRATION SOURCE STORAGE UNITS syntax is used to query the registered migration source storage units
ShowMigrationSourceStorageUnits ::=
'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 |
| connection_timeout_milliseconds | Connection timeout in milliseconds |
| idle_timeout_milliseconds | Idle timeout in milliseconds |
| max_lifetime_milliseconds | Maximum lifetime in milliseconds |
| max_pool_size | Maximum connection pool size |
| min_pool_size | Minimum connection pool size |
| read_only | Whether the storage unit is read-only |
| other_attributes | Other storage unit attributes |
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 |
+------+-------+-----------+------+----------------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+------------------+
| ds_1 | MySQL | 127.0.0.1 | 3306 | migration_ds_0 | | | | | | | |
+------+-------+-----------+------+----------------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+------------------+
1 row in set (0.01 sec)
SHOW, MIGRATION, SOURCE, STORAGE, UNITS