![mysql enterprise backup performance mysql enterprise backup performance](https://image.slidesharecdn.com/meb-180118105220/95/mysql-enterprise-backup-better-very-large-database-backup-recovery-and-more-21-638.jpg)
The application team can use this information to quickly locate faults in the classroom system and do some troubleshooting, such as switching lines, to ensure class quality. This information is reported through the parent and the teacher applications. This system collects information on classroom events in real time, including when students enter and leave the classroom and when services are initialized. To understand this scenario, consider our classroom troubleshooting system. The following figure shows the application scenarios with large data volumes and highly concurrent writes. Working with large amounts of data and highly concurrent writes Multi-dimensional queries for sharded core applications.Working with large amounts of data and highly concurrent writes.We’ve found that TiDB is especially helpful to us in these application scenarios: It’s suitable for various use cases that require high availability and strong consistency with large-scale data.The scaling process is transparent to application operations and maintenance staff. The TiDB architecture design separates computing from storage and enables us to separately scale out or scale in the computing or storage capacity online as needed. It supports horizontally scaling in or out.To migrate a production application to TiDB, we only need to modify a small amount of code. It’s compatible with the MySQL protocol, common MySQL features, and the MySQL ecosystem.TiDB has many advantages, of which the following attract us most: You can learn more about TiDB’s architecture here. It’s a one-stop solution for both Online Transactional Processing (OLTP) and Online Analytical Processing (OLAP) workloads. It is MySQL compatible and features horizontal scalability, strong consistency, and high availability. TiDB is an open-source, distributed SQL database built by PingCAP and its open-source community. Therefore, we looked for a new database and found that TiDB is a good solution. If the load among shards became unbalanced, we needed to reshard data.It was difficult to perform cross-shard queries.It increased application complexity, and the application became difficult to maintain.We tried MySQL sharding but found it had these disadvantages: But as our data size sharply increased, a standalone MySQL database had limited storage capacity and couldn’t provide services for us. Previously, we used MySQL as our backend database. First, I’ll discuss the application scenarios in which we use TiDB, and then I’ll share the benefits TiDB gives us.
![mysql enterprise backup performance mysql enterprise backup performance](https://fourcornerstone.com/wp-content/uploads/2014/02/Screen-Shot-2019-05-22-at-6.31.06-PM.png)
I’m a senior DBA engineer at VIPKid, and I’d like to discuss how we use TiDB to do multi-dimensional queries on sharded data and enhance our real-time analytics capability. We don’t need to worry about cross-shard, multi-dimensional queries for sharding any more. We can use it to perform multi-dimensional SQL queries.
![mysql enterprise backup performance mysql enterprise backup performance](https://img.yumpu.com/39441181/1/500x640/datasheet-agent-for-mysql-server-v16-druva.jpg)
![mysql enterprise backup performance mysql enterprise backup performance](https://dbtut.com/wp-content/uploads/2018/10/401.png)
TiDB supports creating secondary indexes on large tables. Therefore, we adopted TiDB, an open-source, distributed SQL database that supports Hybrid Transactional/Analytical Processing (HTAP) workloads. We tried MySQL sharding on our core applications, but it was difficult to run multi-dimensional queries on sharded data. But as our application data grew rapidly, standalone MySQL’s storage capacity became a bottleneck, and it could no longer meet our application requirements. Currently, we have more than 700,000 paying students. Through our online classroom portal and video chat platform, children in China can get a 25-minute English lesson from a fluent English speaking teacher in the United States or Canada. VIPKid is an online English education company based in China that serves children aged 4-15 and their parents. Transcreator: Tom Dewan Editor: Caitin Chen Author: Chao Xu (Senior DBA Engineer at VIPKid)