This topic describes the terms that are used in ApsaraDB RDS.
AliSQL is an independent MySQL branch that is developed by Alibaba Cloud. AliSQL provides all features of the MySQL Community Edition and some similar features that you can find in the MySQL Enterprise Edition. These similar features include enterprise-grade backup and restoration, thread pools, and parallel queries. In addition, AliSQL provides Oracle-compatible features, such as the Sequence engine. ApsaraDB RDS for MySQL with AliSQL provides all features of MySQL and a wide range of advanced features that are developed by Alibaba Cloud. These advanced features include enterprise-grade security, backup and restoration, monitoring, performance optimization, and read-only instances.
For more information, see Overview of AliSQL features.
AliPG is a unified database engine that is developed by Alibaba Cloud. Alibaba Cloud provides the following two PostgreSQL-compatible database services that can run AliPG: ApsaraDB RDS and ApsaraDB for MyBase. AliPG was released for commercial use in 2015. Since then, AliPG continues to help Alibaba Group users and Alibaba Cloud customers run a large volume of workloads at stable performance. AliPG supports the following major PostgreSQL versions: PostgreSQL 9.4, PostgreSQL 10, PostgreSQL 11, PostgreSQL 12, and PostgreSQL 13.
For more information, see AliPG benefits.
- ApsaraDB RDS
ApsaraDB Relational Database Service (RDS) is a stable, reliable, and scalable online database service that is built on top of the Apsara Distributed File System and high-performance SSDs of Alibaba Cloud. ApsaraDB RDS supports the MySQL, SQL Server, PostgreSQL, and MariaDB TX database engines. ApsaraDB RDS provides a full suite of solutions for disaster recovery, backup, restoration, monitoring, and migration to facilitate database O&M.
For more information, see What is ApsaraDB RDS?
- ApsaraDB for Redis
ApsaraDB for Redis is a database service that provides a hybrid of memory and hard disks to ensure data persistence. You can use ECS, ApsaraDB RDS, and ApsaraDB for Redis together to handle a large number of read requests within a short period of time.
For more information, see What is ApsaraDB for Redis?
- ApsaraDB for MongoDB
ApsaraDB for MongoDB is a stable, reliable, and scalable database service that is fully compatible with the MongoDB protocol. You can store structured data in ApsaraDB RDS and unstructured data in ApsaraDB for MongoDB to meet various storage requirements.
For more information, see What is ApsaraDB for MongoDB?
- asynchronous mode
After an add, delete, or modify operation originated from an application is complete on a primary RDS instance, the primary RDS instance immediately responds to the application. At the same time, the primary RDS instance asynchronously replicates the added, deleted, or modified data to the secondary RDS instances that are attached to the primary RDS instance. In asynchronous mode, the workloads on the primary RDS instance run as expected even if the secondary RDS instances are unavailable. However, if the primary RDS instance is unavailable, errors may occur due to data inconsistencies between the primary RDS instance and the secondary RDS instances.
- ApsaraDB for MyBase
ApsaraDB for MyBase is developed by Alibaba Cloud to provide custom and optimized database services for enterprises. An ApsaraDB for MyBase dedicated cluster consists of multiple hosts. These hosts can be ECS instances of the ecs.i2.xlarge instance type or ECS Bare Metal instances. ApsaraDB for MyBase can meet more of your business requirements than fully managed database solutions.
For more information, see What is ApsaraDB MyBase?
For data integrity and reliability purposes, automatic backups must be performed on an RDS instance on a regular basis to ensure that the data of the RDS instance can be restored.
For more information, see Overview.
- Basic Edition
The RDS Basic Edition is cost-effective. In this edition, your database system consists of only one primary RDS instance, and computing is separated from storage.
For more information, see RDS Basic Edition.
- CPU utilization
CPU utilization indicates the resources that the programs and processes occupy in a database system over a specific period of time.
Connections indicate the number of connections that are established over TCP between a database client and an RDS instance. If a connection pool is enabled on the database client, the connections between the database client and the RDS instance are long-lived. Unlike short-lived connections, long-lived connections are not actively closed after the read and write requests over the connections are processed.
For more information, see Set the connection pool type of an ApsaraDB RDS for MySQL instance.
- character set
A character set is a collection of letters, symbols, and rules that are used to encode the letters and symbols in a database.
- classic network
RDS instances in the classic network cannot be isolated by using network settings. You can block unauthorized access to the RDS instances in the classic network only by configuring IP address whitelists or security groups.
- Cluster Edition
The RDS Cluster Edition is developed based on the native SQL Server technology AlwaysOn and is supported only for SQL Server 2017. In this edition, computing is separated from storage, and you can create read-only RDS instances to implement read/write splitting. After you create read-only RDS instances, you can apply for a read-only routing endpoint, which is used to implement read/write splitting. By default, an independent internal endpoint is assigned to each read-only RDS instance. This internal endpoint is used to connect only to the read-only RDS instance.
For more information, see Cluster Edition.
Database Autonomy Service (DAS) is a cloud service that uses machine learning and expert experience to automate perception, healing, optimization, O&M, and security for databases. DAS simplifies database management and prevents service failures that may be caused by manual operations. This way, DAS helps ensure that your database service runs in a stable, secure, and efficient manner.
For more information, see DAS overview.
Database Backup (DBS) is a cost-effective backup service that helps protect the data in RDS instances.
For more information, see What is DBS?
Data Management (DMS) is a GUI-based tool that is developed by Alibaba Cloud. DMS supports data management, schema management, server management, access control, business intelligence (BI) charting, data trend analysis, data tracking, and performance monitoring and optimization. DMS can be used to manage relational databases, such as MySQL, SQL Server, PostgreSQL, MongoDB, and Redis databases. DMS can also be used to manage NoSQL databases and Linux-based database servers.
For more information, see What is DMS?.
Data Transmission Service (DTS) is a data streaming service that is developed by Alibaba Cloud. DTS can be used to migrate, subscribe to, and synchronize data between relational databases, NoSQL databases, and online analytical processing (OLAP) databases over stable, secure transmission links.
For more information, see What is DTS?
- dedicated RDS instance
A dedicated RDS instance is an instance that exclusively occupies the allocated CPU and memory resources. The performance of a dedicated RDS instance remains stable and is not affected by the other instances that are deployed on the same physical host. The dedicated host instance family is the top-level configuration of the dedicated instance family. A dedicated host RDS instance occupies all resources on the physical host on which the dedicated host instance is deployed.
For more information, see ApsaraDB RDS instance families.
A database is a logical unit of an RDS instance. It is a set of data that is stored with minimal redundancy in an organized manner. The data in databases is independent of the data on applications. The data can be shared among multiple authorized users. A database can be considered a data warehouse that is used to store data. You can create multiple databases on an RDS instance. Each database must have a unique name in the RDS instance on which the database is created.
- database proxy
A dedicated proxy resides between a database system and an application. The dedicated proxy receives requests from the application and routes the requests to the primary and read-only RDS instances in the database system. The dedicated proxy is easy to use and maintain, and provides high availability and high performance. The dedicated proxy also provides advanced features, such as automatic read/write splitting, transaction splitting, and connection pools.
For more information, see What are database proxies?.
When you run a transaction to modify specific resources, the resources are locked to prevent other concurrent transactions from modifying the resources and ensure data consistency. This lock is known as a deadlock. In most cases, deadlocks are triggered if multiple transactions are run to modify the same resources.
- disaster recovery RDS instance
If you use ApsaraDB RDS for common business scenarios that require data to be highly reliable or for financial business scenarios that require compliance with specific regulations, you can create a disaster recovery RDS instance for your database system. ApsaraDB RDS supports disaster recovery RDS instances only for the MySQL database engine. The disaster recovery RDS instance synchronizes data from the primary RDS instance in real time by using DTS. The primary RDS instance and the disaster recovery RDS instance are deployed in high-availability architectures. If the primary RDS instance and its secondary RDS instances become inaccessible due to unexpected exceptions such as natural disasters, your database system performs a failover to the disaster recovery RDS instance. In this case, the disaster recovery RDS instance becomes the primary RDS instance. After you update the endpoint configuration on the connected application, the application can immediately connect to the new primary RDS instance.
For more information, see Create a disaster recovery ApsaraDB RDS for MySQL instance.
ECS is a cost-effective, easy-to-use, easy-to-maintain, secure, reliable, and scalable service that is provided by Alibaba Cloud. Each ECS instance runs as a virtual machine on the cloud and provides flexible, diversified configurations. You can run various workloads, such as websites, blogs, games, and applications, on ECS instances. The use of ECS with ApsaraDB RDS is a typical service access architecture.
For more information, see What is ECS?
- ESSDEnhanced SSDs (ESSDs) are a new type of SSD that is developed by Alibaba Cloud based on the next-generation distributed block storage architecture. ESSDs are integrated with 25 Gigabit Ethernet and remote direct memory access (RDMA) technologies. ESSDs can reduce one-way latencies and process up to 1 million read and write requests at random per second. ESSDs come in three performance levels (PLs) on the ApsaraDB RDS buy page:
- ESSD PL1: This refers to an ESSD of PL1.
- ESSD PL2: An ESSD of PL2 delivers IOPS and throughput that are about two times higher than the IOPS and throughput that are delivered by an ESSD of PL1.
- ESSD PL3: An ESSD of PL3 delivers IOPS that is up to 20 times higher than the IOPS that is delivered by an ESSD of PL1. An ESSD of PL3 also delivers throughput that is up to 11 times higher than the throughput that is delivered by an ESSD of PL1. ESSDs of PL3 are suitable for business scenarios in which highly concurrent requests must be processed with high I/O performance and at low read and write latencies.
For more information, see Storage types.
- Enterprise Edition
The RDS Enterprise Edition is suitable for enterprises. In this edition, your database system consists of one primary RDS instance and two secondary RDS instances. Data is replicated from the primary RDS instance to the secondary RDS instances in synchronous mode to ensure data consistency and finance-grade reliability.
For more information, see Enterprise Edition.
- emergency RDS instance
DBS provides an emergency recovery feature. This feature allows DBS to obtain the data backup files of an RDS instance and generate snapshots. Then, DBS can produce an emergency RDS instance in a few dozen seconds. The emergency RDS instance is also known as a DBS sandbox instance.
For more information, see Create a sandbox instance for the emergency disaster recovery of an ApsaraDB RDS for MySQL database.
Ffull data migration
You can migrate the data of all objects from a source RDS instance to a destination RDS instance by using DTS. This is called a full data migration operation.
In the RDS High-availability Edition, a secondary RDS instance is provided as a standby for the primary RDS instance. Data is replicated from the primary RDS instance to the secondary RDS instance in semi-synchronous mode. If the primary RDS instance becomes faulty, your database system performs a failover to the secondary RDS instance.
For more information, see High-availability Edition.
I/O is short for input and output. I/O indicates the read and write operations that are performed on a disk.
Input/output operations per second (IOPS) indicate the number of read and write operations that are performed to read and write 4 KB of data on a block storage device per second.
- IP address whitelist
An IP address whitelist of an RDS instance consists of the IP addresses and CIDR blocks that are granted access to the RDS instance. The IP address whitelists that you configure for an RDS instance are used to control access to the RDS instance. We recommend that you update the configured IP address whitelists on a regular basis.
For more information, see Use a database client or the CLI to connect to an ApsaraDB RDS for MySQL instance.
- incremental data migration
After all data of a source RDS instance is migrated to a destination RDS instance, you can synchronize the incremental data of the source RDS instance to the destination RDS instance by using DTS. This is called an incremental data migration operation. Incremental data migration allows you to migrate data between RDS instances without downtime.
Java Database Connectivity (JDBC) is a Java-based API that is used to connect to an RDS instance from a database client.
- Logical I/O
Logical I/O indicates the read and write requests that are sent from an application to a file system.
- local SSD
Local SSDs are deployed on the same physical host as the RDS instance to which the local SSDs are attached. You can store data on local SSDs to reduce I/O latencies.
For more information, see Storage types.
MaxCompute, previously known as ODPS, is a fully managed computing platform that can process terabytes or petabytes of data at high speeds. MaxCompute supports comprehensive data import solutions and various classic distributed computing models. These solutions and models are used to import large amounts of data from RDS instances into MaxCompute. You can process the data by using MaxCompute.
For more information, see What is MaxCompute?
- Microsoft AD
Active Directory (AD) is a directory service that is developed by Microsoft for various Microsoft services, such as Windows Standard Server, Windows Enterprise Server, and Microsoft SQL Server. A directory is a hierarchical structure that stores information about the objects on the same LAN. For example, AD stores information about user accounts, such as names, passwords, and phone numbers, and allows other authorized users on the same LAN to access this information.
AD is an important part of the Windows ecosystem. A large number of large-sized enterprises use the domain control mechanism that is provided in the Windows ecosystem to plan and implement centralized access management in their business scenarios.
Object Storage Service (OSS) is a secure, cost-effective, and high-durability cloud storage service that is provided by Alibaba Cloud. You can use OSS to store large amounts of data in the cloud.
For more information, see What is OSS?
- open API
ApsaraDB RDS provides an API for third-party developers.
For more information, see Description.
You are charged an hourly fee for a pay-as-you-go RDS instance based on your actual resource usage. The pay-as-you-go billing method is suitable for short-term use. If you no longer need a pay-as-you-go RDS instance, you can release the instance to reduce costs.
For more information, see Billable items, billing methods, and pricing.
- physical I/O
Physical I/O indicates the read and write operations that are initiated by a file system to a disk.
- performance insight
Performance insight is a feature of DAS. This feature provides instance-level load monitoring, association analysis, and performance optimization. This feature helps you evaluate the loads on an RDS instance and troubleshoot performance issues to increase the stability of the RDS instance.
Queries per second (QPS) indicate the number of SQL statements that are executed on an RDS instance per second. These SQL statements include INSERT, SELECT, UPDATE, DETELE, and COMMIT.
Resource Access Management (RAM) is a service that is provided by Alibaba Cloud to manage user identities and resource access permissions. You can grant the permissions on specific RDS instances to RAM users.
For more information, see What is RAM?
- RDS instance
An RDS instance is a database process that exclusively occupies the allocated memory resources on a physical host. An RDS instance can be considered a virtual database server. You can specify different memory sizes, storage capacities, and database engines for different RDS instances. You can create and manage multiple databases on an RDS instance.
A region is the geographic location in which the RDS instance that you purchase resides. When you purchase an RDS instance, you must specify a region. The region of an RDS instance cannot be changed after the instance is created.
- read and write QPS
Read and write QPS indicates the number of INSERT, SELECT, and UPDATE statements that are executed on an RDS instance per second when both read and write requests are allowed.
- random I/O
Random I/O indicates the read and write operations that are performed on a disk at random.
- recycle bin
Some RDS instances are moved to the recycle bin after they expire or are released. You can unlock, rebuild, or destroy the RDS instances in the recycle bin.
For more information, see Manage ApsaraDB RDS for MySQL instances in the recycle bin.
- read-only RDS instance
If a database system processes a large number of read requests from an application, you can create read-only RDS instances that are used to offload read requests from the primary RDS instance of the database system. This increases the read capability of the database system and the throughput of the application.
For more information, see Overview of read-only ApsaraDB RDS for MySQL instances.
- read-only QPS
Read-only QPS indicates the number of SELECT statements that are executed on an RDS instance per second when only read requests are allowed.
- standard SSD
A standard SSD is an elastic block storage device that is designed based on a distributed storage architecture. You can store data on standard SSDs to separate computing from storage.
For more information, see Storage types.
Secure Sockets Layer (SSL) is developed by Netscape to establish encrypted connections between web servers and browsers. SSL supports various encryption algorithms, such as RC4, MD5, and RSA. The Internet Engineering Task Force (IETF) provides the SSL 3.0 standard. After the standard is established, SSL 3.0 is renamed as TLS. ApsaraDB RDS supports SSL for the MySQL, SQL Server, and PostgreSQL database engines. ApsaraDB RDS provides a server root certificate. You can use this server root certificate to check whether the database service that you access by using the destination IP address and port is supported by ApsaraDB RDS. This way, you can effectively defend against man-in-the-middle attacks. For security and validity purposes, ApsaraDB RDS allows you to enable and update the server SSL certificate.
For more information, see Configure SSL encryption for an ApsaraDB RDS for MySQL instance.
SQL Server Management Studio (SSMS) is an integrated environment that is used to manage SQL infrastructure. You can use SSMS to configure, monitor, and manage database instances that run SQL Server. In addition, SSMS provides various tools that can generate queries and scripts to deploy, monitor, and upgrade the components at the data layer. These components include the databases and data warehouses that run on applications.
- security group
A security group is a virtual firewall that is used to control the inbound and outbound traffic of specific Elastic Compute Service (ECS) instances. After you add a security group to an RDS instance, all ECS instances in the security group can access the RDS instance.
For more information, see Configure a security group for an ApsaraDB RDS for MySQL instance.
- sequential I/O
Sequential I/O indicates the contiguous read and write operations that are sequentially performed on a disk.
- semi-synchronous mode
After an update operation originated from an application is complete on a primary RDS instance, the update log record is synchronized to all secondary RDS instances that are attached to the primary RDS instance. The update transaction is considered committed after the secondary RDS instances receive the update log record rather than after the update log record is replayed on the secondary RDS instances. If the secondary RDS instances are unavailable or the communication between the primary RDS instance and the secondary RDS instances is abnormal, the semi-synchronous mode degrades to the asynchronous mode.
- synchronous mode
After an update operation originated from an application is complete on a primary RDS instance, the update log record is synchronized to all secondary RDS instances that are attached to the primary RDS instance. The update transaction is considered committed after at least one of the secondary RDS instances receives and stores the update log record. The synchronous mode cannot degrade to the asynchronous mode. The synchronous mode is supported only for the RDS Enterprise Edition. In addition, if you are using the RDS Enterprise Edition, the data replication mode cannot be changed.
- service account
The service account of an RDS instance is used by Alibaba Cloud technical support engineers to troubleshoot issues on the RDS instance. If Alibaba Cloud technical support engineers need to perform operations on an RDS instance during the troubleshooting process, you must grant permissions to the service account of the RDS instance. When the service account expires, ApsaraDB RDS deletes the service account.
For more information, see Authorize the service account of an ApsaraDB RDS for MySQL instance.
- schema migration
DTS can be used to migrate the schemas of objects from a source RDS instance to a destination RDS instance.
- slow SQL statement
If an SQL statement requires a long period of time to run, the SQL statement is a slow SQL statement.
For more information, see Slow query logs.
A subscription RDS instance is an instance for which you pay an upfront fee. For long-term use, the subscription billing method is more cost-effective than the pay-as-you-go billing method. You can receive larger discounts for longer subscription periods.
For more information, see Billable items, billing methods, and pricing.
ApsaraDB RDS supports transparent data encryption (TDE) for the MySQL and SQL Server database engines. TDE is used to instantly encrypt and decrypt the data files that are read from and written to an RDS instance. TDE can encrypt data before the data is written to the disk and decrypt data before the data is read from the disk to the memory. TDE does not increase the size of the data files. You can use TDE without the need to modify the connected application.
For more information, see Configure TDE for an ApsaraDB RDS for MySQL instance.
Transactions per minute (TPM) indicate the number of transactions that are run on an RDS instance per minute.
Transactions per second (TPS) indicate the number of transactions that are committed on an RDS instance per second.
A virtual private cloud (VPC) is an isolated network that provides higher security and higher performance than the classic network.
For more information, see What is a VPC?
Zones are the physical locations that are provided with independent power supply and networks in a region. Zones in the same region do not have substantive differences.