Updated on 2025-05-22 GMT+08:00

PERF03-10 Selecting Appropriate Relational Databases

  • Risk level

    Medium

  • Key strategies

    Huawei Cloud provides multiple relational database services, including GaussDB, TaurusDB, and RDS (for MySQL, PostgreSQL, SQL Server, and MariaDB). GaussDB and TaurusDB are enterprise-level relational databases launched by Huawei based on the openGauss and MySQL ecosystems, respectively, offering better performance. RDS supports four open-source database engines and provides users with more stable, elastic, and easy-to-maintain cloud services via the cloud computing platform.

    Application scenarios:

    • GaussDB: enterprise-level distributed relational database based on the openGauss ecosystem led by Huawei. It features high availability and reliability on the cloud, security, auto scaling, one-click deployment, and quick backup and restoration. It is suitable for transaction applications with high concurrency, large data volume, and online transaction processing (OLTP), such as government affairs, finance, e-commerce, O2O, and telecom CRM/billing.
    • TaurusDB: Huawei-developed next-generation enterprise-level cloud native relational database. It is fully compatible with MySQL and features high performance, high scalability, high reliability, high compatibility, low cost, and non-middleware architecture. It is suitable for industries that require high security or high performance, such as the finance and gaming industries.
    • RDS: It features low cost, high performance, high security, and high reliability.
    • RDS for MySQL: MySQL is the most widely used open-source relational database. RDS for MySQL is suitable for website services, applications, and small- and medium-sized enterprises.
    • RDS for PostgreSQL: It is an open-source object cloud database management system that focuses on scalability and standards compliance. It is suitable for website services, location application systems, and complex data object processing.
    • RDS for SQL Server: Microsoft SQL Server is a commercial database with a mature enterprise-level architecture, and can easily cope with various complex environments. RDS for SQL Server is suitable for government, finance, healthcare, education, and gaming industries.
    • RDS for MariaDB: MariaDB is one of the mainstream open-source community databases and is quite compatible with MySQL. RDS for MariaDB is suitable for applications of various scales.

    Suggestions on selecting relational databases:

    Principle 1: Compatibility-based

    To ensure smooth migration to the cloud, you are advised to select the relational databases having the same ecosystem as the original databases. This prevents incompatibility between the database layer and application layer and negative impacts on other components in the service architecture.

    Principle 2: Requirement-based

    To create a service system on the cloud or select a service from different services of the same database, you are advised to consider the actual service requirements. For example, when selecting RDS for MySQL or TaurusDB, consider as many factors as possible, such as performance. For details about these factors, see the official documents.