ALTER STORAGE UNIT
Syntax
- Before altering the storage units, please confirm that a database exists in Proxy, and execute the
use
command to successfully select a database; ALTER STORAGE UNIT
is not allowed to change the real data source associated with this storageUnit;ALTER STORAGE UNIT
will switch the connection pool. This operation may affect the ongoing business, please use it with caution;storageUnitName
is case-sensitive;storageUnitName
needs to be unique within the current database;- 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 ofpassword@123
is"password@123"
.
Example
- Alter storage unit using standard mode
- Alter storage unit and set connection pool parameters using standard mode
- Alter storage unit and set connection pool parameters using URL patterns
ALTER
, STORAGE
, , HOST
, PORT
, DB
, USER
, PASSWORD
, PROPERTIES
, URL