Amazon RDS Database Engines
1.
SQL Server:
ü SQL Server is a Relational Database developed by Microsoft.
ü SQL Server is easy to set up, operate, and scale the SQL Server
deployments in the cloud.
ü With the help of Amazon RDS, you can add multiple editions of SQL
Server such as 2008 R2, 2012, 2014, 2016, 2017 in minutes with cost-effective
and re-sizable compute capacity.
ü It frees you from managing the time-consuming database
administration tasks such as provisioning, backups, software patching,
monitoring, and hardware scaling.
ü It supports "License-included" licensing model. In this
model, you do not have to purchase the Microsoft SQL Server licenses
separately.
ü Amazon RDS provides high availability of MS SQL Server using
multi-availability zone capability, and this reduces the risk to set and
maintain the database manually.
ü It manages the provisioning of the database, version upgrades of
MS SQL Server and disk storage management.
2. Oracle:
ü It is a very popular relational database.
ü It is used by big enterprises but can be used by other
businesses as well.
ü Oracle is a Relational Database Management developed by
Oracle.
ü It is easy to set up, operate, and scale Oracle
deployment in the cloud.
ü You can deploy multiple editions of Oracle in minutes
with cost-effective and re-sizable hardware capacity.
ü Amazon RDS frees you from managing the time-consuming
database administration tasks. You need to focus on the development part.
ü You can run Oracle under two different licensing models,
i.e., "License Included" and "Bring-Your-Own-License".
3.
MySQL:
ü It is an open source relational database.
ü It is free to download and use.
ü It is very popular in the developer community.
ü It is easy to set up, operate, and scale MySQL
deployments in aws.
ü You can deploy MySQL Servers in minutes with
cost-effective and resizable hardware capacity.
ü It frees you from managing the time-consuming database
administrative tasks such as backups, monitoring, scaling and replication.
ü An Amazon RDS supports MySQL versions such as 5.5, 5.6,
5.7, 5.8, and 8.0 which means that the code, applications, and tools that you
are using today can also be used with Amazon RDS.
4.
PostgreSQL:
ü It is an open source Relational database for enterprise
developers and start-ups.
ü It is easy to set up, operate, and scale PostgreSQL
deployments in the cloud.
ü With Amazon RDS, you can scale PostreSQL deployments in
aws cloud in minutes with cost-effective and resizable hardware capacity.
ü It manages time-consuming administrative tasks such as
PostgreSQL software installation, storage management, replication for high
availability, and backups for disaster recovery.
ü The code, applications, and tools that we use today can
also be used with the Amazon RDS.
ü With few clicks in AWS Management Console, you can deploy
PostgreSQL database with automatically configured database parameters for on
optimal performance.
5.
Aurora:
ü It is a relational database, and closed source database
engine.
ü It is compatible with MySQL and delivers five times
throughput of MySQL on the same hardware.
ü It is also compatible with PostgreSQL and delivers three
times throughput of PostgreSQL on the same hardware.
ü Amazon RDS with Aurora manages the time-consuming
administrative tasks such as software installation, patching, and backups.
ü The main features of Aurora are fault-tolerant,
distributed, a self-healing storage system that auto-scales upto 64 TB per
database instance.
ü It provides high-performance, availability, point-in-time
recovery, continuous backed up to S3, and replication across three availability
zones.
5.
MariaDB:
ü MariaDB is an open source relational database developed
by the developers of MySQL.
ü It is easy to set up, operate, and scale MariaDB
deployments in the aws cloud.
ü With Amazon RDS, you can deploy MariaDB databases in
minutes with cost-effective and resizable hardware capacity.
ü It frees you from managing the time-consuming
administrative tasks such as software installation, patching, monitoring,
scaling, and backups.
ü Amazon RDS supports MariaDB versions such as 10.0, 10.1,
10.2, and 10.3 means that the code, applications, and tools that you are using
today can also be used with the Amazon RDS.
A DB
instance is an isolated database environment running in the
cloud. It is the basic building block of Amazon RDS. A DB instance can contain
multiple user-created databases, and can be accessed using the same client
tools and applications you might use to access a standalone database instance.
DB instances are simple to create and modify with the AWS command line tools,
Amazon RDS API operations, or the AWS Management Console.
v Security in Amazon RDS:
Cloud security at AWS is the highest priority.
As an AWS customer, you benefit from a data centre and network architecture
that are built to meet the requirements of the most security-sensitive
organizations. Security is a shared responsibility between AWS and you.
ü Security of the cloud – AWS is responsible for protecting the infrastructure that runs AWS services in the AWS Cloud. AWS also provides you with services that you can use securely.
ü Security in the cloud – Your responsibility is determined by the AWS service that you use. You are also responsible for other factors including the sensitivity of your data, your organization's requirements, and applicable laws and regulations.
v Parameter Group:
Database parameters specify how the
database is configured. For example, database parameters can specify the amount
of resources, such as memory, to allocate to a database.
A parameter group is a collection of engine
configuration values that you set for your RDS database instance. It contains
the mapping of what you want each of these over 400 unique parameters to be set
to. Amazon RDS defines parameter groups with default settings. You can also
define your own parameter groups with customized settings. Some DB engines offer
additional features that you can add to your database as options in an option
group. For information about option groups, see Working with option groups.
0 Comments