# Deploy MariaDB using RDS(AWS)

## In this learning path

- [Introduction](https://learn.arm.com/learning-paths/servers-and-cloud-computing/mariadb/)
- [Install MariaDB on an AWS Arm based instance](https://learn.arm.com/learning-paths/servers-and-cloud-computing/mariadb/ec2_deployment/)
- [Deploy MariaDB using RDS(AWS)](https://learn.arm.com/learning-paths/servers-and-cloud-computing/mariadb/rds_deployment/)
- [Install MariaDB on an Azure Arm based instance](https://learn.arm.com/learning-paths/servers-and-cloud-computing/mariadb/azure_deployment/)
- [Install MariaDB on a GCP Arm based instance](https://learn.arm.com/learning-paths/servers-and-cloud-computing/mariadb/gcp_deployment/)
- [Deploy MariaDB via Docker](https://learn.arm.com/learning-paths/servers-and-cloud-computing/mariadb/docker_deployment/)
- [Next Steps](https://learn.arm.com/learning-paths/servers-and-cloud-computing/mariadb/_next-steps/)

## Deploy MariaDB using Amazon RDS (Relational Database Service)

You can deploy [MariaDB](https://mariadb.org/) on Amazon RDS using Terraform.

## Before you begin

For this section you will need a computer which has [Terraform](https://learn.arm.com/install-guides/terraform/) and the [AWS CLI](https://learn.arm.com/install-guides/aws-cli/) installed.

Any computer which has the required tools installed can be used for this section. The computer can be your desktop or laptop computer or a virtual machine with the required tools.

You will need an [AWS account](https://portal.aws.amazon.com/billing/signup?nc2=h_ct&src=default&redirect_url=https%3A%2F%2Faws.amazon.com%2Fregistration-confirmation#/start) to complete this Learning Path. Create an account if you don’t have one.

Before you begin you will also need:

- An AWS access key ID and secret access key

### Acquire AWS Access Credentials

Terraform requires AWS authentication to create AWS resources. You can generate access keys (access key ID and secret access key) to perform authentication. Terraform uses the access keys to make calls to AWS using the AWS CLI.

To generate and configure the Access key ID and Secret access key, follow the [AWS Credentials install guide](https://learn.arm.com/install-guides/aws_access_keys/).

## Deploy MariaDB RDS instances

RDS is a relational database service provided by AWS.

The AWS documentation covering [Creating and connecting to a MariaDB DB instance](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_GettingStarted.CreatingConnecting.MariaDB.html) might also be helpful for you.

To deploy an RDS instance of MariaDB you can use Terraform files.

1. Use a text editor to add the contents below to a new file named `main.tf`.

    ```hcl
    provider "aws" {
      region = "us-east-2"
    }

    resource "aws_db_parameter_group" "default" {
      name   = "mariadb"
      family = "mariadb10.6"
    }

    resource "aws_db_instance" "Testing_mariadb" {
      identifier           = "mariadbdatabase"
      allocated_storage    = 10
      db_name              = "mydb"
      engine               = "mariadb"
      engine_version       = "10.6.10"
      instance_class       = "db.m6g.large"
      parameter_group_name = "mariadb"
      skip_final_snapshot  = true
      username             = var.username
      password             = var.password
      availability_zone    = "us-east-2a"
      publicly_accessible  = true
      deletion_protection  = false

      tags = {
        name = "TEST MariaDB"
      }
    }
    ```

2. Use a text editor to add the contents below to a new file named `credential.tf`.

    ```hcl
    variable "username" {
      default = "admin"
    }

    variable "password" {
      default = "Armtest1" #we_can_choose_any_password, except special_characters.
    }
    ```

This file is used for configuring your password.

To run RDS instances based on AWS Graviton processors you need to elect either **M6g** or **R6g** as the instance type.

The `main.tf` file selects **db.m6g.large** as the instance type.

## Terraform commands

Use the same sequence of Terraform commands as the previous topics: init, plan, and apply.

1. Initialize Terraform:

    ```bash
    terraform init
    ```

2. Create a Terraform execution plan (optional):

    ```bash
    terraform plan
    ```

3. Apply a Terraform execution plan:

    ```bash
    terraform apply
    ```

    Creating the RDS database may take a few minutes.

Wait for the deployment and then go to the AWS console.

### Verify RDS

In the AWS console, go to **RDS » Databases**, and check if the RDS instance is running.

![Image Alt Text:mariadb1](https://github.com/ArmDeveloperEcosystem/arm-learning-paths/assets/40816837/e692ab7a-2ab5-4017-b435-90fddec603ba)

## Connect to RDS

Make sure that the instance is correctly associated with a security group and VPC.

To connect to the RDS instance, find the endpoint. To find the Endpoint, go to **RDS »Dashboard » {{YOUR_RDS_INSTANCE}}**.

![Image Alt Text:mariadb2](https://github.com/ArmDeveloperEcosystem/arm-learning-paths/assets/40816837/df03a3ff-a91a-41de-a980-bcadee8ff6fd)

Using the **Endpoint** and the **user** and **password** mentioned in the `credential.tf` file you can connect using `mariadb`.

```bash
mariadb -h {{Endpoint}} -u {{user}} -p {{password}}
```

Replace **{{Endpoint}}**, **{{user}}** and **{{password}}** with your values.

Run `mariadb` to connect. The output is similar to:

```bash
mariadb -h {{Endpoint}} -u admin -pArmtest
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 6
Server version: 10.6.12-MariaDB-0ubuntu0.22.04.1 Ubuntu 22.04
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
```

For more information about accessing RDS refer to [Connecting to an Amazon RDS DB instance](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_CommonTasks.Connect.html).

### Create Database and Table

You can use the instructions from the previous topic to [access the Database and create a table](https://learn.arm.com/learning-paths/servers-and-cloud-computing/mariadb/ec2_deployment/#access-database-and-create-table).

### Clean up resources

Run `terraform destroy` to delete all resources created.

```bash
terraform destroy
```