untung99play.xyz: Create and Connect to a MySQL Database with Amazon RDS

In this step, we will use Amazon RDS to create a MySQL DB Instance with db.t2.micro DB instance class, 20 GB of storage, and automated backups enabled with a retention period of one day. As a reminder, all of this is Free Tier eligible.

a. Open the AWS Management Console in a new browser window, so you can keep this step-by-step guide open. When the console opens, select Database from the left navigation pane and choose RDS to open the Amazon RDS console.

b. In the top right corner of the Amazon RDS console, select the Region in which you want to create the DB instance.

Note: AWS Cloud resources are housed in highly available data center facilities in different areas of the world. Each Region contains multiple distinct locations called Availability Zones. You have the ability to choose which Region to host your Amazon RDS activity in.

c. In the Create database section, choose Create database.

d. You now have options to select your engine. For this tutorial, choose the MySQL icon, leave the default value of edition and engine version, and select the Free Tier template.

Multi-AZ deployment:
Note that you will have to pay for Multi-AZ deployment. Using a Multi-AZ deployment will automatically provision and maintain a synchronous standby replica in a different Availability Zone. For more information, see High Availability Deployment.

e. You will now configure your DB instance. The list below shows the example settings you can use for this tutorial:

Settings:

• DB instance identifier: Type a name for the DB instance that is unique for your account in the Region that you selected. For this tutorial, we will name it rds-mysql-10minTutorial.
• Master username: Type a username that you will use to log in to your DB instance. We will use masterUsername in this example.
• Master password: Type a password that contains from 8 to 41 printable ASCII characters (excluding /,”, and @) for your master user password.
• Confirm password: Retype your password

Instance specifications:

• DB instance class: Select db.t2.micro — 1vCPU, 1 GiB RAM. This equates to 1 GB memory and 1 vCPU. To see a list of supported instance classes, see Amazon RDS Pricing.
• Storage type: Select General Purpose (SSD). For more information about storage, see Storage for Amazon RDS.
• Allocated storage: Select the default of 20 to allocate 20 GB of storage for your database. You can scale up to a maximum of 64 TB with Amazon RDS for MySQL.
• Enable storage autoscaling: If your workload is cyclical or unpredictable, you would enable storage autoscaling to enable Amazon RDS to automatically scale up your storage when needed. This option does not apply to this tutorial.
• Multi-AZ deployment: Note that you will have to pay for Multi-AZ deployment. Using a Multi-AZ deployment will automatically provision and maintain a synchronous standby replica in a different Availability Zone. For more information, see High Availability Deployment.

f. You are now in the Connectivity section where you can provide information that Amazon RDS needs to launch your MySQL DB instance. The list below shows settings for our example DB instance.

Connectivity

• Compute resource: Choose Don’t connect to an EC2 compute resource. You can manually set up a connection to a compute resource later.
• Virtual Private Cloud (VPC): Select Default VPC. For more information about VPC, see Amazon RDS and Amazon Virtual Private Cloud (VPC).

Additional connectivity configurations

• Subnet group: Choose the default subnet group. For more information about subnet groups, see Working with DB Subnet Groups.
• Public accessibility: Choose Yes. This will allocate an IP address for your database instance so that you can directly connect to the database from your own device.
• VPC security groups: Select Create new VPC security group. This will create a security group that will allow connection from the IP address of the device that you are currently using to the database created.
• Availability Zone: Choose No preference. See Regions and Availability Zones for more details.
• RDS Proxy: By using Amazon RDS Proxy, you can allow your applications to pool and share database connections to improve their ability to scale. Leave the RDS Proxy unchecked.
• Port: Leave the default value of 3306.

g. Amazon RDS supports several ways to authenticate database users. Choose Password authentication from the list of options

Monitoring

• Enhanced monitoring: Leave Enable enhanced monitoring unchecked to stay within the Free Tier. Enabling enhanced monitoring will give you metrics in real time for the operating system (OS) that your DB instance runs on. For more information, see Viewing DB Instance Metrics.
  
  

In the Additional configurations section:

Database options

• Database name: Enter a database name that is 1 to 64 alphanumeric characters. If you do not provide a name, Amazon RDS will not automatically create a database on the DB instance you are creating.
• DB parameter group: Leave the default value. For more information, see Working with DB Parameter Groups.
• Option group: Leave the default value. Amazon RDS uses option groups to enable and configure additional features. For more information, see Working with Option Groups.

Encryption: This option is not available in the Free Tier. For more information, see Encrypting Amazon RDS Resources. 

Backup

• Backup retention period: You can choose the number of days to retain the backup you take. For this tutorial, set this value to 1 day.
• Backup window: Use the default of No preference.

Maintenance

• Auto minor version upgrade: Select Enable auto minor version upgrade to receive automatic updates when they become available.
• Maintenance Window: Select No preference.

Deletion protection: Turn off Enable deletion protection for this tutorial. When this option is enabled, you’re prevented from accidentally deleting the database.

Choose Create Database.

h. Your DB instance is now being created.

Note: Depending on the DB instance class and storage allocated, it could take several minutes for the new DB instance to become available.

The new DB instance appears in the list of DB instances on the RDS console. The DB instance will have a status of creating until the DB instance is created and ready for use. When the state changes to available, you can connect to a database on the DB instance. 

Feel free to move on to the next step as you wait for the DB instance to become available.