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
- 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:
Open the <installer_home>/config.env.sh file for
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>"NoteYou 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_URIparameter in the above example as follows:
DATABASE_URI="jdbc:mysql://<host_name>:<port>/dataplane?verifyServerCertificate=false&useSSL=true"The MySQL database is configured.