Embracing NewSQL: Why We Chose TiDB Over MongoDB and MySQL

Embracing NewSQL: Why We Chose TiDB Over MongoDB and MySQL

Embracing NewSQL: Learn Why We Chose TiDB Over MongoDB and MySQL. PalFish explains why they chose TiDB over MongoDB and MySQL. The key factors were their application requirements and their perspective on NewSQL databases.

PalFish explains why they chose TiDB over MongoDB and MySQL. The key factors were their application requirements and their perspective on NewSQL databases.

PalFish  is a fast-growing online education platform that focuses on English learning. It offers tailored English speaking experience to English as a Second Language (ESL) students. As of October 2020, PalFish has over 40 million users, of which more than 2 million are paid users.

As our business rapidly grew, the surge of data posed a severe challenge to our MongoDB database. MongoDB (2.x and 3.x) does not support transactions and has no predefined schema to directly regulate data. This blocked our business growth. To solve these problems, we migrated from MongoDB to TiDB, an open-source, MySQL-compatible, distributed SQL database that supports Hybrid Transactional/Analytical Processing (HTAP) workloads. This turned out to be the right move.

In this post, we'll share with you why we chose TiDB over MongoDB and MySQL and how TiDB supports our application with doubled users. We hope our experience can help you find the most appropriate database for your application.

database mongodb mysql newsql tidb

What is Geek Coin

What is GeekCash, Geek Token

Best Visual Studio Code Themes of 2021

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Best MySQL DigitalOcean Performance – ScaleGrid vs. DigitalOcean Managed Databases

Compare ScaleGrid MySQL vs. DigitalOcean Managed Databases - See which offers the best MySQL throughput, latency, and pricing on DigitalOcean across workloads.

Install MongoDB Database | MongoDB | Asp.Net Core Mvc

LIKE | COMMENT | SHARE | SUBSCRIBEIn this tutorial, I will discuss how to install MongoDB Database.Blog: http://aspdotnetexplorer.blogspot.comLike our page -...

MongoDB vs MySQL | Difference Between MongoDB And MySQL | MySQL vs MongoDB Performance

MongoDB and MySQL are widely used database management systems. But have you wondered what sets them apart? And what exactly are the differences between the two? If so, then you're in the right place. This video on MySQL vs MongoDB will explain the differences between the two and which one you could choose for your business

Query of MongoDB | MongoDB Command | MongoDB | Asp.Net Core Mvc

LIKE | COMMENT | SHARE | SUBSCRIBEIn this tutorial, I will discuss the basic query or command of MongoDB Database. We will learn how to Create, Delete, and ...

MongoDB Vs MySQL: Which One Is A Better Database In 2020? -

Confused between MongoDB vs MySQL? Don't know which one to go for? Read this detailed article to understand more about both the databases.