A high-performance database service that is sharding-enabled and highly compatible with MySQL
Overview
TDSQL for MySQL is a comprehensive distributed database solution. It features strong consistency, high availability and performance, global deployment, distributed horizontal scaling, and enterprise-grade security. TDSQL for MySQL also provides features such as intelligent DBA, automated operations, and monitoring and alarming. As of today, TDSQL for MySQL provides database services deployed in both public and private clouds to more than 500 customers in the public service sector and private sector industries, such as banking, insurance, securities, internet finance, billing, third-party payment, IoT, and Internet+. Thanks to the high-quality services, TDSQL for MySQL has earned multiple international and national accreditations and recognition from the industry and customers.
You can enable automatic horizontal splitting (sharding) for a large table in a database by setting a shardkey when you create the table. The system can automatically distribute written data to different physical shards in an even manner based on the hash scheme. The system can also automatically aggregate query results before returning the results to clients. The sharding process does not affect business operations. Only the complete logical table is visible to your business. You do not need to pay attention to the backend physical architecture.
TDSQL for MySQL is compatible with commonly used MySQL syntax elements, including the language structures, character sets, time zones, data types, common functions, preprocessing protocols, sorts, joins (JOIN), indexes, partitions, transactions, and control commands of MySQL. TDSQL for MySQL is also compatible with common DDL, DML, and DCL commands and database access APIs.
Due to the characteristics of the distributed architecture, it is almost impossible to balance advanced functionality and high performance for distributed databases. To resolve this issue, TDSQL for MySQL provides three methods to create tables. TDSQL for MySQL supports distributed transactions, globally unique numerical sequences, and the JSON format. This helps address the deficiencies of distributed architectures and provides developers with more flexible development solutions.
A single shard can provide up to 6 TB of storage. If the performance or capacity is insufficient, you can scale up resources with a few clicks in the console. You do not need to worry about data migration, balancing, and route switching within the distributed system during the upgrade process. After the upgrade is complete, the IP address remains unchanged. A transient connection issue occurs only during the automatic switchover process and persists for a few seconds. You only need to make sure that your business has a reconnection mechanism.
TDSQL for MySQL adopts a primary/secondary architecture by default. This ensures more than 99.95% availability. TDSQL for MySQL supports strong synchronous replication to ensure strong data consistency. An application transaction is responded to only after the data written by the business system is synchronized to the secondary database. This ensures complete primary-secondary data consistency and eliminates data loss or corruption. The performance of strong synchronous replication is almost equivalent to that of asynchronous replication.
Based on a customized and optimized MySQL kernel, TDSQL for MySQL provides greater performance than MySQL. TDSQL for MySQL provides three solutions to implement read/write separation to ensure development flexibility while providing read extensibility. TDSQL for MySQL provides optimized scheduling algorithms for thread pools. This enables TDSQL for MySQL to deliver high and stable performance even if the system is under heavy load. TDSQL for MySQL is also equipped with PCIe SSDs that feature an I/O throughput more than three times higher than that of SATA disks. This helps meet the performance requirements of your business.
A production-ready TDSQL for MySQL instance can be launched and accessed in minutes with a few clicks in the console. The console allows you to perform frequently used database OPS operations to manage your databases in a refined manner. The console can also visualize common system monitoring data and performance analysis data to help you troubleshoot database issues.
TDSQL for MySQL supports native JSON data types. It does not store JSON values as strings. Instead, TDSQL for MySQL uses an internal binary format that allows for quick read access to document elements. In this way, JSON text is automatically validated when it is inserted or updated in JSON columns. TDSQL for MySQL can be considered as a NoSQL database that is compatible with the MySQL protocol.
E-commerce businesses
Performance is the most critical concern for large e-commerce platforms, almost all of which are based on distributed databases. Only databases with a distributed architecture can overcome hardware restrictions and support linear scaling of performance to support high-traffic promotional events. In 2017, an e-commerce service platform, launched less than a year ago, started to see high month-over-month growth. When the average number of orders per day surpassed 10,000, the performance and scalability disadvantages of non-distributed databases emerged. It took less than one month for the platform to migrate its business to TDSQL for MySQL. This helped the platform remain operational throughout sales events such as the Double 11 and Double 12 shopping sprees.
Financial businesses
The rise of internet-based financial services such as mobile banking and online wealth management as well as advancements in blockchain technology have brought about dramatic changes in financial transactions. For example, more transactions in smaller amounts are made. Therefore, traditional database architectures can no longer sustain business development, and network security risks start to increase. TDSQL for MySQL provides not only high-performance scalability but also strong synchronization capabilities. This helps prevent data errors and loss. TDSQL for MySQL also offers a wide range of security solutions, such as a dedicated cluster solution and an access encryption solution.
IoT businesses
Typical IoT scenarios such as industrial monitoring and remote control, smart city, smart home, and IoV require a large number of sensing and monitoring devices, high sample rates, and massive storage capacity. TDSQL for MySQL provides a linearly scalable capacity that can effectively meet the business requirements of these scenarios. TDSQL for MySQL also supports the MySQL protocol and JSON. This allows developers to develop systems in their preferred programming languages.
Gaming businesses
For SNS games with unified servers and emerging IO games, the number of peak concurrent users (PCUs) can reach 100,000 or even 10 million in a short period of time. Therefore, it is necessary to have the smooth scalability of all functional modules in mind at the very beginning of game development. Stateless servers such as GameSvr and MatchSvr are easy to scale. However, scaling DBSvr, which records all relationship chains, match scores, and transactions, is a significant challenge. TDSQL for MySQL can help you resolve this issue with ease by scaling your game in a convenient manner.
