Configure MySQL external database

It is strongly recommended to use an external database for production environments. After installing the database following the instructions provided with the database software, you must set up the database for use with DataPlane.

The MySQL database server must have been installed and properly configured for remote access.
A database must have been created. Note that you should create the DB which is UTF-8 encoding compliant.
You can use the following queries to configure database for DataPlane. Make sure to replace username and password.

CREATE DATABASE dataplane CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE USER username IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON dataplane.* TO username@'%';
flush privileges;

Download the MySQL JDBC driver.

You must download MySQL driver from the following URL:

MySQL Driver Download.

Open the <installer_home>/config.env.sh file for editing.
```
vi /usr/dp/current/core/bin/config.env.sh
```

Modify the configuration parameters as shown below.

USE_EXTERNAL_DB="yes" 
DB_TYPE="MySQL"
DATABASE_URI="jdbc:mysql://<host_name>:<port>/dataplane"
DATABASE_USER="<username>"
DATABASE_PASS="<password>"
MYSQL_DRIVER_LOCATION="</path/to/mysql/mysql-connector-java-8.0.19.jar>"

	Note
	You must update the parameter values as per your production environment. Make sure to update MySQL_DRIVER_LOCATION variable with MySQL driver JAR file (absolute path) as well.

If you need to connect to the database through an SSL connection, modify the DATABASE_URI parameter in the above example as follows:


DATABASE_URI="jdbc:mysql://<host_name>:<port>/dataplane?verifyServerCertificate=false&useSSL=true"

The MySQL database is configured.