aws recommends only multiaz for production
in free tier T2 micro database is free but ony 20GB it support but
mutiaz not supported here
so dont select enable free tier rds
production multi mysql
Go to dev/test by default multiaz not selected, if u want still u can do
which mysql version u need 5.2. 76
how much HD u need 20 GB
storage autiscaling
enable
general purpose ssd
monthly costs
[Link]
disable multi az cost reduces
t2 micro takes 1 hour to start databse, so i selected different one
Public access : yes
outside vpc if u wnt to access database, aws will assign public ip
to ur database
if u say no only within vpc its accessible
backup
7days
if I select 0 means auto backup will be disabled
7days means it will be available for 7days
select window , at what time u want to take backup
i say night 12
0.5 hrs
database snapshot will be taken every day 12:00 AM
RDS logs sending to cloud watch repository
db installation taken care by aws,
enable auto minor upgrade means new minor version will be upgraded
select window for that also
deletion protection --> enable it
it takes 10 to 15mins to create database
db.r5 xlarge
try connect to dtabase
connect using db end point
clcik on database--> connectivity
copy end point
from my laptop ---> DB
Laptop--> SG(Inbound: 3306)---> database
Lets say for DB1--> Auto backup enabled, say DB1 corrupted at 7:57
so pto 7:52 whatever data is there it will be available
manual backup --> actions--> take snapshot
install mysql client on ur laptop
to connect to this database
mysql workbench widely used
google --> download
or Toad edge which is 1month free
Toad edge for mysql---> next-->next
after 1month change mail id , again it will work for 1more monthly
Toad-->Go to connections --> manage connections --> hostname(give
dns end point)
connected to db, not OS connected to database
DB1([Link])-- schema means it will contain tables
u can create multiple schemas
schema1--> table1,table2,table3
schema2---> u can use same table name available in schema1 like
table1
schema3
schema also has functions, procedures, views etc apart from tables
create schema:
create database webapp
execute
use webapp, so that u will be in that schema
create table syntax check and create
create table emp(empno int, name varchar2(30), sal int, dept
varchar(8))
like this u can create any number of tables
through application data will be inserted
so but to test I will insert manually using insert command
check
commit will save inside the table
ping datapoint-name
see the ip and stop primary and then ping database name
ip changes to secondry and records will be available in secondary too
Now create read replica by clicking in actions--
read replic can be created any where in different region
u can also enable multi az, but will use standby
retention period disable
disable minor version upgrade
it takes some time
whatever changes in inteliq table will be replicated here
sat another 10 records i inserted, then aws updates same in read
replica also can take snapshots at any time.
create subnet grp
test subnet grp
i add 1a and 1c
if i use test sg ur primary and secondaey will be created in 1a and 1c az
once replica created u can connect but its read only, it has its
own dns name or end point
interview question - not possible to showpractically
i have
db1-- multi-az
primary- [Link]
secondary-[Link]
when i take snapshot of db which database it connects or backup
which db it connects
it always connect to secondary
tto avoid performance issues it always connects to secondary
read multi az definition
==> db software
---> db version
---> db port number
---> db size
--> how many tables ur database have always give rough figure
once replica created insert values into original database
after commit only it will replicated
who did this aws done it
try running update on replica it shoouldnt work
manula snapshot --> action --> take snapshot
seselect snapshot --> actions --> restore snapshot---> database will
be created