Skip to content

Create RDS 🗃️

Amazon Relational Database Service (RDS) is a managed database service provided by Amazon Web Services (AWS). It allows you to easily set up, operate, and scale a relational database in the cloud. RDS supports various database engines, including Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle, and Microsoft SQL Server.

To create an Amazon RDS instance, follow these steps:

  1. Sign in to the AWS Management Console: Go to the AWS Management Console 'Aws Console' and sign in using your AWS account credentials.

  2. Open the RDS service: Once you're logged in, open the AWS Management Console and search for "RDS" in the search bar. Click on the "Amazon RDS" result that appears.

  3. Choose a database engine: On the Amazon RDS dashboard, click on the "Create database" button.

4.Select the database engine: In the "Create database" wizard, choose the desired database engine you want to use for your RDS instance. You can select from options like Amazon Aurora, PostgreSQL, MySQL, etc. Click on the engine of your choice.

  1. Specify the DB details: Fill in the required details such as DB instance identifier, username, and password. You can also choose the instance size, storage type, allocated storage, and other configuration options based on your requirements.

  2. Configure advanced settings: If you have specific requirements, you can configure advanced settings such as VPC, subnet group, database options, security groups, backups, and monitoring. Adjust these settings as needed.

  3. Set up the database: Configure additional settings like database name, port number, master username, and password. You can also enable options like automated backups, monitoring, and performance insights.

  4. Choose the storage: Select the storage type (e.g., General Purpose SSD, Provisioned IOPS, Magnetic) and specify the allocated storage size based on your needs.

  5. Configure the networking: Choose the appropriate virtual private cloud (VPC) and subnet group for your RDS instance. You can also specify the publicly accessible settings and configure network security using security groups.

  6. Review and create: Review all the configuration details you have provided in the previous steps. Double-check the settings to ensure they are correct. If everything looks good, click on the "Create database" button.

  7. Wait for the RDS instance creation: AWS will now create your RDS instance based on the specified configuration. This process may take a few minutes.

  8. Access and use the RDS instance: Once the RDS instance is created successfully, you can access it using the provided endpoint. Use the appropriate database client or tools to connect to your RDS instance and start using it.

create an Amazon RDS instance using Terraform.

To create an Amazon RDS instance using Terraform, you need to have Terraform installed and configured on your local machine. Follow these steps to create an RDS instance using Terraform:

  1. Initialize a new Terraform project: Create a new directory for your Terraform project and navigate to it using the command line. Run the command terraform init to initialize the project and download the necessary provider plugins.

  2. Create a Terraform configuration file: Create a new file with a .tf extension (e.g., main.tf) and open it in a text editor. This file will contain the Terraform configuration for creating the RDS instance.

  3. Configure the AWS provider: In your main.tf file, add the following code to configure the AWS provider:

provider "aws" {
  region = "your_region"
  access_key = "your_access_key"
  secret_access_key = "your_secret_access_key"
}

Replace your_region with the desired AWS region where you want to create the RDS instance. Replace your_access_key and your_secret_access_key with your own AWS access key and secret access key. Alternatively, you can set environment variables or use other authentication methods supported by Terraform.

  1. Define the RDS instance resource: Add the following code to define the RDS instance resource in your main.tf file:
resource "aws_db_instance" "example" {
  identifier             = "example-rds-instance"
  engine                 = "mysql"
  engine_version         = "8.0"
  instance_class         = "db.t3.micro"
  allocated_storage      = 20
  storage_type           = "gp2"
  username               = "db_user"
  password               = "db_password"
  name                   = "example_database"
  parameter_group_name   = "default.mysql8.0"
  publicly_accessible    = false

  vpc_security_group_ids = [
    "sg-12345678",
    "sg-87654321"
  ]

  tags = {
    Name = "Example RDS Instance"
  }
}

Terraform will show you a preview of the resources it will create. Review the plan, and if everything looks good, type "yes" when prompted to confirm and create the RDS instance.

  1. Wait for the RDS instance creation: Terraform will create the RDS instance according to the specified configuration. This process may take a few minutes. You can monitor the progress in the command line. Once the RDS instance creation is complete, you will see the output in the command line. You can now use the RDS instance for your applications by connecting to it using the provided endpoint.

Remember to manage your Terraform state files properly and use best practices for versioning and infrastructure-as-code workflows with Terraform.