RDS part3

RDS part3

Class 50th AWS RDS June 20th
Amazon aurora (AWS Deployed Aurora (MySQL Compatible),Aurora (PostgreSQL Compatible))

• Amazon aurora is a relational database service offered by Amazon web service(AWS) that is designed for high performance, availability ,and compatibility with MySql and Postgresql

• Amazon Aurora gives us to 128 TB of auto scaling SSD storage(its is 64 TB for RDS Mysql or other DB engines)

• Up to five times the throughput of mysql community edition and times than Postgressql community edition.

• Amazon aurora doesn’t available under free limitation, minimum 10 mins bill will be generated on creation (1 sec traffic follow)

• Aurora Db available with cluster endpoint and read endpoint restore,clone and backtrack features available in the aurora.

backtrack means if any structure changes done wrongly, we can backtrack restore the change previous state. 

Step1:RDS Aurora Serverless 

Amazon Aurora serverless is a deployment option within amazon aurora(both Mysql and postgreSql-compatible editions) that automatically starts up,shutdown, and scales capacity based on your applications needs
Key Feature
Auto-scaling
Automatic capacity adjustment: Aurora server scales the database’s compute capacity seamlessly,based on the current workload.
Minimum and maximum capacity: you can define the minimum and maximum aurora capacity units(ACUs) to ensure that the database scales within the desired range.
Cost-Efficiency:
Pas-as-you-go: You only pay for the database capacity you actually use,billed per second with a minimum of five minutes of usage each time the database is active.

(Serverless means your are not maintained the server, based you demand of Usage, ACUs will increase automatically, we have issue early yar cold start whenever the use the database db container create through container will connect to the database though container, if are not use the database db container will destroy, if are trying to access again database it will take time to create container available to access data these are will complete in seconds we called these period call cold start. to over come the issue serverless always available container. these issue still exists in lambda function. )

Select Don't create aurora replicate,choose VPC and availability zone

select public access if required,

and then click create the database 

Blue-Green Deployment

Developer do the changes the final changes deploy into the production, instead of direct deployed into production here blue-green two instance are available zero downtime, apply the change first green environment, after successfully apply the change switch over to Blue ,so here zero downtime apply the changes.

Practical: Create one Free tier database mysql,with backup enable 

Step1:

Instance configuration :Burstable classes (includes t classes)

Public access :yes

VPC :select you VPC 

db subent grp:choose you subnet grp

Initial schema name give any (ccitdb)

Finally click create database

Step2:

Connect mysql endpoint, successfully.

Step3:Click blue/green deployment 

Step4:Given deployment name ccitdb-green ,no change 

if you want modify any configuration ,you can do else no change click next.

Below is the overview before create and then click create

Creating the database 

Step5:Created successfully Green database, here mysqldb-greenblue (Blue) is primary database

mysqldb-green is the secondary database.

Connected the secondary database mysql-green it is standby ready only replicate of primary

See here i have insert the record in the blue database

Records came automatically green database, here green is the read only database.

unable delete green database ready only, as see emp blue i have created, automatically came green database.

if required easily switchover standby to primary, once click switchover it will automatically changed standby to primary primary to standby.

Step6:Delete the stand by and then primary and then finaly db indentifier 

Step7: This Finally step

--Thanks