Updated on 2024-04-03 GMT+08:00

Connecting to an RDS for MariaDB Instance

You can connect to an RDS for MariaDB instance through a command-line interface (CLI), Data Admin Service (DAS), or using Java database connectivity (JDBC).

Table 1 Connection methods

Connection Method

Description

Connecting to an RDS for MariaDB Instance Through the MySQL CLI Client

In Linux, you need to install a MariaDB client on your device and connect to the instance through the MySQL CLI over a private or public network.

  • A floating IP address is provided by default.

    When your applications are deployed on an ECS that is in the same region and VPC as the RDS for MariaDB instance, you are advised to use a floating IP address to connect to the instance through the ECS.

  • If you cannot access your RDS for MariaDB instance through a floating IP address, bind an EIP to the instance and connect to the instance through the ECS.

Connecting to an RDS for MariaDB Instance Through JDBC

If you are connecting to an instance through JDBC, the SSL certificate is optional. For security reasons, you are advised to download the SSL certificate to encrypt the connection. SSL is disabled by default for RDS for MariaDB instances. You can enable SSL by referring to Configuring an SSL Connection. SSL encrypts connections to databases but it increases the connection response time and CPU usage. Therefore, you are advised not to enable SSL.

Connecting to an RDS for MariaDB Instance Through DAS

DAS enables you to manage databases on a web-based console and provides you with database development, O&M, and intelligent diagnosis to make it easy to use and maintain your databases. The permissions required for connecting to DB instances through DAS are enabled by default.