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 |
+------+-------+-----------+------+----------------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+------------------+
| ds_1 | MySQL | 127.0.0.1 | 3306 | migration_ds_0 | | | | | | | |
+------+-------+-----------+------+----------------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+------------------+
1 row in set (0.01 sec)
SHOW
, MIGRATION
, SOURCE
, STORAGE
, UNITS