7.1.3 RDS for MySQL Flashcards
What Is RDS for MySQL?
- RDS for
MySQL is reliable, scalable, inexpensive, easy to manage, and immediately ready for use,
freeing you to focus on developing your services.
• RDS for MySQL includes a comprehensive performance monitoring system, multi- level security protection measures, and a professional database management platform that allow you to easily set up and scale up databases. On the RDS for MySQL console, you can perform necessary tasks and no programming is required. The console simplifies operations and reduces routine O&M workloads, so you can stay focused on application and service development.
▫ It uses a stable architecture and supports a range of web applications. It is also a cost-effective solution for small and medium enterprises.
▫ A web-based console is available for you to monitor a comprehensive range of performance metrics.
▫ You can flexibly scale resources based on your service requirements but you still pay only for what you use.
What is MySQL?
- MySQL is one of the world’s most popular open-source relational databases. It works
with the Linux, Apache, and PHP (LAMP) stack to provide efficient web solutions.
What are the advantages of RDS for MySQL?
Performance, Security, Efficiency, and Reliability
Performance
- Huawei enhanced MySQL kernel (HWSQL)
provides 3 times higher performance in
high-concurrency scenarios.
Security
RDS for MySQL is certified by China’s Ministry of
Public Security, uses security groups and VPCs to
control access to databases, and supports postincident audit
Efficiency
A web-based management console provides an
easy way to create, scale, monitor, and operate
DB instances.
Reliability
Enhanced semi-synchronous replication prevents
data loss. Automatic failover takes only a few
seconds, ensuring a low recovery time objective
(RTO).
- Performance: RDS offers stable and high-performance database services using servers that have been proven robust by customer success in a wide range of applications. With RDS for MySQL, users can detect slow SQL statements and optimize database performance based on the provided suggestions. Users can access DB instances from the ECSs deployed in the same region as RDS over the intranet. This shortens the response time of applications and reduces the cost incurred by public network traffic.
- Security: RDS uses VPC and network security groups to isolate and secure your DB instances. RDS controls access by using IAM users and security groups; transmission is encrypted using TLS and SSL; and stored data is protected by static encryption and tablespace encryption. When a user deletes a DB instance, all data stored in the instance is deleted. If a DB instance is reachable over a public network, it may be vulnerable to distributed denial-of-service (DDoS) attacks, so RDS is protected by multiple layers of firewalls that can effectively defend against attacks like DDoS and SQL injections.
- Efficiency: RDS is scalable and easy to upgrade. It is billed on a pay-per-use basis and there is no need to purchase any hardware or software. System hosting and O&M are all handled by HUAWEI CLOUD, and since you only pay for the resources actually used, your resource utilization is effectively 100%.
- Reliability: RDS uses a hot standby architecture, so if there is an issue with an instance, failover takes a few seconds. It automatically backs up data every day and uploads the backup data to Object Storage Service (OBS). You can restore data from backups or to any point in time during the backup retention period. Deleted DB instances are moved in the recycle bin. You can rebuild them from the recycle bin within the retention period.
What does RDS provides?
• RDS for MySQL provides:
▫ Elastic scaling
▪ Horizontal scaling: Add or delete read replicas (maximum number of read replicas: 5).
▪ Vertical scaling: Change instance class and add storage (up to 10 TB).
▫ Backup and restoration
▪ Backup: Automated, manual, full, and incremental backups are supported. Backups can be added, deleted, queried, or replicated.
▪ Restoration: Data can be restored to any point in time within the backup retention period, or to a new or an original DB instance. The backup retention period is up to 732 days.
▫ Log management: Slow query logs and error logs can be queried and downloaded.
▫ Parameter configuration: Database administrators (DBAs) can tune database performance by optimizing DB engine parameters based on metrics and logs. DB engine parameters can be added, deleted, modified, queried, reset, compared, and replicated.
What does RDS provides?
• RDS for MySQL provides:
▫ Elastic scaling
▪ Horizontal scaling: Add or delete read replicas (maximum number of read replicas: 5).
▪ Vertical scaling: Change instance class and add storage (up to 10 TB).
▫ Backup and restoration
▪ Backup: Automated, manual, full, and incremental backups are supported. Backups can be added, deleted, queried, or replicated.
▪ Restoration: Data can be restored to any point in time within the backup retention period, or to a new or an original DB instance. The backup retention period is up to 732 days.
▫ Log management: Slow query logs and error logs can be queried and downloaded.
▫ Parameter configuration: Database administrators (DBAs) can tune database performance by optimizing DB engine parameters based on metrics and logs. DB engine parameters can be added, deleted, modified, queried, reset, compared, and replicated.
What are the application scenarios for RDS?
- Users of other cloud vendors
- Fast-growing start-ups
- Internet, e-commerce, and game enterprises
- IoT enterprises
• RDS for MySQL is mainly used in the following scenarios:
▫ Users of public cloud platforms other than HUAWEI CLOUD generally use RDS for MySQL.
▫ Start-ups choose RDS for MySQL in the early stages because they need ways to support fast growth on a limited budget.
▫ MySQL is used widely by Internet, e-commerce, and game enterprises.
When migrating databases to the cloud, these types of enterprises choose
RDS for MySQL.
▫ IoT applications tend to be very large scale and they need to be extremely reliable. RDS for MySQL is the first choice for IoT enterprises because it allows for a large number of concurrent connections and does not require customers to reconstruct their applications.
What is RDS for MySQL Features - Cross-AZ HA?
Functions
Cross-AZ HA supports switchover in seconds.
Up to 5 read replicas can be created for offloading
read traffic.
Standby DB instances are invisible to users. Users
can access DB instances through virtual IP
addresses.
Read replicas cannot exist alone and must come
with single or primary/standby DB instances.
• Cross-AZ HA is an effective disaster recovery mechanism. When your database services have high reliability requirements, you can deploy the primary and standby databases across AZs to achieve AZ-level DR and ensure system reliability.
What is RDS for MySQL Features - Read/Write Splitting?
Functions
A single read/write splitting address is provided,
transparent to applications.
Read-only permissions can be configured for each
node.
Instance health check is performed. If a DB instance
breaks down or the latency exceeds what is supported,
read requests are no longer allocated to the instance.
Advantages
A single read/write splitting address is provided,
and read/write splitting does not require application
reconstruction.
The read weight assigned to a read replica is
configurable.
• Read/write splitting enables read and write requests to be automatically routed through a read/write splitting address. You can enable read/write splitting after read replicas are created. Write requests are automatically routed to the primary DB instance and read requests are routed to read replicas by user-defined weights.
What is RDS for MySQL Feature - Point-In-Time Recovery (PITR)?
Functions
Instance-level restoration in seconds is supported.
Automated backups can be configured to be saved for
up to 732 days (approximately 2 years).
You can restore data to any point in time at least 5
minutes ago and restore the data to a new DB instance
or to the original DB instance.
Advantages
The backup retention period is up to 732 days.
RDS provides free backup space approximately equal
to your purchased storage space.
• You can use backups to restore data to any point in time. Binlog is a binary log used to record MySQL DB table structure changes and table data changes.
What are the RDS for MySQL Features?
- Cross-AZ HA
- Read/Write Splitting
- Point-In-Time Recovery (PITR)
