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.
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 the 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.
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): Use these fields to provide additional name-value pairs to be sent to SQL Server with the connection.. 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). You can use any of the following advanced configuration options:
|
Name |
Value |
|---|---|
|
bigIntAsNumber |
Define whether the query should return BigInt data type as Number. If enable, this might return approximate values. |
|
bitOneIsBoolean |
return BIT(1) values as a boolean value. |
|
connectTimeout |
Set the connection timeout in milliseconds (default changed from 10000 to 1000 in version 2.5.6). |
|
compress |
Enable exchanges with database using gzip. This can give you better performance when accessing a database in a different location. |
|
decimalAsNumber |
Define whether the query should return decimal as Number. If enable, this might return approximate values. |
|
foundRows |
Enable so that the update number corresponds to update rows. When disabled, it indicates the real rows changed. |
|
insertIdAsNumber |
Define whether the query should return last insert id from INSERT/UPDATE command as BigInt or Number. default return BigInt. |
|
keepAliveDelay |
Enable socket keep alive, setting delay. 0 means not enabled. Keep in mind that this option won't reset server wait time (use pool option idleTimeout for that). |
|
maxAllowedPacket |
Indicate server global variable value to ensure efficient batching. default is 4Mb. |
|
permitConnectionWhenExpired |
Permit you to connect when your password has expired. In this case, you must change password ('SET PASSWORD=PASSWORD('XXX')'). |
|
prepareCacheLength |
Define prepare LRU (Least Recently Used) cache length. 0 means no cache. |
|
rowsAsArray |
Return result-sets as array, rather than a JSON object. This is a faster way to get results. For more information, see the and query implementations. |
|
sessionVariables |
Set session variables when connecting. Example: sessionVariables:{'idle_transaction_timeout':10000}. |
|
socketTimeout |
Set the socket timeout in milliseconds after the connection is established. |
See also: MariaDB documentation