Product Advantages
-
7x Performance Increase
GaussDB(for MySQL) is 100% compatible with MySQL but delivers 7x the performance.
GaussDB(for MySQL) is 100% compatible with MySQL but delivers 7x the performance.
-
1 Primary and 15 Read Replicas
In addition to a primary node, you can add up to 15 read replicas within minutes.
In addition to a primary node, you can add up to 15 read replicas within minutes.
-
128 TB of Storage
GaussDB(for MySQL) automatically grows storage as needed without sharding, up to 128 TB per DB instance.
GaussDB(for MySQL) automatically grows storage as needed without sharding, up to 128 TB per DB instance.
-
Snapshots Within Seconds
Snapshots are created in seconds and can be retained for up to 732 days and restored to any point in time.
Snapshots are created in seconds and can be retained for up to 732 days and restored to any point in time.
Why GaussDB(for MySQL)?
GaussDB(for MySQL) vs Open Source MySQL
- Performance
With DFV storage and vertical optimization of the software and hardware, GaussDB(for MySQL) gets 7x the performance of MySQL. It can process millions of queries per second (QPS).
- Scalability
You can add up to 15 read replicas in addition to scaling up or down CPU and memory specifications for a DB instance as needed.
- Storage
GaussDB(for MySQL) automatically grows storage as needed, up to 128 TB per DB instance.
- Reliability
To ensure data security, DB instances can be deployed across AZs, and an instance failover can be completed within seconds.
.png)
GaussDB(for MySQL) vs Other Similar Products
- Robust Performance
Compared with other products of the same type, GaussDB(for MySQL) delivers 30% higher performance for high concurrency requests with the same specifications.
- Low Delay
When a DB instance is deployed across AZs, applications can access the database from the nearest AZ to read data, reducing the access latency.
- Accelerated Query
GaussDB(for MySQL) uses NDP and parallel execution to maximize resource utilization and speed complex query by over 10x.
.png)
Key Technologies
Parallel Query
A parallel query uses multiple threads to execute a single SQL statement. It is dozens of times faster than a single-thread query. Parallel queries support COUNT(*) operation for larger tables, LIMIT/OFFSET operation, JOIN operation (for multiple tables), subqueries, function calculation, group sorting, and condition filtering. Parallel Query is suitable for complex queries of a large amount of data to reduce query time, for example, analytical queries for SQL statements and large-scale extraction for SQL statements.
Near Data Processing (NDP)
GaussDB(for MySQL) uses a NDP framework. For data-intensive queries, operations such as column extraction, condition filtering, and aggregation calculation are pushed to multiple nodes on a distributed storage layer for parallel execution. This improves parallel and query processing capabilities, and reduces network traffic pressure on compute nodes.
.png)
Application Scenarios
Finance
The finance industry has high requirements for data security and reliability with zero RPO and near-zero RTO. GaussDB(for MySQL) meets such requirements by combining the stability and reliability of commercial databases with the flexibility and cost-effectiveness of open-source databases.
Advantages
