Please enable JavaScript.
Coggle requires JavaScript to display documents.
RDS (Pricing, Components, Security, Monitoring & Notification, Multi A…
RDS
Pricing
Backup storage
free for active DB instance
RDS provides backup storage up to 100% of the provisioned database storage at no additional charge
increase backup retention or taking additional -> increase backup storage
Running Time
min 10 mins
billed in one-seconds increments
Storage
billed per GB per month
bill pro-rated, if scaled within capacity
Provisioned IOPS per month
for EBS volume
one-second, 10 min
for SSD
provisioned IOPS rate
Instance Class
e.g micro, etc
I/O requests per month
Total number of storage I/O requests made in a billing cycle.
Data transfer
internet data transfer out of DB
Reserved Instances
plus to regular pricing
Components
DB instance
is a basic building block di RDS
isolated db environment in the cloud
each instance has a DB engine
has a class
computation
memory
types
Magnetic
General Purpose (SSD)
Provisioned IOPS (SSD)
accessed from
AWS CLI
RDS APIs
AWS Management Console
DB instance identifier
customer-supplied name
unique in AWS region
host
multiple user-created databases
a single Oracle database with multiple schemas.
DB parameter Groups
contains engine configuration values
applied to one or more
DB instances
like
max_connections
force_ssl
autocommit
supported type
default parameter group
no edited
custom parameter group
override
static
NOT applied immediately and require a manual reboot.
dynamic
changes are applied immediately
DB option Groups
dependens on engine
tools
Oracle Application Express
Regions and Availability Zones
Multi AZ deployment
provisions and maintains a synchronous standby replica of the DB instance in a different AZ
Provides
data redundancy, failover support, eliminates I/O freezes, and minimizes latency spikes during system backups.
Security Groups
controls access to DB instance
Security
encryption
transit
SSL coonections
at rest
instances
snapshots
Oracle DB instances
network encryption
transparent data encryption
authentication
Password
Kerberos
IAM database authentication
network access control
VPC hosted
Security Groups
what IP address
EC2 instances
IAM policies
who can managed RDS resources
Monitoring & Notification
integrates
CloudWatch
with its alarms over single metric
sns
SNS
RDS event
RDS Performance Insigths
database performance tuning
monitoring feature
RDS Recommandations
automated Recomandations for database resources
Multi A-Z
DB instance deployment
one standby db instance
no serve read traffic
failover support
DB cluster deployment
two standby DB instances
failover support
serve read traffic
Read Replicas
increased
database availability
scalability
elastic scaling
read heavy database workloads
Backups, Snapshot
Automated backups
default for a new DB instance
recovery of db in any point in time
Manual backups = Snapshot
backup of the DB instance to a known state
restore to thet specific state at any time