Amazon Web Service
Amazon RDS
Amazon provides Database as a Service which includes different types databases. One of the web services is known as RDS. RDS is relational database service which highly scalable and easy to setup. It is a managed service and it reduces the burden of the database administrator. Why you want a managed database service? HEre is list some of the benefits of RDS :
You will get a number of options for CPU, Memory, storage, and IOPS. You can scale them independently anytime.
Managing backups and patching is a pain for DBA. RDS will do this for you. RDS can also handle failure detection.
In order to provide managed service experience, you will not get shell access to DB instances and it also restricts access to some procedures and advance tables.
RDS will automatically take backups of the database and you can take manual backups snapshots. Restoring database using these snapshots is reliable and efficient.
RDS provides a secondary synchronous instance that you can use in failover. Read replica is another way for getting high availability. You can use read replica for MySQL, MariaDB, and PostgreSQL. Read replica will save you some bucks but, you need to configure in a way that it can be used during failover.
RDS is compatible with most of SQL database. You can use RDS with MySQL MariaDB, PostgreSQL, Oracle, Microsoft SQL Server, and MySQL-compatible Amazon Aurora DB engine.
For better security of your database, you can use IAM policy to define who can have access to database. You can also place your database in private subnet of your VPC.
How you are going to access DB instance? Amazon provides three ways to access the DB instances.
Amazon RDS Console
RDS console is one of the easiest way of accessing the database. Amazon RDS provides a simpler way of the simple web interface. You do not need to be a regular developer, using RDS console you can do every task you need to perform according to your need.
Command Line Interface
CLI command is one of the best ways to access AWS services. You will get almost all features as APIs. You can access your database with CLI commands and you will get almost all functionality of Amazon RDS API.
Programmatic Interface
One of the best way of accessing AWS services for developers. You will get all functionality of the AWS services. Amazon RDS can also be accessed through API's. AWS SDK supports most of the common programming languages.
Next
Must Read Article
How To Launch EC2 Machine
In this article we are going to learn how to launch a EC2 instance. For this you need to have AWS account.
How to install WordPress on ec2 machine
Before you start installing WordPress on ec2 machine. You must log in into the machine.
How to assign Static IP to ec2 Instance
In this tutorial we are going assign static IP to ec2 Instance.
How to Stop ec2 instance
In this tutorial we are going to stop ec2 instance.
How to Terminate ec2 instance
In this tutorial we are going to terminate ec2 instance.
How to Access ec2 instance using putty
In this tutorial we will learn how to convert .pem file into .ppk file. After converting private key we will login into ec2 machine using putty.
How to allocate Static IP address
In this tutorial we are going to allocate a static IP.
How to Copy AMI to another Region
In this tutorial we are going a AMI to another region.
How to copy snapshot from one region to another
In this tutorial we are going copy snapshot from one region to another.
How to create a volume from Snapshot
In this tutorial we are going to create a volume from existing snapshot.
How to create Image from EC2 instance
In this tutorial we are going create an Image from a running ec2 instance.
How to Deregister AMI
In this tutorial we are delete an existing AMI.
How to disassociate Static IP form ec2 instance
In this tutorial we are going to disassociate static IP form ec2 instance.
How to Launch a EC2 machie using your AMI
In this article we are going launch a ec2 machine using you AMI.
How to modify your Image permissione
In this tutorial we are going to modify image permissione.
How To Modify your Snapshot Permission
In this tutorial we are going to make snapshot permission public. So that any one can use this snapshot.
How to reboot ec2 instance
In this tutorial we are going to Rebbot ec2 instance.
