v-add-database-host

About v-add-database-host
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


Leave a Reply

Your email address will not be published. Required fields are marked *