Comparison Item | TDSQL-C for MySQL | TDSQL for MySQL |
Database type | A new-generation relational database that is born cloud-native | A distributed database that supports automatic horizontal sharding and adopts a Shared Nothing architecture |
Architecture | Cluster: A cluster can contain only one read-write instance and up to 15 read-only instances. | InnoDB engine: Physical shard, with one shard containing 1 source and 1 replica or 1 source and 2 replicas |
Engine | InnoDB | InnoDB TDStore |
Version | MySQL 5.7 MySQL 8.0 | MySQL 8.0 Percona 5.7 MariaDB 10.1 |
Application scenarios | Businesses with great changes, frequent scaling, or needs of read-only instances to improve the read performance. Game projects with frequent quick rollback required Storage and access of petabytes of data Scenarios requiring a high write QPS Scenarios that are sensitive to source-replica delay | Ecommerce, finance, O2O, social applications, retail, SaaS service providers Online business systems with a large data volume |
Specification | Up to 88 cores and 710 GB memory per instance | Up to 32 cores and 128 GB memory per shard |
Automatic backup | The default retention time is 7 days, and the maximum retention time can be set to 1830 days. | The default retention time is 7 days, and the maximum retention time can be set to 365 days. |
Manual backup | Supported | Unsupported |
Backup file format | Logical Snapshot | Logical Physical |
Serverless | Supports serverless elastic expansion without manual intervention, and scales up or down automatically and quickly. | Unsupported |
Maximum of creatable tables | There are no limits on the number of databases or tables that can be created. In theory, as long as there is enough space, more databases and tables can be created. | The maximum number of creatable tables is 5000 by default. |
Read/write separation | Supported | Supported |
Was this page helpful?