REGISTER MIGRATION SOURCE STORAGE UNIT

Description

The REGISTER MIGRATION SOURCE STORAGE UNIT syntax is used to register migration source storage unit for the current connection.

Syntax

RegisterMigrationSourceStorageUnit ::=
  'REGISTER' 'MIGRATION' 'SOURCE' 'STORAGE' 'UNIT' storageUnitDefinition (',' storageUnitDefinition)*

storageUnitDefinition ::=
  storageUnitName '(' (simpleSource | urlSource) ',' 'USER' '=' user (',' 'PASSWORD' '=' password)? (',' propertiesDefinition)? ')'

storageUnitName ::=
  identifier

simpleSource ::=
  'HOST' '=' hostname ',' 'PORT' '=' port ',' 'DB' '=' dbName

urlSource ::=
  'URL' '=' url

hostname ::=
  string

port ::=
  int

dbName ::=
  string

url ::=
  string

user ::=
  string

password ::=
  string

propertiesDefinition ::=
  'PROPERTIES' '(' (key '=' value (',' key '=' value)*)? ')'

key ::=
  string

value ::=
  literal

Supplement

Confirm that the registered migration source storage unit can be connected normally, otherwise it will not be added successfully;
storageUnitName is case-sensitive;
storageUnitName needs to be unique within the current connection;
storageUnitName name only allows letters, numbers and _, and must start with a letter;
poolProperty is used to customize connection pool parameters, key must be the same as the connection pool parameter name, value supports int and String types;
When password contains special characters, it is recommended to use the string form; For example, the string form of password@123 is "password@123".
The migration source storage unit supports registration using either URL, or HOST, PORT, and DB.

Example

REGISTER MIGRATION SOURCE STORAGE UNIT ds_0 (
    URL="jdbc:mysql://127.0.0.1:3306/migration_ds_0?serverTimezone=UTC&useSSL=false",
    USER="root",
    PASSWORD="root"
);

REGISTER MIGRATION SOURCE STORAGE UNIT ds_0 (
    HOST="127.0.0.1",
    PORT=3306,
    DB="migration_ds_0",
    USER="root",
    PASSWORD="root"
);

REGISTER MIGRATION SOURCE STORAGE UNIT ds_0 (
    URL="jdbc:mysql://127.0.0.1:3306/migration_ds_0?serverTimezone=UTC&useSSL=false",
    USER="root",
    PASSWORD="root",
    PROPERTIES("minPoolSize"="1","maxPoolSize"="20","idleTimeout"="60000")
);

Reserved word

REGISTER, MIGRATION, SOURCE, STORAGE, UNIT, USER, PASSWORD, PROPERTIES, URL, HOST, PORT, DB