{"id":4418,"date":"2021-03-16T10:35:43","date_gmt":"2021-03-16T09:35:43","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=4418"},"modified":"2021-03-16T10:35:45","modified_gmt":"2021-03-16T09:35:45","slug":"mysql-in-amazon-rds","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2021\/03\/16\/mysql-in-amazon-rds\/","title":{"rendered":"MySQL in Amazon (RDS)"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

Up until now we have seen MDS<\/a> (MySQL Database Service) and MySQL in Azure<\/a>.
As the Cloud technology keeps moving fast, I thought it would be a good idea to see how to set up a MySQL in Amazon , as a service, that is RDS. <\/p>\n\n\n\n

Let’s get started then!<\/p>\n\n\n\n

What we need is an Amazon subscription that is really easy to get one and there is also a Free Tier. The AWS Free Tier is available to you for 12 months starting with the date on which you create your AWS account. When your free usage expires or if your application use exceeds the free usage tiers, you simply pay standard, pay-as-you-go service rates. <\/p>\n\n\n\n

For the specific session, I had root access. There is also the IAM user. AWS Identity and Access Management (IAM) is an AWS service that helps an administrator securely control access to AWS resources. IAM administrators control who can be authenticated<\/em> (signed in) and authorized<\/em> (have permissions) to use Amazon RDS resources. <\/p>\n\n\n\n

Once inside the Amazon Subscription, we are seeing the Management Console:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n\n\n

From the Management Console, we are able to identify the RDS service and choose it:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n\n\n

Once inside the RDS service, we click on the Create Database:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n\n\n

From the Databases provided, we are choosing MySQL and Standard Create, as we would like to set up our configuration.
With Easy Create enabled, you specify only the DB engine type, DB instance size, and DB instance identifier. 
Easy Create uses the default setting for other configuration options. <\/p>\n\n\n\n

With Easy Create not enabled, you specify more configuration options when you create a database, including ones for availability, security, backups, and maintenance.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n\n\n

Now, on MySQL versions we have chosen the latest provided until now for Amazon, that is 8.0.21<\/strong> :<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n\n\n

If you noticed, there is also the choice to choose Production , Dev or Free Tier template.
For Production Template, there are default options for High Availability and consistent performance. We have chosen the Free Tier, as this is for educational purposes. <\/p>\n\n\n\n

We have also given a Database Identifier, database-1. Each DB instance has a DB instance identifier.
This customer-supplied name uniquely identifies the DB instance when interacting with the Amazon RDS API and AWS CLI commands. The DB instance identifier must be unique for that customer in an AWS Region.<\/p>\n\n\n\n

Moving on next are the admin’s credentials, the super user of the database:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n\n\n

The DB instance class determines the computation and memory capacity of an Amazon RDS DB instance. The DB instance class you need depends on your processing power and memory requirements. Apparently, since we are only testing this we have a basic tier:<\/p>\n\n\n\n

db.t2<\/strong> \u2013 Instance classes that provide a baseline performance level, with the ability to burst to full CPU usage.<\/p>\n\n\n\n

Moving along with the rest of our options: <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n\n\n

Amazon RDS provides three storage types: General Purpose SSD (also known as gp2), Provisioned IOPS SSD (also known as io1), and magnetic (also known as standard). <\/p>\n\n\n\n

They differ in performance characteristics and price, which means that you can tailor your storage performance and cost to the needs of your database workload. <\/p>\n\n\n\n

You can create MySQL, MariaDB, Oracle, and PostgreSQL RDS DB instances with up to 64 tebibytes (TiB) of storage. You can create SQL Server RDS DB instances with up to 16 TiB of storage.
For this amount of storage, use the Provisioned IOPS SSD and General Purpose SSD storage types.<\/p>\n\n\n\n

The following list briefly describes the three storage types:<\/p>\n\n\n\n