Amazon RDS is a Relational database service provided by AWS. Welcome Back guys, In this article, we are going to demonstrate the simplest way to create an Amazon RDS MySQL instance and connect it with MySQL Workbench(From Your System).
What is Amazon Web Services(AWS)?
Amazon Web Services(AWS) is the biggest cloud platform, offering more than 200 services.
AWS has data centers that are globally located. Today we are going to learn Amazon Relational Database Service (AWS RDS).
What is Amazon RDS (Relational Database Service)?
RDS is that the Relational database Service Available from Amazon web services which enables us to create any type of Relational database instance without having any knowledge about the infrastructure behind it.
Users can connect with this instance from local devices very easily.
This tutorial will focus more on the way to configure the AWS RDS MySQL Environment and not much on the MySQL details.
With the advantage of cloud computing services, businesses can implement sophisticated Relational database(RDBMS) solutions quickly and efficiently without having to deploy additional hardware or hire additional specialized engineers.
A major example of 1 of those cloud-based tools is that the Amazon Relational database Service (Amazon RDS), which supports several database instance types, including PostgreSQL, Amazon Aurora, Oracle Database, MySQL, MariaDB, and SQL Server.
How to create a MySQL database on Amazon Web Services(aws)?
Step-1: Login into Your AWS account:
Let us begin configuring the RDS MySQL Database Environment by the first login to your AWS Account.
Once you’ve got successfully login the AWS account, search for RDS in the Services bar, and hit enter.
Or Click on the service bar you will find RDS Under Database.
Click on RDS This will open RDS Dashboard.
On Dashboard, You will find all information related to your RDS.
You will also find Create Database button, click on that. this opens another page where we can define the required details required to set up the MySQL Database.
Step-2: Setup MySQL RDS Settings.
1. Select Database Creation Method:
Once you click on the Create Database button, a new page opens as Above, where you can define the database creation method and so many other options.
We are getting to select Standard Create because of the database creation method, this may allow us to configure all the required settings on our own.
2. Selecting the Database Engine
Here you will find all available database engines. Till 2020 Amazon RDS supports Amazon Aurora, MySQL, MariaDB, PostgreSQL, Oracle, Microsoft SQL Server.
Next, select the Engine Type as MySQL and therefore the latest version. At the time of this article, the newest MySQL version in 8.0.20.
3. Select AWS RDS Templates
For this demo, I am going to select Free Tier. for practice purposes I recommend selecting Free tier.
4. Name And Connection Details
Now, we are going to provide the name and connection details for the MySQL Database.
Provide an appropriate name for the database instance, for instance, I am going to use the database instance as “freestylecoder”.
Similarly, provide an appropriate master(like root user in your local system) username and password for a DB Instance. This username password we are going to used when we want to access our Amazon RDS MySQL Database from the local system or from any other AWS services.
Also, you want to keep these credentials safe in order that they are used later again.
5. DB Instance Class
Here You can select the Instance type. here I am going to select t2 micro.
6. Storage for Amazon RDS
The first option is that you can select which type of hard disk you want. Always select SSD because it’s faster.
The second option is you can select storage size according to your need.
You can also turn on autoscaling. and set the maximum threshold value for autoscaling.
7. AWS Connectivity
Connectivity is the most important part. You have to give the public access to your Amazon RDS MySQL Database.
You can create your own VPC groups or you can use the default VPC Security group.
8. Create Database
Now, Click on Create Database Button.
Once you click on Create Database within the previous step, it will take a short time for AWS to make the RDS instance and make it available to be used. After a couple of moments, you will receive a notification that says the database has been created successfully.
You can see the status of your database. It will take 10-15 minutes to make the database available to you.
As you’ll see within the figure above, I even have already created an RDS instance for SQL Server previously, the newly added MySQL Community instance (freestylecoder) is additionally added to the Databases list.
9. RDS MySQL Instance Created Successfully
Once your database status is available then you are ready to use this database.
Click on your database name. It provides MySQL instance details concerning recent events, including CPU Utilization, DB connections, Free space for storing.
To check the required information, switch between the tabs.
10 Amazon RDS Endpoint
Click on the DB name. A new replacement page will open containing more information about the MySQL database instance.
Note that you simply will get to specify both the DNS address from the instance endpoint (as host address) and therefore the port number (as port) within the connection string to attach to the MySQL instance.
The most important thing to notice here is that the Endpoint is out there. This endpoint information is going to be used later to attach to the instance using the MySQL Workbench tool.
When the status of the instance is become available, which suggests that the database instance has been deployed, you will MySQL Workbench to connect Amazon RDS.
Step-3: Connect MySQL RDS with MySQL Workbench(in the local machine).
1. Add RDS Connection in Workbench
Open MySQL Workbench. You will see a Home screen as above.
Now, Click on the (+) button, Which indicates that Create a new Connection.
New Window will Open.
- Connection Name: You can give any connection name which you want.
- Host Name: Copy the DNS address provided by Amazon RDS (instance Which we created).
- Username: add username which you provide at the time of the creation of Amazon RDS instance.
- Password: Click on Store in Vault Button It will open another window. now, type your MySQL RDS password and hit enter.
Now, Click On test Connection.
If everything goes right you will see the above window. Successfully made the MySQL connection.
You can see Hostname, Port name, User name.
You are ready to use your database.
On the home screen of your MySQL Workbench, you can see a new connection is added.
Double click on that and you will be redirected to your database.
Your Amazon RDS MySQL Database is Configured Successfully. you can create a database and do what where you want to do.
Now that you simply have successfully set remote connections to AWS RDS.
Amazon RDS is that the Relational database service which is provided by AWS using which it’s very easy to create any RDBMS without fear much about the infrastructure.
In this article, we saw the way to configure the RDS MySQL Database Environment in AWS. we also see the way to connect the MySQL instance with the local system using MySQL Workbench.
You can calculate the cost of your RDS instance.