RDS part2
Class 49th AWS RDS June 19th
RDS(Relational database system)
We have Different types of database Deployment available in AWS
Single-AZ DB instance deployment (Single database instance,without stand by)
Multi-AZ DB Single instance deployment(2 instance, 1 for primary instance and 1for standby instances)
Multi-AZ DB cluster deployment (3 instance, 1for primary instance and 2 for readable standby instances)
Multi-AZ -Single instance
Key feature of RDS multi-AZ deployments
High Availability.
Automatic failover(60-120 seconds)
Synchronous replication
Maintenance operations
Backups and snapshots on stand by instance
Note: It is not free service and it doesn’t support multi region access.
Key feature of RDS multi-AZ deployments
High Availability.
Automatic failover(60-120 seconds)
Synchronous replication
Maintenance operations
Backups and snapshots on stand by instance
Note: It is not free service and it doesn’t support multi region access.
Below is the structure of the, 1 database instance provide primary avail zone, if any case primary was down, automatically stand by change to primary database without changing endpoint ,both the databases always synchronize replicate stand by with in milli second if changes are done in primary
Practical:
Msql installation:
Step1: https://dev.mysql.com/downloads/installer/ , Click Full
click next >click execute >click next
Authentication method Choose below option
Use Strong password of authentication
Give mysql root user password and repeat password
Click next
Click next
Server file file permission
Click next
Apply configuration
Click execute
Click Finish
Click Next
Click Finish
Product configuration
Click Next
Connect server given root password check
Connect succeeded
Click next
Click execute
Click finish
Click next
Click finish
My sql installed successfully.
Synchronize :Once any record or change done database level immediately reflecting change Primary AZ 1-->Stand by after apply change send acknowledgement to primary, after received acknowledgement then only further change will sent to stand by instance that is called synchronization
Asynchronized :sending the changes only not expecting any acknowledge for the stand by server
Multi-AZ -Single instance Only is available single instance to connect
Step2: Multi Az DB instance deployment >select Mysql >Templates dev/test
DB instance identifier ccit-multi-az-single, give admin user master password and instance configuration need to choose only Burstable classes it is less cost compared to standard classes
Standard classes give very large configuration
Burstable classes give very less configuration
db t3.micro ,20 GB minimum
uncheck the enable storage auto scaling, select the existing VPC ,You need create subnet group
Step3:Create subnet group
Aurora and RDS >Subnet groups give any name "ccit_subnet_grp" choose you availability zone and subnet click create
Step4: As see db subnet group came automatically after refresh ,select public access yes
initial schema created.
Enhanced Monitoring
Uncheck Enable Enhanced monitoring
Additional configuration
Backup
Uncheck Enable automated backups
Uncheck Enable encryption
Uncheck Enable auto minor version upgrade
Click Create database
As you see below ccitdb default schema created automatically
CREATE TABLE `ccitdb`.`users` (
`id` INT NOT NULL AUTO_INCREMENT,
uname varchar2(45),
PRIMARY KEY (`id`));
Step5: if you want change the time database side , you need change Parameter groups
Current time
select now()
| 2025-06-21 03:15:48 |
--Thanks
No comments:
Post a Comment