Huawei Cloud Stack 8.3.1 Solution Description 04

DB Instance Description

DB Instance Description

DB Instance Types

The smallest management unit of RDS is the DB instance. A DB instance is an isolated database environment on the cloud. Each DB instance can contain multiple user-created databases, and you can access a DB instance using the same tools and applications that you use with a stand-alone DB instance. You can easily create or modify DB instances using the management console or HTTPS-compliant application programming interfaces (APIs). RDS does not have limits on the number of running DB instances. Each DB instance has a DB instance identifier.

DB instances are classified into the following types.

Table 15-4 DB instance types

DB Instance Type

Description

Notes

Single

A single-node architecture is more cost-effective than a primary/standby DB pair.

If a fault occurs on a single instance, the instance cannot recover in a timely manner.

Primary/Standby

An HA architecture. In a primary/standby pair, each instance has the same instance class.

The primary and standby instances can be deployed in different AZs.

  • When a primary instance is being created, a standby instance is provisioned synchronously to provide data redundancy. The standby instance is invisible to you after being created.
  • If a failover occurs due to a primary instance failure, your database client will be disconnected briefly. You need to reconnect the client to the instance.
  • If the primary and standby instances are deployed in the same AZ, both of them will be unavailable when an AZ-level fault occurs.

Read replica

A single-node architecture (without a standby node)

  • A read replica is a single-node instance. If the physical server hosting a read replica is faulty or database replication between the read replica and its primary instance is abnormal, it takes a long time to rebuild and restore the read replica (depending on the data volume).

You can use RDS to create and manage DB instances running various DB engines.

For details about differences and function comparison between different instance types, see DB Instance Introduction and Function Comparison.

DB Instance Storage Types

The database system is generally an important part of an IT system and has high requirements on storage I/O performance. You can select a storage type based on service demands. You cannot change the storage type after the DB instance is created.

Table 15-5 Storage type

Storage Type

Description

Ultra-high I/O

Uses cloud SSDs to store data. Storage is decoupled from compute. The maximum throughput is 350 MB/s.

DB Engines and Versions

Table 15-6 lists the DB engines and versions supported by RDS.

For new applications, you are advised to use the latest major version of the DB engine, for example, MySQL 5.7. When you create a DB instance, you can select a major DB engine version only (such as MySQL 5.7). The system will automatically select an appropriate minor version (such as 5.7.31) for you. After the DB instance is created, you can view the minor version in the DB Engine Version column on the Instances page. The DB engine and version vary according to site requirements.

Table 15-6 DB engines and versions

DB Engine

Single

Primary/Standby

MySQL

  • 5.7
  • 5.6
  • 5.7
  • 5.6

DB Instance Statuses

DB Instance Statuses

The status of a DB instance indicates the health of the DB instance. You can use the management console or API to view the status of a DB instance.

Table 15-7 DB instance statuses

Status

Description

Available

A DB instance is available.

Abnormal

A DB instance is abnormal.

Creating

A DB instance is being created.

Creation failed

A DB instance has failed to be created.

Switchover in progress

A standby DB instance is being switched over to the primary DB instance.

Changing type to primary/standby

A single DB instance is being changed to primary/standby DB instances.

Rebooting

A DB instance is being rebooted.

Changing port

A DB instance port is being changed.

Changing instance class

The CPU or memory of a DB instance is being modified.

Scaling up

Storage space of a DB instance is being scaled up.

Backing up

A DB instance is being backed up.

Restoring

A DB instance is in the process of being restored from a backup.

Restore failed

A DB instance fails to be restored.

Storage full

Storage space of a DB instance is full. Data cannot be written to databases.

Deleted

A DB instance has been deleted and will not be displayed in the instance list.

Migrating standby DB instance

A standby RDS for MySQL instance is being migrated to another AZ in the same region.

Promoting to primary

A read replica is being promoted to a primary DB instance.

Parameter change. Pending reboot

A modification to a database parameter is waiting for an instance reboot before it can take effect.

Stopping

A DB instance is being stopped.

Stopped

A DB instance has been stopped. It can be stopped for up to seven days. You can manually restart it or it will be automatically restarted after seven days.

Starting

A stopped DB instance is being started.

Translation
Favorite
Download
Update Date:2025-08-11
Document ID:EDOC1100372275
Views:73235
Downloads:513
Average rating:0.0Points

Digital Signature File

digtal sigature tool