Connecting to Amazon RDS MariaDB Database

Amazon RDS currently supports a number of database engines among which is MariaDB. Amazon Relational Database Service makes it easy to configure, perform, and scale MariaDB server deployments in the cloud.

With Amazon RDS, you can quickly deploy MariaDB cloud databases which are easy to manage and scale.

Why users choose Amazon RDS for MariaDB:

  • enhanced performance
  • simplified security
  • high availability

In this article, we are going to show how to quickly and easily connect to the Amazon RDS MariaDB database using the dbForge Studio for MySQL tool.

How to deploy a MariaDB database instance in Amazon RDS


Step 1. Open Amazon RDS console

To start with, sign in to the AWS Management Console. You will see the window as shown on the screenshot.

Next, find RDS under Database and click to open the Amazon RDS Console designed to bring Amazon Relational Database Service right to your computer or mobile device.

Amazon RDS Console

Step 2. Create an Amazon MariaDB instance

In this step, you will need to choose a database creation method, engine type, and version.

Please note, that when selecting the Standard database creation method, you will have an opportunity to configure database options including the advanced ones.

Next, choose the MariaDB engine and select its version in the drop-down list. We'll select a 10.2.21 version for our AWS MariaDB instance.
Creating AWS MariaDB

Step 3. Select a template

Now you need to select a sample template for your future MariaDB instance on Amazon RDS.

Depending on your production purposes, select Production, Dev/Test or Free tier option.

Under the AWS Free Tier offer, you receive 750 hours of RDS, 20 GB of storage, 10 million I/Os and 20 GB for backups per month.

 Select MariaDB on AWS template

Step 4-1. Provide settings for your MariaDB on AWS

In this step, you need to specify the instance settings that meet your requirements.

First, create a DB instance identifier and provide your master username and password, which you will then use when connecting to Amazon RDS via dbForge Studio for MySQL.

AWS MariaDB settings

Step 4-2. Continue configuring your MariaDB instance

Next, proceed to specify your future Amazon MariaDB instance size and storage options.

Choose a DB instance class, storage type, and allocated storage that best suit your needs.

Note, that you can scale up the allocated storage to a maximum of 16 TB with Amazon RDS for MariaDB.

Continue configuring AWS MariaDB

Step 4-3. Specify connectivity options

You are now in the Connectivity section, where you can provide all the necessary connectivity configurations for your MariaDB instance on AWS RDS.

Please note, that you can not change Virtual Private Cloud after the database is created.

AWS MariaDB settings

Step 5. Specify advanced settings for your MariaDB on AWS

You are now on the Additional configuration page, where you can provide additional information that AWS RDS needs to launch your MariaDB DB instance.

In the Maintenance section, we recommend selecting Enable auto minor version upgrade to receive automatic updates when they become available.

Please, note that if the Enable deletion protection option is enabled, you won't be able to delete the created database.

MariaDB on AWS. Advanced settings

Step 6. Launch the MariaDB instance on AWS

Once all the settings are identified, click Launch DB Instance.

After the instance process is completed (it may require some time), you can see the status, as well as other configuration information in the corresponding window as shown on the screenshot.

To view the details of your MariaDB instance, just click the DB instance name.

Check the details and click Create database to finish the process.

View the created AWS MariaDB database

Step 7. View MariaDB instance details

The dashboard (as shown on the screenshot) will provide information about recent events, including memory and CPU utilization, DB connections, etc.

Switch between the tabs to check the information you need.

If the status of the instance is available, that means that the database instance has been deployed and you can go to dbForge Studio for MySQL to connect to Amazon RDS.

View MariaDB instance details

Using dbForge Studio for MySQL to connect to Amazon RDS MariaDB database instance

Connect to an Amazon RDS MariaDB database

dbForge Studio for MySQL that is tailored to suit the specific needs of SQL developers allows connecting to Amazon RDS MariaDB instance quickly and easily.

1. In Database Explorer, click Database Connection. Alternatively, you can navigate to Database on the Main menu, and click New Connection.

2. In the Database Connection Properties window, specify the Type of the connection, enter the Host name, Port, User, and Password.

3. Once all the settings are configured, click OK.

Use dbForge Studio for MySQL to connect to MariaDB database

Currently, Amazon RDS supports such database engines as Amazon Aurora, MySQL, MariaDB, PostgreSQL, Oracle, and Microsoft SQL Server. You can find detailed information about how to connect to an Amazon RDS MySQL Database here.

It is also worth mentioning that the dbForge Studio for MySQL tool can boast broad compatibility and connectivity options that are not limited just to Amazon RDS support.

Conclusion

As you can see, with dbForge Studio for MySQL you can easily connect to Amazon RDS. It does not require much time and can be completed in a few clicks. After you deploy the MariaDB instance on Amazon RDS, you can proceed to manage and modify databases. dbForge Studio for MySQL is a great helper when building queries, measuring and improving performance, comparing data and schemas, importing and exporting data, and much more!

dbForge Studio for MySQL

The most intelligent MySQL management tool