Creating a DB Security Group

Home»
»Creating a DB Security Group

Creating a DB Security Group

1)      The first step towards creating a DB Security Group is to provide a name and description:

  • Sign-in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.
  • In the “Navigation” pane select “US East” from the “Region” drop-down menu.
  • Click “DB Security Groups” in the “Navigation” list on the left side of the window.
  • Click the “Create DB Security Group” button.

The “Create DB Security Group” window will appear.

  • You need to type the name of your new DB Security Group in the “DB Security Group” text box. For this particular example, we will type “mydbsecuritygroup” (without the quotes).
  • You also have to type a description for your DB Security Group in the “Description” text box.
  • Click on the “Yes, Create” button.

2)      Now, you will need to authorize your Amazon EC2 security group, and grant it access to your DB Security Group:

  • Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.
  • In the “Navigation pane” you need to select “US East” from the “Region” drop-down menu.
  • Now, click on “DB Security Groups” in the “Navigation” list (on the left side of the window), and select “mydbsecuritygroup”.
  • Select “EC2 security group” in the drop-down menu on the “Connection Type” column.
  • In the “Details” column, you should click “webappsecuritygroup” in the “EC2 Security Group” list.
  • In the “Details” column, your AWS Account ID will appear in the “AWS Account ID” box. To change the AWS Account ID, click “Change”, and type your AWS Account ID in the “AWS Account ID” box.

Note: You should make sure that all hyphens have been removed while typing your account ID.

  • Now, you need to click “Add” in the “Actions” column.

Authorization will take place in a few minutes. Once the security group is authorized, the “Status” column will say “Authorized”. Now, we will move on and launch your first Amazon RDS database.

3)      Here is how you can launch an instance by starting the launch wizard:

Note: The AWS Management Console will log you out automatically if you pause for a long time while carrying out this procedure. However, you can stay logged in by clicking “Settings” (in the top right corner of the console window), and clearing the “Sign out on inactivity” check box.

  • Now, you need to select “US East” from the “Region” drop-down menu in the “Navigation” pane.
  • To start the “Launch DB Instance Wizard”, click “Launch Database Instance” from the Amazon RDS Console Dashboard

The wizard will automatically open on the “ENGINE SELECTION” page.

Launch DB Instance wizard

  • Click the “Select” button (next to the MySQL database engine).

The wizard will continue to the “DB Instance Details” page. The first page of the wizard always displays a list of DB Instance Classes in the “DB   Instance Class” drop - down list. The CPU and memory capacity of your DB Instance is defined by DB Instance Class.

Launch DB Instance wizard 2

  • On the “DB INSTANCE DETAILS” page, you are required to specify your DB Instance details (as shown in the following table), and then click on the “Continue” button.

For this parameter…

 Do this
License Model Keep the default: general-public-license.
DB Engine Version Keep the default: 5.1.57 (default).
DB Instance Class Select db.m1.small.
Multi-AZ Deployment Keep the default setting of Yes. Although the Multi-AZ deployment is more expensive, it is a best practice.
Auto Minor Version Upgrade Keep the default setting of Yes for this example.The Auto Minor Version Upgrade option enables your DB Instance to receive minor engine version upgrades automatically when they become available.
Allocated Storage You can specify how much storage in gigabytes you want initially allocated for your DB Instance. For this example, type 5.
DB Instance Identifier The DB Instance is a name for your DB Instance that is unique for your account in a Region.Type mydbinstance in the DB Instance Identifier text box.
Master Username Type a name for your master user in the Master Usernametext box.You use the master user name to log on to your DBInstance with all database privileges.
Master Password

Type a password for your master user in the Master User

Password text box.

 

 

 

 

 

 

 

 

 

 

 

 

Important Note: Your password can only contain 4 to 16 alphanumeric characters.

Upon clicking the “Continue” button, the “ADDITIONAL CONFIGURATION” page will appear.

Launch DB Instance wizard 3

  • Type “mydb” (without quotes) into the “Database Name” text box. The database name is provided by you so that Amazon RDS can create a default database on your DB Instance. Amazon RDS will not create a database on your DB Instance if you skip this step.
  • Select “mydbsecuritygroup” in the “DB Security Groups” box.
  • For all the other parameters available on this page, accept the default values, and then click the “Continue” button.

The “MANAGEMENT OPTIONS” page will be seen now. This page is used to specify maintenance and backup options for your DB Instance.

  • For this particular example, we will accept all the default values, and click on the “Continue” button.

The “REVIEW” panel will appear now.

4)      Now it is time to review all the options for your DB Instance.

  • Click “Back” to return to previous pages if you need to correct any options.
  • After checking to ensure that all your options are entered correctly, click on the “Launch DB Instance” button to launch your new DB Instance.

A message will appear saying “Your DB Instance is being created”. Be patient as this process can take a few minutes to complete.

  • Click “Close”.

The “My DB Instances” panel will appear now. Your DB Instance will appear in the list on this page with the status “creating”, until your DB Instance is finally created, and is ready for use.

         Once your DB Instance status changes to “available”, you will be billed for each hour in which your DB Instance is running, even if it is idle.