Skip to main content

21.AWS-RDS-MySQL.mp4

21.AWS-RDS-MySQL.mp4:


......AWS-RDS-MySQL..........
Database::

1.RDS:-Relational DB Systems-SL,Oracle,MySQl,Postgres,Maria,AWS Arora

2.DynamoDB:-NoSql(Cassandra & Mondo)

3.ElastiCache:- in Memory DB Used for caching( Redis and Memcached)

4.Neptune:- very nwe DB- Graph DB

5.Amazon Redshift:- Dataware Housing.
......................................................
.DATABASE-.....

A.RDS::---(PAAS)
.RDS-Subnetgroup create(used lats)- Create database-next- productionmysl-next-mysl5.7.23,t2.mediam2cpu4gbram,createreplica in dif AZ-
generalpurpos(ssd),20gb,dbName,usename,pass-next-VPC,subnet group(alred created select),pulically accesable yes now,(realtime no),AZ(no preperance)
-Selectsecg-Databaseoption( name,,,),Maintance,deletion p
rotection,create database-wait for 5-10 mintus,-View DB instance detalis




..at a time writing two DB like -cockrochDB..
..DB Server Down when(a.instance failure,b.AZ-Down,c.Snapshot taken secondary..d.Region down)
..primary and secondary in dfferent Zones deplying.....in RDS-instance action-reboot-selectrebootwithfailover-reboot-
 so one AZ DB Stoped so other side AZ DB becomes Primary



......video 34.40...mysl work bench..
.After DB Server up...
nslookup pastendpoint of DB-geting one public ip- means primari DB Instanc like if failure we check it getting other ip...
.. Mysql work bench- My sql connetion + -hostname(past end point),username-connect-enter pass-
-succusfully made connetion-doubleclickonit-


.SQL dUMP Use to test,(41.32); copythat code-past-excute-

.in RDS-instance action-reboot-selectrebootwithfailover-reboot- so one AZ DB Stoped so other side AZ DB becomes Primary
refres in Sql -here asking password becouse DB reboot and Primary goes Secondary and Secondary goes Primary...
in winoscmd-ipconfig /flushdns, nslookup pastdbendpoint,



..read replica settings-in DB-instancesinstanceactions-create read replica-
-region-vpc-AZ-Public acess yes/no, -instance-multy AZ Depolyment-logs,-create read replica..

.if read replica can do up(production)- goDB IN instances-Instance action- promaote red replica-now red becomes red and  write, and getting new endpoint..

----------------------------------------------------------------------------------------------------------------






















































Labels:

Comments

Post a Comment

Popular posts from this blog

43-Dev-git cmds

43-Dev-git cmds Harsha Veerapalli... .git clone https://github.com/username/repository  git clone https://github.com/NAVEENMJ/1 git status .git init .git status ... getting red cloure  ( a.txt ) .git add file.txt or  (git add .) .git push .git push -u origin master .................. .git branch ---list of branches .git checkout -b branch ...Creaing branches .git merge branch ... presnt in master then merge.. ................................... .git status .git init .git status ... getting red cloure  ( a.txt ) .git add file.txt .git status .... getting green cloure  ( new file: a.txt) [if multipull files in folder use git add .] .git commit -m "COMMIT-1" .. Hear COMMIT-1 Means giving name in genralli changed  name given .git log ......changes ...times.. modifi that file a.txt...... .git status .git add . .git status .git commit -m "COMMIT-2" .cls .git log ..........i want go before comited version....
1 comment
Read more

Azure Devops tutorial

 Azure Devops tutorial: web sit-  Projects - Home (azure.com) AZURE DEVOPS - Organization - Projects Under project- --------- Under Pipelines ---> Pipelines( CI ) -  Under Pipelines --->Releases( CD ) -  ------------------------------------------------------------------------------------------------------------------------- Azure Pipelines:--- Pipeline structure:- A pipeline is one or more stages that describe a CI/CD process. Stages are the major divisions in a pipeline. The stages "Build this app," "Run these tests," and "Deploy to preproduction" are good examples. A stage is one or more jobs, which are units of work assignable to the same machine. You can arrange both stages and jobs into dependency graphs. Examples include "Run this stage before that one" and "This job depends on the output of that job." A job is a linear series of steps. Steps can be tasks, scripts, or references to external templates. This hierarchy is refle...
Post a Comment
Read more

42-AWS-PROJECT-CERTIFATION

42-AWS-PROJECT-CERTIFATION ... GOOGLE....aws 6r..... 1. 2. 3. 4. 5. 6. PRE SALE -POST SALE::: DPR: Detailed PROJECT REPORT. RFI : REQUSTE FOR INF. RFP : REQUEST FOR PROPEROSAL RFQ : REQ     FOR QOOTE POC: PROOF OF CONCEPT HLD: HIGH LEVEL DEGINE  CEO,LEVEL,  HIG LEVEL DIAGROM LLD: LOW LEVEL DEGINE  .. AWS , VPC, ...... BUILD SHETT: FULL DETIALS OF IP NO.. ALL PIN TO PIN UAT: USER ACCEPTANCEY TEST ORT: OPERATION REDINESS TEST SING OFF : REMAINING AMOUT COLLECT CLOSE ARCHITECTURE: AWS CERTIFICATION: Jayandra Patil AWS .............. AWS sysops bluprint
Post a Comment
Read more