01

of 03

Lab Details

1. This lab walks you through the steps to launch an Amazon RDS DB instance with multi-AZ enabled. We will also simulate a database failover from one AZ to another.

2. You will practice using Amazon RDS.

3. Duration: 30 minutes

4. AWS Region: US East (N. Virginia) us-east-1

Support me: https://www.buymeacoffee.com/kientree

02

of 03

Lab Requirements

1. A company is deploying a new web application. Configure a highly available MySQL 8.0 database with the following:

2. Use the us-east-1 Region for all resources.

3. Unless specified below, use the default configuration settings.

4. Create a custom DB parameter group and set the event_scheduler parameter to true and use this parameter group during DB instance creation.

5. Create a custom AWS Key Management Service (AWS KMS) key and use this key during DB instance creation.

6. Create a VPC security group that allows TCP port 3306 from the CIDR block 192.168.1.0/24. Use this security group during DB instance creation.

7. Launch the Amazon RDS DB instance.

8. After launch, take a manual RDS DB snapshot.

9. Provide the snapshot Amazon Resource Name (ARN): _________________

03

of 03

Lab Steps

Step 1: Create a custom DB parameter group and set the event_scheduler parameter to true and use this parameter during DB instance creation.

1. Open the Amazon RDS console from https://console.amazonaws.com/rds/

2. In the Resources section, choose Parameter groups.

3. Choose Create parameter group.

4. In the Parameter group family list, select mysql8.0

5. In the Group name box, enter the new DB cluster parameter group name of mysql80witheventscheduler.

6. In the Description box, enter a description for the new DB cluster parameter group.

7. Choose Create.

8. In the list of parameter groups, check the box next to the parameter group that you want to modify, which is mysql80witheventscheduler.

9. Choose Parameter group actions and choose Edit.

10. In the Filter parameters box, enter event_s. This should filter just the event_scheduler parameter.

11. Choose the box for the event_scheduler parameter. Under Values, change the setting to ON.

12. Choose Save changes.

Step 2: Create a custom AWS Key Management Service (AWS KMS) key and use this key during DB instance creation.

1. Open the AWS KMS console from https://console.aws.amazon.com/kms

2. In the navigation pane, choose Customer managed keys.

3. Choose Create key.

4. To create a symmetric CMK, for Key type, choose Symmetric.

5. Choose Next.

6. Type the alias or display name for the CMK. For this walkthrough, use the value mysqlDbKey

7. (Optional) Type a description for the CMK.

8. Choose Next.

9. (Optional) To add a tag, click Add tag. Type a tag key and an optional tag value. To add more than one tag to the CMK, choose Add tag.

10. Once completed, choose Next.

11. Select the IAM users and roles that can administer the CMK. For this walkthrough, use your IAM user.

12. Choose Next.

13. Select the IAM users and roles that can use the CMK for cryptographic operations. For this walkthrough, none are needed.

14. Choose Next.

15. Review the key policy document that was created from your choices. Note that it can also be edited.

16. Choose Finish to create the CMK.

Step 3: Create a VPC security group that allows TCP port 3306 from the CIDR block 192.168.1.0/24 and use this security group during DB instance creation.

1. Open the Amazon VPC console at http s://console.aws.amazon.com/vpc/home.

2. In the navigation pane, choose Security Groups.

3. Choose Create security group.

4. Enter a name for the security group (for example, mysqlAccessGroup) and then provide a description.

5. From VPC, select the ID of your VPC.

6. Under Inbound rules, choose Add rule.

7. Set Type to MYSQL/Aurora.

8. Set Source to 192.168.1.0/24.

9. Scroll down and choose Create security group.

Step 4: Launch the Amazon RDS DB instance.

1. Open the Amazon RDS console from http s://console.aws.amazon.com/rds/

2. In the navigation pane, choose Databases.

3. Choose Create database.

4. On the Create database page, verify that the Standard create option is chosen. Then choose MySQL.

5. In the Templates section, choose Free Tier.

6. In the DB instance identifier section, type the name mysqldemo

7. In the Settings section, set these values:

Master password
Confirm password – Retype the password.

10. In the DB instance size section, set these values:

Burstable classes (includes t classes)
db.t3.micro

11. In the Connectivity section, for Virtual private cloud (VPC), choose an existing VPC.

12. Expand the Additional connectivity configuration menu and set these values:

For Subnet group select the DB subnet group.
For Public access, select No.
For Existing VPC security groups choose mysqlAccessGroup.

13. Remove the other existing security groups, such as the default security group, by choosing the X associated with each.

14. Expand the Additional configuration section.

15. For the DB parameter group, select mysql80witheventscheduler

16. For Master key, select mysqlDbKey

17. Choose Create database to create your RDS MySQL DB instance.

Step 5: After launch, take a manual RDS DB snapshot.

1. Open the Amazon RDS console from https://console.aws.amazon.com/rds/.

2. In the navigation pane, choose Databases.

3. In the list of DB instances, choose the DB instance for which you want to take a snapshot.

4. Choose Actions and choose Take snapshot.

5. The Take DB snapshot window appears.

6. In the Snapshot name box, type the name of the snapshot. For this walkthrough, use mysqlsnapshot.

7. Choose Take snapshot.

8. From the RDS console, in the navigation pane, choose Snapshots.

9. Choose the snapshot name mysqlsnapshot

10. In the Details section, note the ARN field and the ARN.

11. Provide the DB snapshot ARN: ____________

Support me: https://www.buymeacoffee.com/kientree

Tags: AWS

Create a highly available RDS database | AWS SOA C02 Hands-On Labs

01 of 03 Lab Details

02 of 03 Lab Requirements

03 of 03 Lab Steps