MySql Db Store | beVault

Description	Connection to a MySql database
Type	mysql
Category	Db

Configuration in States

The MySql Db Store can be configured directly in the States interface via the Data Stores module. The following configuration modes are available:

Parameters

Name	Description	Mandatory	Default	Comment
Host	The hostname or IP address of the MySQL server	True	`localhost`
Port	The port of the MySQL server	True	`3306`
Database	The name of the target database	True	—
Username	The username used to authenticate	True	—
Password	The password used to authenticate	True	—	Value is hidden
Suffix	Additional parameters appended to the connection string	True	—

Connection String

A connection string can be entered manually instead of using the parameter form. For the full list of supported connection string parameters, refer to the MySqlConnector documentation.

Local Configuration

The local configuration is defined in a JSON file (stores.json) deployed directly on the Workers' server. A locally configured store takes priority over a store with the same name configured in the States interface.

Name	Description	Type	Mandatory	Comment
ConnectionString	The connection string to connect to the database	string	True

JSON

{
    "Name": "propilot",
    "Type": "mysql",
    "HealthCheck": true,
    "Config": {
        "ConnectionString": "Server=10.0.20.5;Port=3306;User Id=datafactory;Password=xxx;Database=imexkpis"
    }
}