MySQL¶
Note
You might want to start with our detailed tutorial for your first steps with SQL databases in DSS.
You might want to start with that tutorial. The rest of this page is reference information for MySQL.
DSS supports the full range of features on MySQL:
Reading and writing datasets
Executing SQL recipes
Performing visual recipes in-database
Using live engine for charts
Caveats¶
TZ issue
Installing the driver¶
Download the driver from https://dev.mysql.com/downloads/connector/j/
Unzip the resulting file
Install the JAR file in DSS as explained in Installing database drivers
Secure connections (SSL / TLS) support¶
DSS can connect to a MySQL server using secure connections.
Importing the server certificate and creating the client certificate¶
Please follow the instructions laid out here:
https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-using-ssl.html
You may need to add the root certificate of the authority which issued the MySQL server certificate to the JVM truststore using one of the procedures described at Adding SSL certificates to the Java truststore.
Additionally, if a client certificate is used, the keystore file and password used by DSS to authenticate to the MySQL server need to be specified
with additional Java options -Djavax.net.ssl.keyStore=path_to_keystore_file -Djavax.net.ssl.keyStorePassword=password
.
Your install.ini file should therefore look like:
[javaopts]
backend.additional.opts=-Djavax.net.ssl.keyStore=path_to_keystore_file -Djavax.net.ssl.keyStorePassword=password -Djavax.net.ssl.trustStore=path_to_truststore_file -Djavax.net.ssl.trustStorePassword=password
jek.additional.opts=-Djavax.net.ssl.keyStore=path_to_keystore_file -Djavax.net.ssl.keyStorePassword=password -Djavax.net.ssl.trustStore=path_to_truststore_file -Djavax.net.ssl.trustStorePassword=password
fek.additional.opts=-Djavax.net.ssl.keyStore=path_to_keystore_file -Djavax.net.ssl.keyStorePassword=password -Djavax.net.ssl.trustStore=path_to_truststore_file -Djavax.net.ssl.trustStorePassword=password
Setting up the MySQL connection¶
In the settings of the connection, add an “Advanced property”:
Key:
useSSL
Value:
true