Creating Your First RDS Database in AWS | Scribe

Creating Your First RDS Database in AWS

  • Hafeez Baig |
  • 23 steps |
  • 3 minutes
  • Amazon Web ServicesAmazon Web Services
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, scroll to the **Choose a database creation method** section and select 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 **Free tier**
8
Scroll to the **Settings** section, type "**mysqldatabase**" in the text input field for DB instance identifier
9
Scroll to the **Credentials Settings** section and type "**admin**" in the **Master username** text input field
10
Scroll to the **Credentials management** section and tick the checkbox **Auto generate password** or you can type your custom Master password
11
Scroll to the **Instance configuration** section, select the option **Burstable classes (includes t classes)**
information ordinal icon
In Amazon Web Services (AWS), RDS (Relational Database Service) offers various classes for its database instances, including Burstable classes, which include the "t" classes. Burstable performance instances are designed for workloads that don't require consistently high CPU utilization but may occasionally need bursts of CPU power. These instances are ideal for applications with unpredictable workloads or periodic spikes in activity.
12
Scroll to the **Storage** section and select the option **General Purpose SSD (gp2)** from the **Storage type** dropdown
information ordinal icon
**What is the General Purpose SSD (gp2) Storage type in RDS?** In Amazon RDS (Relational Database Service), "General Purpose SSD (gp2)" refers to a type of storage volume that is commonly used for RDS instances. GP2 volumes provide a balance of price and performance suitable for a wide range of workloads.
13
For the Allocated storage type "**20"** in the text input field
14
Expand the **Additional storage configuration** section, and under the Storage autoscaling, tick on the checkbox **Enable storage autoscaling** and give **Maximum storage threshold** as "**1000**" in the text input field.
information ordinal icon
**What is Storage autoscaling in RDS?** Storage autoscaling in Amazon RDS (Relational Database Service) is a feature that automatically adjusts the storage capacity of your RDS database instance in response to changes in storage usage.