Installation
MySQL plug-in
Suggest changes
PDFs
The MySQL plug-in uses Net-MySQL to communicate with the database.
The MySQL plug-in does not support backup and restore operations for multiple databases. The Interoperability Matrix contains the latest information about support and compatibility.
For Snap Creator configurations, the MySQL database user must have the LOCK TABLES privilege granted, along with other privileges, such as SUPER and RELOAD.
The following table lists the MySQL plug-in parameters, provides their settings, and describes them:
| Parameter | Setting | Description | ||
|---|---|---|---|---|
APP_NAME |
mysql |
Application name |
||
MYSQL_DATABASES |
db_name:user_name/password |
List of MySQL databases, the user name, and the password.You can specify multiple databases with user names and passwords as a semicolon-separated list, for example, |
||
HOST |
host_name |
Name of the host where the databases are located.Note: VALIDATE_VOLUMES functions properly only if HOST=localhost. If HOST=IP_address, then VALIDATE_VOLUMES will not discover the MySQL database. |
||
PORTS |
db_name:port_number |
List of databases and the ports they are listening on,for example, |
||
MASTER_SLAVE |
(Y |
N) |
||
Specifies the backup database environment:If set to Y, backs up the master database. If set to N, either backs up the slave database or the Master-Slave configuration is not used.
|
PURGE_BINARY_LOG |
(Y |
Related information