MariaDB

Integrating your application with MariaDB enables efficient data storage, high-performance querying, and reliable database management. As a MySQL-compatible relational database, MariaDB supports scalable applications, transactional operations, and robust data handling for modern systems.

Authentication:

Connecting your application with MariaDB ensures secure and consistent database operations. Before you begin, ensure you have the following information:

• Connection Name: Choose a meaningful and unique name for your connection. This helps you identify it within your application or integration settings (e.g., "MyAppMariaDBConnection").

• Host Address : Provide the IP address or DNS name of your MariaDB server (e.g., "127.0.0.1", "mariadb.example.com")

• Port Number : Specify the port on which the database server is listening. The default MariaDB port is : 3306.

• User : Enter the username used to authenticate with the database.

• Password : Provide the password associated with the database user.

• Database Name : Specify the name of the existing database you want to connect to.

Connection Type : Choose how your application connects to the database:

Directly : Connect directly to the MariaDB server using the provided host, port, and credentials. Suitable for secure and internal environments.

Via SSH : Connect securely through an SSH tunnel. Recommended when the database server is not publicly accessible. Fill in these required fields:

• SSH Host

• SSH port

• SSH user

• RSA Private Key: Paste the RSA private key for the SSH user. Password login isn't supported.

SSL Secure: On by default. Connects over an SSL encrypted connection. When it is on, the fields below appear.

Client certificate: Paste the X509 client certificate (.pem format).

• SSL certificate key: Paste the RSA client key (.pem format).

• Server certificate: Paste the X509 server certificate (.pem format).

• Trust all: On by default. Forces the client to trust any certificate chain. Self-signed server certificates are supported.

• Verify host: Matches the name stored in the server certificate against the domain name.

Connection Pool Settings: Optional. Set the Connection Pool Size (default 6) and the Pool Connection Wait Timeout (default 30000).

Actions: