MySQL Guide
Learn more about the benefits of Satori for MySQL and Schedule a demo meeting
It only takes a few minutes to get started with Satori. What you need is: - Access to Satori's management console.
- The hostname of your MySQL data store, for example:
abcd123.efgpnwsesibaly.us-east-1.rds.amazonaws.com
Adding an MySQL Data Store to Satori
- Login to the Satori Management Console.
- In the Data Stores view, click the plus button to add a new data store.
- Select the MySQL option.
- Enter an informative name for the data store, for example: Sales Data Warehouse.
- Enter the hostname of your MySQL server, for example:
abcd123.efgpnwsesibaly.us-east-1.rds.amazonaws.com
. - Satori will automatically choose the correct region.
- Click Create.
- Finally, you will be redirected to the Data Stores list view.
Connect to MySQL via Satori
To connect to MySQL using Satori use the Satori hostname that was generated by the management console which can be found under Satori Hostname in the data store settings view, for example:
abcd123.efgpnwsesibaly.us-east-1.rds.amazonaws.net
.
IMPORTANT CONNECTION REQUIREMENT - To ensure that Satori is able to connect to the MySQL server ensure that you configure your connection parameters with the default database name.
TLS SNI Required
To connect to MySQL via Satori, the client application must support the Server Name Identification (SNI) extension of the Transport Level Security (TLS) protocol.
For clients that do not support the SNI extension, Satori can enable a custom dedicated port which overcomes the problem. The custom port number can be found in the data store setting in the management console.
You must specify the default database that you will be connected to in order to enable user authentication on MySQL.
Ensure that you use a username and a password for the authentication.
Connecting with the JDBC Driver
To connect with the JDBC driver, override or add the host parameter in the JDBC URL. For example:
jdbc:mysql://demo-mysql-db-cpnwsesibaly.us-east-1.a.p0.satoricyber.net:3306/dbname?user=minty&password=greatsqldb
NOTE: that while 3306 is the default port you may need to specify a Satori custom port according to the TLS SNI requirements mentioned previously.
Connecting with the MySQL Command Line Utility
To connect to MySQL using the MySQL command line client, change the host parameter to the Satori generated hostname and use the custom dedicated port for your data store.
For example: mysql --user=user_name --database db_name –-host demo-mysql-db-cpnwsesibaly.us-east-1.a.p0.satoricyber.net -—port 12340 —-ssl-mode=REQUIRED
NOTE: TLS SNI is not supported by MySQL CLI.
Connecting with the Python Connector
To connect to MySQL using mysql.connector change the host parameter to the Satori generated hostname and use the custom dedicated port for your data store.
For example:
mysql.connector.connect(user=user-name, password=the-password,
host='demo-mysql-db-cpnwsesibaly.us-east-1.a.p0.satoricyber.net',
database=the-db,
port='12340')
Connecting with Looker
Looker uses the JDBC driver to connect to MySQL. Override the Remote Host:Port parameter with the Satori hostname.
For Example:
demo-mysql-db-cpnwsesibaly.us-east-1.a.p0.satoricyber.net:3306.
Connecting with Google Data Studio ("Looker Data Studio")
Data Studio requires a root CA SSL cert when connecting to MySQL databases. To connect tp Google data studio performthe following steps:
- Go to the Let's Encrypt website and download the self-signed PEM file for "ISRG Root X1".
- Use this certificate file in your connection.
- Make sure SSL is enabled.
- Use a custom SNI port for MySQL.
Connecting with Tableau
To connect to Satori MySQL hostnames using Tableau, first to start in Tableau Desktop. Tableau Server/Cloud currently does not support the specification of an SSL certificate. If you are using Tableau Desktop you can specify an SSL certificate and then publish it to your data connection on your workbook to Tableau Server/Cloud.
Tableau Desktop connections to Satori MySQL connections will require the root certificate from Let's Encrypt. Go to the Let's Encrypt website and download the self-signed PEM file for "ISRG Root X1".
- In your Tableau Connection for MySQL, enter your Satori hostname for the server field.
- Use a custom SNI port for MySQL, as configured in your Satori Datastore connection.
- Enter the desired database name.
- Use either a MySQL username, or your Satori credentials.
- Make sure SSL is enabled and that you have referenced the Let's Encrypt certificate from step 1.
The Tablleau SSL Connection
The connection should look like the following example: SSL CA - /users/yourname/downloads/isrgroot1.pem