add new database server
Syntax
v-add-database-host TYPE HOST DBUSER DBPASS [MAX_DB] [CHARSETS] [TEMPLATE]
Options
| Parameters | Parameters Description |
|---|---|
| TYPE | Type of database server on the host, available options are: mysql or pgsql |
| HOST | Hostname or IP of the server |
| DBUSER | User allowed to create/change/delete databases, users (very often root) |
| DBPASS | Password for above user |
| [MAX_DB] | [OPTIONAL] Maximum number of databases the server will have |
| [CHARSETS] | [OPTIONAL] Default characterset used when creating databases, default value = "UTF8" |
| [TEMPLATE] | [OPTIONAL] only used when TYPE is PostgreSQL, default value = "template1" |
Examples
Notes
The function add new database server to the server pool. It supports local and remote database servers, which is useful for clusters. By adding a host you can set limit for number of databases on a host. Template parameter is used only for PostgreSQL and has an default value “template1”. You can read more about templates in official PostgreSQL documentation.
Related Commands
Links
GitHub
1 comment for “v-add-database-host”