MySQL / MariaDB connector

MySQL is an open-source relational database management system (RDBMS). MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB. MySQL is now owned by Oracle Corporation.

MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. Development is led by some of the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle Corporation.

A MySQL Connector may be used to connect to either a MySQL or MariaDB database instance.

Supproted platforms (MYSQL)

Unix
Linux
Windows
AWS RDS
Azure Database for MySQL
Google Cloud SQL

Supported versions (MYSQL)

5.5
5.6
5.7*
8

Supported features (MYSQL)

Mode	Feature	Availability
Security	TLS/SSL	Available
	Password Vault	Available
	Kerberos	Unavailable
In-place masking	Multi-tenant	Available
	Streams/Threads	Available
	Batch Update	Available
	Drop Indexes	Available
	Disable Triggers	Unavailable
	Disable Constraints	Unavailable
	Identity Column Support	Available
On-the-fly masking	Truncate	Available
	Disable Triggers	Unavailable
	Disable Constraints	Unavailable
Profiling	Multi-tenant	Available
Profiling	Streams	Available

Note: AWS Aurora MySQL 5.7 is not supported

Google Cloud SQL IAM authorization setup instructions (MYSQL)

To authorize connections from Continuous Compliance to a Google Cloud SQL MySQL instance, do the following:

Provision a Google Compute Engine running Continuous Compliance. In the compute engine’s settings, enable Cloud SQL in the Identity and API access section.

Create a built-in MySQL connector with the following settings:

Host: igoreme
Port: 123

Upload a property file with the following:

socketFactoryClass=com.google.cloud.sql.mariadb.SocketFactory
socketFactoryConstructorArg=<connection name of the SQL Server instance from the Goog

Supported platforms (MariaDB)

Unix
Linux
Windows
AWS RDS
AWS Aurora
Azure Database for MariaDB

Supported versions(MariaDB)

Supported features(MariaDB)

Mode	Feature	Availability
Security	TLS/SSL	Available
	Password Vault	Available
	Kerberos	Unavailable
In-place masking	Multi-tenant	Available
	Streams/Threads	Available
	Batch Update	Available
	Drop Indexes	Available
	Disable Triggers	Unavailable
	Disable Constraints	Unavailable
	Identity Column Support	Available
On-the-fly masking	Truncate	Available
	Disable Triggers	Unavailable
	Disable Constraints	Unavailable
	Profiling
	Multi-tenant	Available
	Streams	Available

TLS/SSL setup instructions (MariaDB)

Add the database’s certificate in the setup application using instructions in the Adding a certificate section, in the TrustStore settings article.
Restart the Compliance engine.
Create a MySQL/MariaDB connector in Continuous Compliance with the relevant parameters. Upload a properties file for the connector with the following:
```
useSSL=True
trustServerCertificate=false
keyStore=file:/var/delphix/server/etc/.truststore
keyStoreType=JKS
```