TDSQL-C for MySQL is a highly elastic and performant database service that features excellent storage capacity, security, and reliability. It helps you easily tackle your needs in diverse business scenarios, such as frequent transactions like commodity orders, fast-growing business with traffic peaks, gaming, data-heavy infrequent queries like historical orders, financial data security protection, development, testing, and cost-sensitive business. This document introduces the strengths and benefits of TDSQL-C for MySQL in various scenarios including Internet and mobile apps, game applications, ecommerce and education live streaming, finance and insurance, and high-performance real-time data analysis.
1. Mobile internet application
Capabilities
Business Challenges
Provided Capabilities
TDSQL-C for MySQL Strengths
Recommended Matching Capabilities
In the Internet and mobile app scenarios, business challenges often include high-concurrency access, requirements of real-time data updating and synchronization, and requirements of good database scalability.
High performance
Solves the bottlenecks of high-concurrency access to hot data
Handles business burst peaks with rapid elastic scaling
High reliability
Provides high reliability of up to 99.9999999%
Quick configuration changes
Supports fast capacity expansion for computing and storage
It delivers commercial database-grade high performance and reliability. Its multiple custom-developed kernel optimizations and enterprise-grade features ensure smooth and efficient business operations, so that R&D personnel can focus on the development of business logic without worries.
It solves the problems of poor flexibility, low sync efficiency under high business pressure, and uncontrollable switch time in the traditional source-replica architecture. It ensures high system availability and business continuity while delivering high performance, which greatly reduces the workload of operations and Ops personnel.
It is fully compatible with open-source MySQL, so that your existing business applications can be connected with almost no changes required, helping you cloudify your business smoothly.
It has a built-in high availability architecture and automatically maintains multiple data replicas, checks data, and fixes errors, which reduce human intervention and achieve a data reliability of up to 99.9999999% (nine nines).
In the game business scenarios, players have long online time and the game business lifecycle is long. Most games use regional server-specific databases, record a large volume of data, and require very low latency. At the same time, game business requires high availability to avoid abnormal situations such as game server downtime and data loss. Rollback operations are a very important aspect of game business, requiring a balance between efficiency and integrity and minimal impact on users.
High performance
Elastic scaling of computing resources
Minute-level deployment of regional databases
Recovery to any point in time
High availability
Fully automatic disaster recovery and switchover without being perceived
It has agile and flexible scalability, which means that you don't need to purchase storage capacity in advance. It can quickly upgrade/downgrade according to your business needs for fast scaling and easy response to business peaks.
It offers a massive storage capacity for up to petabytes of data that can be automatically expanded. It eliminates the tedious operations of region and server merges and optimizes resource allocation and costs.
It features fast snapshot backup and rollback, which provides continuous protection for your data based on multiple replicas, making it an ideal database in the Internet and gaming industries.
In the ecommerce business scenarios, sudden traffic peaks can put great load pressure on servers, requiring the database architecture to be highly scalable and flexible. Additionally, high-concurrency access to hot data needs the support from a high-performance and high-availability architecture. Finally, ecommerce business usually has large data volumes, requiring high performance in multi-table join queries and high real-time performance.
High performance
Solves the bottlenecks of high-concurrency access to hot data
Handles business burst peaks with rapid elastic scaling
High availability
Comes with a high-availability architecture
High security
Effectively prevents security risk issues caused by malicious attacks, data leakage, or improper manual operations
It can be upgraded within seconds and expanded to 15 nodes at most to quickly increase the QPS, as compared with traditional databases where configuration upgrade takes longer as the storage capacity and host resource usage grow.
It delivers an excellent data write performance under high concurrency thanks to its engine optimizations and IOPS capability enhancement, helping you tackle business surges easily.
It leverages physical replication between the read-write and read-only nodes, which greatly reduces the delay and ensures the data consistency between buyers and sellers in ecommerce scenarios.
For financial services, main challenges in the database architecture lie in achieving high security, massive data processing, high performance, high availability, and high scalability. Additionally, it is essential to manage complex inquiries, transaction isolation, and optimization issues to ensure that the database architecture design for financial services adheres to extremely strict regulations and standards, thereby guaranteeing data integrity, stability, and reliability.
High security
Compliance with the requirements of cybersecurity classified protection
Builds a three-stage data security protection network for pre-, during-, and post-event stages
High availability
Comes with a high-availability architecture++
It is deployed in a multi-AZ architecture for disaster recovery and backup, with data backups stored in multiple AZs.
It adopts comprehensive methods such as allowlist and VPC to provide security guarantees for various links in database data access, storage, and management.
It uses the shared distributed storage architecture, which completely resolves the problem of poor data consistency in replica databases caused by async source-replica replication.
With the continuous growth of data volume, the data that enterprises need to handle is becoming increasingly complex. Different business departments and users require different types of data analysis, and the real-time performance of data analysis is becoming increasingly important. This has become a business challenge in today's business environment, determining whether enterprises can quickly obtain and analyze data to make timely decisions and strategic adjustments.
Real-time high-latitude query
Data visualization
BI report
Real-time monitoring and statistics
No need for complex and costly operations of ETL components. TDSQL-C for MySQL can directly synchronize data from the TXSQL engine to the read-only instances of the LibraDB engine.
The LibraDB engine can achieve high-performance real-time data analysis in large-scale data scenarios through the accelerated capabilities of a vectorized execution engine, massively parallel processing, and columnar storage.
Yes
No
Was this page helpful?