Help Center/ GaussDB(for MySQL)/ Service Overview/ Differences Between GaussDB(for MySQL) and RDS for MySQL
Updated on 2023-10-18 GMT+08:00

Differences Between GaussDB(for MySQL) and RDS for MySQL

GaussDB(for MySQL) has good performance, scalability, and usability. For details, see Table 1.

Table 1 Differences between GaussDB(for MySQL) and RDS for MySQL

Item

RDS for MySQL

GaussDB(for MySQL)

Architecture

Traditional primary/standby architecture. Data is synchronized between the primary and standby nodes using binlog.

Decoupled storage and compute architecture. Compute nodes share the same data and data does not need to be synchronized using binlog.

Performance

Hundreds of thousands of QPS, delivering three times the performance of the open-source MySQL in high concurrency.

Millions of QPS, delivering seven times the performance of the open-source MySQL. In complex queries, operations, such as column extraction, conditional filtering, and aggregation calculation, can be pushed down to the storage layer, improving the performance by dozens of times compared with traditional databases.

Scalability

  • Up to five read replicas can be added for an instance. The time required for adding read replicas depends on the data volume. Adding read replicas require additional storage.
  • The storage can grow as needed, with up to 4 TB for an instance.
  • Up to 15 read replicas can be added for an instance. Thanks to the shared storage, the time required for adding read replicas is not affected by the data volume. In addition, no additional storage is needed for read replica creation.
  • The storage grows as needed with up to 128 TB for an instance.

Availability

If the primary instance fails, the standby instance can be automatically promoted to the primary, with an RTO of less than 30s.

If the primary node is faulty, a read replica can be automatically promoted to the primary, with an RTO of less than 10s. It has lower latency because no data synchronization is required between the primary node and read replicas using binlog.

Backup restoration

Data can be restored to a specific point in time using full backups and binlog playback.

Data can be restored to a specific point in time using full backup (snapshots) and redo playback. Its restoration speed is faster.

DB engine version

MySQL 5.6, 5.7, and 8.0.

MySQL 8.0