1 st Connecting the Relational Database using Linux Machine.
First we will creating a RDs database from Storage---> RDS.
Steps to follow.
A) Create a MySQL DB instance:
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
a) On the top right corner of the Amazon RDS console, select the Region in which you want to create
the DB instance.
b) In the Create database section, choose Create database.
c) You now have options to select your engine. For this tutorial, click the MySQL icon, leave the
default value of edition and engine version, and select the Free Tier template.
d) You will now configure your DB instance. The list below
shows the example settings you can use for this tutorial:
e) Settings: DB instance identifier: Type a name for the DB instance that is unique for your account in
the Region that you selected.
Master username: Type a username that you will use to log in to your DB instance.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
f) Instance specifications: DB instance class: Select db.t2.micro --- 1vCPU, 1 GIB RAM. Storage type:
Select General Purpose (SSD). Allocated storage: Select the default of 20 to allocate 20 GB of
storage for your database.
Enable storage autoscaling: If your workload is cyclical or unpredictable, you would enable storage
autoscaling to enable RDS to automatically scale up your storage when
needed.
g) Connectivity
Virtual Private Cloud (VPC): Select Default VPC. For more information about VPC
h) Database options
Database name: Type a database name that is 1 to 64 alpha- numeric 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.
Now Step 2:
Create EC2 Linux Instances. go to first experiment. and Connect it.
Step 4: now to connect the database we need to create a local server on linux use following cmds to
create server.
Note: if not connect then go throug the default security group and then edit inbound rule
All trafic--->all TCP ---ip(anywhere). then save it
after some time it will be connected.
Step 5: Install mysql server and update the instance
$ sudo apt update
$ sudo apt install mysql-server
Step 5: Now create databse that will conects to the RDS DB instance.
mysql> create db student
mysql> use student;
mysql> create table student_class(
-> Name VARCHAR(20) NOT NULL,
-> TITLE VARCHAR(10) NOT NULL,
-> PRIMARY KEY (TITLE));
Query OK, 0 rows affected (0.03 sec)
mysql> SHOW TABLE student_class;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'student_class' at line 1
mysql> describe student_class;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| Name | varchar(20) | NO | | NULL | |
| TITLE | varchar(10) | NO| PRI | NULL | |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)2 rows in set (0.00 sec)
to check that all things is good go to RDS database now click on monitering
we can see that all data traffic is working when we created a database on terminal.
Now we have done this to connecting with linux Instance with RDS DB instance.
Comments