MariaDB Guide
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 MariaDB data store, for example:
dev-maria-db.c6pjr79t8hab.us-east-1.rds.amazonaws.com
Adding an MariaDB Data Store to Satori
- Login to the Satori's management console.
- In the Data Stores view, click the plus button to add a new data store.
- Select the Prod MariaDB option.
- Enter an informative name for the data store, for example: Sales Data Warehouse.
- Enter the hostname of your MariaDB server, for example:
dev-maria-db.c6pjr79t8hab.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 MariaDB via Satori
To connect to MariaDB 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: demo-mariadb-db-cpnwsesibaly.us-east-1.a.p0.satoricyber.net
.
IMPORTANT - CONNECTION REQUIREMENT - To ensure that Satori is able to connect to the MariaDB server ensure that you configure your connection parameters with the default database name.
TLS SNI Required
To connect to MariaDB 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 to which you will be connected in order to enable user authentication on MariaDB, and use username/password for its 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:mariadb://demo-mariadb-db-cpnwsesibaly.us-east-1.a.p0.satoricyber.net:3306/dbname?user=minty&password=greatsqldb
Note: 306 is the default port you may need to specify the Satori custom port according to the TLS SNI requirements.
Connecting with the MariaDB Command Line Utility
To connect to MariaDB using the MariaDB command line client, change the host parameter to the Satori generated hostname and use the custom dedicated port for your data store. For example:mariadb --user=user_name --database db_name –-host demo-mariadb-db-cpnwsesibaly.us-east-1.a.p0.satoricyber.net —-port 12340 —-ssl-mode=REQUIRED
NOTE: TLS SNI is not supported by MariaDB CLI.
Connecting with the Python Connector
To connect to MariaDB using mariadb.connector change the host parameter to the Satori generated hostname and use the custom dedicated port for your data store. For example: mariadb.connect(user=user-name, password=the-password,
host='demo-maria-db-cpnwsesibaly.us-east-1.a.p0.satoricyber.net',
database=the-db,
port='12340')
IMPORTANT: TLS SNI not supported by mariadb-connector. Use the latest version of mariadb-connector for python.
Connecting with Looker
Looker uses the JDBC driver to connect to MariaDB. Override the Remote Host:Port parameter with the Satori hostname. For example: demo-mariadb-db-cpnwsesibaly.us-east-1.a.p0.satoricyber.net:3306