Set up a connection to MariaDB

MariaDB links: API guide, Authentication

Start establishing a connection to MariaDB in either of the following ways:

• From the Resources menu, select Connections. Then, click +Create connection at the top right.
  – or –
• While working in a new or existing integration, you can add an application to a flow simply by clicking Add source or Add destination.

In the resulting Application list, click MariaDB.

At this point, you’re presented with a series of options for modifying the MariaDB authentication.

Edit MariaDB application details

Name (required): Provide a clear and distinguishable name. Throughout integrator.io imports and exports, you will have the option to choose this new connection, and a unique identifier will prove helpful later when selecting among a list of connections that you’ve created.

Host (required): Enter the hostname or IP address of the server to connect to. These values were created during MariaDB server setup.

Database Name (required): Provide the database name created during MariaDB setup.

Username (required): Enter the username for your MariaDB account.

Password (required): Enter the password for your MariaDB account. Multiple layers of protection are in place, including AES 256 encryption, to keep your connection’s password safe. When editing this form later, you must generate this value again; it is stored only when the connection is saved and never displayed as text.

Port (optional): Enter the TCP port for the database engine, which is 3306 by default in MariaDB server. Port 3306 is also the official Internet Assigned Number Authority (IANA) socket number for MariaDB server.

Use SSL (optional): Check this to establish a secure connection to the database. This ensures that data in transit is encrypted.

Certificate Authority (optional): This is an optional field if the database uses a certificate that doesn't match or chain to one of the known CAs. Use the CA option to provide a CA certificate that the peer's certificate can match or chain to. For self-signed certificates, the certificate is its own CA and, therefore must be provided.

Key (optional): Provide the optional private key in PEM format. This is necessary only if database server is using client certificate authentication.

Certificate (optional): Provide optional cert chain in PEM format. This is necessary only if the database server is using client certificate authentication.

Passphrase (optional): Provide an optional passphrase. This is used to decrypt the Key field. This is necessary only if database server is using client certificate authentication.

Edit advanced MariaDB settings

Disable strict SSL (optional): An optional flag that (if set) skips verifying the SSL certificate, allowing self-signed or expired certs. It is highly recommended (for hopefully obvious reasons) that you never set this flag for any production data connections. In general, use at your own risk.

Configure properties (optional): Define additional configurations for the database connection that is available according to the database documentation. For example, you can configure the connection timeout if the MariaDB server you are trying to connect to is slow (default connection timeout for MariaDB server is 1000ms).

Configurable properties (essential options), configurable properties (other options)