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

36.Migration & Transfer

36.Migration & Transfer Migration & Transfer:::...... .............................................. 1.Snowball::(data moving only,like box, 10gb connectivety, 80terrabytes supportes one box,encripted for portable purpouse ,aws snow mobi- like truck 40gb connectivety bunch of snow balles in side truck, we use this services for not having enf bandwidth, snowball edge.study dock) 2.Server Migration Service:: ( virtual servers not for physical servers, free tool,  google search aws sms limits, onprimisess to cloude, to over com use 3rd party tools lik platespin migrate aws,cloud endure,zerto aws )  15.54 .. video harshas desktop..(google - aws sms user guide,planning diffuclt but implementation easy,  google - aws 6r , acess key and security key required,replication,finally creating AMI) 3.Database Migration Service(crating one instnce to take replication from on premisiss to stor in aws RDS,or more given directions,trasfer over vpn) 4.AWS Migration...
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

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