We use our own and third party cookies to improve your experience and our services, identifying your Internet browsing preferences on our website. If you continue to browse, we consider that you accept the use. You can find more information in our cookies policy.

Telefonica Background

 

RDS is essentially an O&M framework for databases of customers in the cloud. RDS requires less efforts and skills from DBAs or system administrators compared to legacy DB scenarios.

RDS provides the following functions:

Professional database instances management

RDS Console provides comprehensive function menus allowing an easy, secure database management and maintenance using browsers, such as:

  • Primary-Standby instances deployment
  • Instances management and access
  • Database Migration
  • Scale-up the compute and storage capacity
  • Database engine parameters configuration
  • Log management

Simple data backup and recovery online

On RDS Console, only a few clicks are necessary to perform a manual snapshot or set an automated backup policy to back up data to a secure and stable object-based storage space. Customers can restoring a DB Instance to a specified time (PITR, Point-In-Time Recovery).

Comprehensive monitoring system

On RDS Console, customers can use the dashboard and instance list to directly view the operating status of created instances. There are more than 20 performance resource monitoring views to observe the current and historical operating status of database instances, as well as error logs and slow query logs.

Database performance optimization

Customers can identify performance bottlenecks and locate faults or exceptions by observing the operating status and log statistics, respectively.

Customers can customize or adjust database parameters.

Performing this operations facilitates the optimal database performance, allowing customers to more easily meet service requirements.

Category

Function

Sub-Function

Description

Supported DB Engine

DB Engine and Version

Supporting MySQL.

5.6.30, 5.6.33, 5.6.34

Supports creating DB Instances running MySQL 5.6.30, or 5.6.33, or 5.6.34.

MySQL 5.6.30, 5.6.33, 5.6.34.

Supporting PostgreSQL

9.5.5

Supports creating DB Instances running PostgreSQL 9.5.5

PostgreSQL 9.5.5

DB Clusters Management

Creating a DB Cluster

Creating a DB Instance without a Standby Replica

Creates a DB Instance without a Standby Replica.

MySQL

PostgreSQL

Creating a DB Instance with a Standby Replica

Creates a DB Instance with a Standby Replica. The Standby Replica is not visible to the application. In the event of an unplanned outage of customer DB Instance, RDS automatically switches to a Standby Replica if customer have enabled HA deployment. The time it takes for the failover to complete depends on the database activity and other conditions at the time the Primary DB Instance became unavailable. Failover times are typically 60-120 seconds. However, large transactions or a lengthy recovery process can increase failover time.

MySQL

PostgreSQL

Creating a Read Replica

RDS uses the DB engines' built-in replication functionality to create a special type of DB Instance called a Read Replica from a source DB Instance. Updates made to the source DB Instance are asynchronously copied to the Read Replica. Customer can reduce the load on the source DB Instance by routing read queries from their applications to the Read Replica. Using Read Replicas, customer can elastically scale out beyond the capacity constraints of a single DB Instance for read-heavy database workloads.

MySQL

PostgreSQL

DB Cluster Information

DB Cluster List

Displays all DB clusters of customer.

MySQL

PostgreSQL

DB Instance List

Displays certain key information of RDS DB instances, such as:

-         DB Instance Name

-         Replication Role

-         DB Engine

-         DB Engine Version

-         Connection Address

-         Status

-         Allowed Operations

MySQL

PostgreSQL

Details of a DB Instance

Displays the details of a DB instance by extending the row in the DB instance list.

MySQL

PostgreSQL

Rebooting a DB Cluster

--

Reboots a DB cluster, including all Primary\Standby Replica\Read Replica DB instances in it.

MySQL

PostgreSQL

Deleting a DB Cluster

--

Deletes a DB cluster, including all Primary\Standby Replica\Read Replica DB instances in it. The last DB snapshot will be retained.

MySQL

PostgreSQL

DB Instance Management

Creating a DB Instance

Wizard of creating a DB Instance

Instructs customer on creating a RDS DB instance.

MySQL

PostgreSQL

Selecting a Region

Selects the Region where the DB instance will be deployed.

MySQL

PostgreSQL

Selecting a DB Engine

Selects the DB Engine for the DB instance. Currently, RDS supports MySQL and PostgreSQL.

MySQL

PostgreSQL

Selecting a DB Engine Version

Selects the DB Engine Version for the DB instance.

MySQL

PostgreSQL

Selecting a DB Instance Class

Selects the DB Instance Class for the DB instance.

MySQL

PostgreSQL

Selecting a Storage Type

Selects the Storage Type for the DB instance.

MySQL

PostgreSQL

Provision the Allocated Storage

Provisions the Allocated Storage for the DB instance.

MySQL

PostgreSQL

Selecting an Availability Zone (AZ)

Selects the AZ where the DB instance will be deployed.

MySQL

PostgreSQL

Selecting a Virtual Private Cloud (VPC)

Selects the VPC where the DB instance will be deployed.

MySQL

PostgreSQL

Selecting a VPC Subnet

Selects a Subnet Group of the selected VPC for the DB instance.

MySQL

PostgreSQL

Selecting a VPC Security Group

Selects a Security Group of the selected VPC for the DB instance.

MySQL

PostgreSQL

Setting the Database Master User

Sets the Database Master Password for the DB instance.

MySQL

PostgreSQL

Setting the Backup Policy

Sets the Backup Policy for the DB instance.

MySQL

PostgreSQL

DB Instance List

Displaying Instance Information

Displays certain key information about a RDS DB instance, such as:

-         DB Instance Name

-         DB Engine

-         DB Engine Version

-         Connection Address

-         Creation Time

-         Status

-         Allowed Operations

MySQL

PostgreSQL

Sorting DB instances by Fields

Sorts DB Instances by DB Instance Name or DB Engine.

MySQL

PostgreSQL

Updating the DB Instance List

Manually updates the DB Instance list. Currently, RDS does NOT support automatic updating.

MySQL

PostgreSQL

Detail Information of a DB Instance

--

Displays the detail information of a DB Instance.

MySQL

PostgreSQL

Rebooting a DB Instance

--

Reboots a DB instance to restore it after modifying DB Engine parameters or when the DB instance becomes abnormal.

MySQL

PostgreSQL

Modifying a DB Instance

Modifying the Allocated Storage of a DB Instance

   Supports to scale up the Storage Capacity of the DB Instance.

   RDS also supports to scale up the Storage Capacity of the Read Replica. In order for replication to operate effectively, each Read Replica should have as much storage resources as the source DB Instance. If customer scale the source DB Instance, they should also scale the Read Replicas.

No downtime. Performance may be degraded during the change.

MySQL

PostgreSQL

Modifying the DB Instance Class of a DB Instance

   Supports to scale the compute resources of the DB Instance

   RDS also supports to scale the compute resources of the Read Replica. In order for replication to operate effectively, each Read Replica should have as much compute resources as the source DB Instance. If customer scale the source DB Instance, they should also scale the Read Replicas.

   An outage occurs during this change.

MySQL

PostgreSQL

Deleting a DB Instance

--

Deletes a DB instance.

MySQL

PostgreSQL

DB Instance Connection

Connecting to a DB Instance

Connecting to a DB Instance with Intranet IP

Currently, RDS only supports connecting to the DB Instance from ECS Instance in the same VPC.

MySQL

PostgreSQL

Connecting to a DB Instance with default port

Currently, RDS only supports connecting to the default port of the DB Instance, and does NOT support modifying.

MySQL

PostgreSQL

Database Migration

Migrating On-Premises Database to a RDS DB instance

--

Currently, RDS only provides the importing guide on a page of RDS Console, including the principle view and detailed command reference.

MySQL

PostgreSQL

Backing Up and Restoring

Automated Backups

--

The MySQL DB instance uses the innobackupex tool to back up data online and ensure data consistency.

The PostgreSQL DB Instance uses the pg_backup tool to back up data online and ensure data consistency.

  • Customers can set the Backup Retention Period and the Backup Window when creating a DB instance. Setting the Backup Retention Period parameter to a positive number enables backups. Setting this parameter to 0 disables Automated Backups, and the existing Automated Backups will be deleted by RDS automatically.
  • Backups created during the Backup Window are retained for a customer-configurable number of days (the Backup Retention Period, from 0 to 35).
  • Currently, RDS supports a maximum of 35 days Automated Backups for each DB cluster.

MySQL

PostgreSQL

DB Snapshots

--

The MySQL DB instance uses the innobackupex tool to full backup data online and ensure data consistency.

The PostgreSQL DB Instance uses the pg_backup tool to full backup data online and ensure data consistency.

  • Currently, RDS supports a maximum of 50 DB Snapshots for each DB cluster.
  • DB Snapshots will be performed immediately.

MySQL

PostgreSQL

Restoring From Automated Backups or DB Snapshots(the current existing DB instance will be restored)

--

Restores databases from Automated Backups or any customer-initiated DB Snapshots.

Notes:

1. The current existing DB instance will be restored.

2. The feature “Restore to Current Instance” does not apply to PostgreSQL.

MySQL

 

Restoring a DB Instance to a Specified Time (PITR, Point-In-Time Recovery)

--

Restores databases from backups prior to the target time for recovery, then uses incremental backups and redo to roll the database forward to the target time.

Notes: A new DB instance will be created.

MySQL

PostgreSQL

Restoring From Automated Backups or DB Snapshots(a new DB instance will be created)

--

Customer can restores a new DB Instance from Automated Backups or any customer-initiated DB Snapshots.

Notes: A new DB instance will be created.

MySQL

PostgreSQL

DB Snapshots Management

--

RDS supports customer to Create, View, Restore, Copy and Delete the DB snapshots.

MySQL

PostgreSQL

DB Engine Parameters Group

DB Engine Parameters Configuration

--

RDS supports customer to View, Edit, and Configures Parameters of DB Engine.

MySQL

PostgreSQL

Reset DB Engine Parameters Defaults

--

Resets all parameters to their defaults if the modification causes databases abnormal operation.

MySQL

PostgreSQL

Monitoring

Selection of Monitored Metrics on CES Console

OS Metrics of DB Instance

Such as:

-         CPU Usage

-         Memory Usage

-         IOPS

-         Network Input Throughput

-         NetWork output Throughput

-         Disk Usage

MySQL

PostgreSQL

MySQL Metrics

Such as:

-         DB Connections

-         QPS/TPS

-         COMDML

-         ROWDML

-         Temporary Table

InnoDB metrics:

-         InnoDB Buffer Pool

-         InnoDB Read/Write Throughput

-         InnoDB Read/Write Frequency

-         InnoDB Log

MyISAM metrics:

-         MyISAM Key Buffer

-         MyISAM Read/Write Frequency

-          

MySQL

 

PostgreSQL Metrics

Such as:

-         Transaction logs usage

-         Replication slot usage

-         Database connections

-         Maximum used transaction ids

-         Transaction logs generations

-         Oldest replication slot lag

-         Replication lag

PostgreSQL

Switching between Monitoring Windows on CES Console

--

Supports multiple Monitoring Windows, such as:

-         Last 3 hours

-         Last 12 hours

-         Last 24 hours

-         Last 7 days

-         Last 30 days

MySQL

PostgreSQL

Database Log Management

Querying the Error Logs of Database

Supports queries based on start time and end time, helping customers troubleshoot faults that occur during database operating.

MySQL

 

Querying Slow SQL Logs

Supports queries based on start and end time, helping customers identify the causes for SQL statements becoming slower.

MySQL

 

Querying

Recent Logs

Show log files of PostgreSQL.

Log files are sorted by file names by default and can be displayed on multiple pages. A number of 10 logs are displayed on each page by default. You can also set the number of logs displayed on a page to 20 or 50.

Customers can enter a log file name in the search box in the upper-right corner to query

Information of the log file.

PostgreSQL

Open API

--

--

Provides API of DB instance management for customers to secondary development.

MySQL

PostgreSQL