Exploring options in creating RDS Databases | Scribe

    Exploring options in creating RDS Databases

    • Hafeez Baig |
    • 24 steps |
    • 4 minutes
    information ordinal icon

    Refer to the following guide to learn how to use IAM in the cloud\ <https://scribehow.com/shared/Creating_an_IAM_User_and_User_Group_in_AWS_Management_Console__hWNiiXlcRJKFqYZZEJD-cg>

    1

    Sign in to **AWS Management Console** as an **IAM User** **Pre-requisite** - Ensure you have selected the AWS region closest to your location\ For this guide, we will be using us-east-2 (Ohio) as a preferred choice

    2

    Type **RDS** in the search bar and click on **RDS** to view the RDS Dashboard

    information ordinal icon

    **What is RDS in AWS?** Amazon RDS (Relational Database Service) is a fully managed database service provided by Amazon Web Services (AWS). It enables you to set up, operate, and scale relational databases in the cloud without the need for managing the underlying infrastructure.

    3

    On **RDS** dashboard, scroll to the Create database section and click on the **Create database** button

    4

    **Create database** wizard will open, choose the option **Standard create**

    5

    Scroll to the **Engine options** section, select the option **MySQL**

    information ordinal icon

    **What is MYSQL Engine type in RDS?** In Amazon RDS (Relational Database Service), the MySQL engine type refers to the MySQL database engine that is available as a managed service. MySQL is an open-source relational database management system (RDBMS) widely used for building web applications, content management systems, and various other types of software.

    6

    Scroll to the **Engine Version** section and from the dropdown section and select the option **MySQL 8.0.35** or whichever is the latest version

    7

    Scroll to the **Templates** section and select the option **Production**

    information ordinal icon

    **What is Production Template in RDS?** In Amazon RDS (Relational Database Service), a "Production Template" refers to a predefined configuration or setup that is tailored for deploying database instances optimized for production workloads.

    8

    Scroll to the **Availability and durability** section and select the option **Multi-AZ DB Cluster**

    information ordinal icon

    **What is a Multi-AZ DB cluster in RDS?** In Amazon RDS (Relational Database Service), a Multi-AZ DB cluster refers to a deployment configuration for Amazon Aurora databases that spans multiple availability zones (AZs) within a specific AWS region. Amazon Aurora is a fully managed relational database engine compatible with MySQL and PostgreSQL.

    9

    Scroll to the **Settings** section, under the **DB instance identifier** section enter "**database-1**" in the text input field

    10

    Scroll to the **Credentials managements** section and select the option **Managed in AWS Secrets Manager**

    11

    Scroll to the **Instance configuration** section, select the option **Standard classes (includes m classes)**

    information ordinal icon

    **What is the DB instance class in RDS?** In Amazon RDS (Relational Database Service), a "DB instance class" refers to a specification that determines the computational resources (CPU, memory, and networking capacity) allocated to a database instance.

    12

    Scroll to the **Storage** section, select **Storage type** as **Provisioned IOPS SSD (io1)** from the dropdown and type "**400"** in the text input field for **Allocated storage**

    information ordinal icon

    **What is the Provisioned IOPS SSD (io1) Storage type?** Provisioned IOPS SSD (io1) is a storage type option in Amazon RDS (Relational Database Service) designed for high-performance database workloads. It offers consistent and predictable Input/Output Operations Per Second (IOPS) performance, making it suitable for applications with demanding I/O requirements, such as transactional databases and OLTP (Online Transaction Processing) systems.

    13

    Scroll to the **Storage autoscaling** section, here you can enable the Storage autoscaling