SHOW MIGRATION SOURCE STORAGE UNITS

Description

The SHOW MIGRATION SOURCE STORAGE UNITS syntax is used to query the registered migration source storage units

Syntax

  1. ShowStorageUnit ::=
  2.   'SHOW' 'MIGRATION' 'SOURCE' 'STORAGE' 'UNITS'

Return Value Description

ColumnDescription
nameStorage unit name
typeStorage unit type
hostStorage unit host
portStorage unit port
dbDatabase name
attributeStorage unit attribute

Example

  • Query registered migration source storage units
  1. SHOW MIGRATION SOURCE STORAGE UNITS;
  1. mysql> SHOW MIGRATION SOURCE STORAGE UNITS;
  2. +------+-------+-----------+------+----------------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+------------------+
  3. | name | type  | host      | port | db             | connection_timeout_milliseconds | idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size | min_pool_size | read_only | other_attributes |
  4. +------+-------+-----------+------+----------------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+------------------+
  5. | su_1 | MySQL | 127.0.0.1 | 3306 | migration_ds_0 |                                 |                           |                           |               |               |           |                  |
  6. +------+-------+-----------+------+----------------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+------------------+
  7. 1 row in set (0.01 sec)

Reserved word

SHOW, MIGRATION, SOURCE, STORAGE, UNITS