Configure MySQL instance
You can configure MySQL protection using the following environment variables:
(Optional) path - Add MySQL bin path to this environment variable for running queries and connecting to databases.
(Optional) LIB_MYSQL_CLIENT_<port> - This environment variable is used for MySQL multi-instance deployment.
For Windows set this environment variable to provide the location of
libmysql.dlllibrary.For Linux set this environment variable to provide the location of
libmysqlclient.solibrary.
(Optional) MYSQL_SOCKFILE_<port> - This environment variable is used for MySQL multi-instance deployment. For Linux set this environment variable to provide the location of respective instances
mysql.sockfile.(Optional) MYSQL_BACKUP_DUMP_DIRECTORY - Set this environment variable as temporary backup dump directory for non streaming backup. For example, for Linux, user can set this environment variable to required location using below command:
echo "export MYSQL_BACKUP_DUMP_DIRECTORY=/home/custom_dump_dir_location/" > > ~/.bashrc
For Windows, user can create new environment variable and add path of folder location as below:
MYSQL_BACKUP_DUMP_DIRECTORY=C:\custom_dump_dir_location
Note:
Ensure that provided backup dump directory is empty as post backup its content will be auto-deleted.
(Optional) LVM SNAPSHOT_SIZE - Set this environment variable to provide the snapshot size for LVM backup for Linux operating system only. You can set environment variable of LVM Snapshot size to 500 MB using below command:
echo "export LVM_SNAPSHOT_SIZE=500MB" >> ~/.bashrc
Note:
The default snapshot size is set to 500MB. Ensure that the sufficient free size is available for snapshot.
(Optional) XTRABACKUP_MAX_PROCESSES_<port> - Set this environment variable to specify the number of threads to use for copying multiple data files concurrently while performing backup and recovery with xtrabackup utility.
The following environment variables on the client side, identify the certificate and key files which clients use to establish encrypted connections to the server. These variables are similar to the ssl_ca, ssl_cert, and ssl_key system variables which are used on the server side whereas the following SSL environment variables identify the client public and private key. These environment variables are required in case of backup and recovery.
MYSQL_OPT_SSL_CA_port - Set this environment variable to provide the path of the Certificate Authority (CA) certificate file. This option must specify the same certificate used by the server. For example:
For Windows: MYSQL_OPT_SSL_CA_3306=C:\mysql_certificate_folder\ca.pem
For Linux: echo "export MYSQL_OPT_SSL_CA_3306=/mysql_certificate_folder/ca.pem" >> ~/.bashrc
MYSQL_OPT_SSL_CERT_port - Set this environment variable to provide the path of the client public key certificate file. For example:
For Windows: MYSQL_OPT_SSL_CERT_3306=C:\mysql_certificate_folder\client-cert.pem
For Linux: echo "export MYSQL_OPT_SSL_CERT_3306=/mysql_certificate_folder/client-cert.pem" >> ~/.bashrc
MYSQL_OPT_SSL_KEY_port - Set this environment variable to provide the path of the client private key file. For example:
For Windows: MYSQL_OPT_SSL_KEY_3306=C:\mysql_certificate_folder\client-key.pem
For Linux: echo "export MYSQL_OPT_SSL_KEY_3306=/mysql_certificate_folder/client-key.pem" >> ~/.bashrc