istyle Co., Ltd. is a Japanese company that manages beauty-related portal sites and provides advertising, marketing, and research services. They are the team responsible for @cosme, the most popular comprehensive beauty website in Japan. Initially launched in 1999 as a cosmetic review site, @cosme has evolved into a powerful service that helps users make informed product purchases through candid reviews, best-selling rankings, and personalized searches.
Besides operating @cosme, istyle also manages the e-commerce service @cosme SHOPPING and the brick-and-mortar @cosme STORE, providing a holistic experience for consumers passionate about beauty and cosmetics. To keep up with the rapid growth in user traffic, istyle launched a project to transition from an on-premises environment to a fully cloud-based AWS environment. A crucial component of this project involved migrating their main database from SQL Server to TiDB Cloud, the fully managed service of TiDB, an advanced, open-source,distributed SQL database. This move addressed long-standing technical challenges while further supporting the company’s business growth.
Challenges with legacy database solutions
Because the core system behind @cosme was Windows-centric, istyle used SQL Server as the core relational database management system (RDBMS). Over time, the system became increasingly complex, with more than 150 subsystems and a tightly-coupled database environment. The situation became extremely complicated and, over the years, had accumulated technical debt.
To fully migrate to the cloud, istyle needed to minimize application-side modification costs while addressing their technical debt.
Selecting the right cloud-based solution
istyle initiated the “Reborn Project” to tackle these challenges head-on. Based on the status quo of their challenges and issues, the team decided that only SQL Server could minimize the cost of repairing applications. Led by Toshifusa Suzuki, the project’s SQL Server subcommittee considered various options, including Amazon RDS for SQL Server, SQL Server on EC2, and Amazon Aurora.
Initial trial with Amazon RDS and SQL on EC2
The team initially considered Amazon RDS for SQL Server (RDS) as a way to move to the cloud without changing the DB engine. However, RDS did not support replication. As for SQL Server on EC2, the operating cost was quite high, including licensing.
The team again considered building with RDS and consolidating all databases into one RDS so that it would work even if replication was not possible. However, when they sized by the number of CPUs and required memory, the team found that RDS could only scale up by two levels. That was a problem: it made operations extremely inconvenient.
Evaluating TiDB for database migration
After the trial with Amazon RDS, Mr. Suzuki began exploring distributed RDBMS with the aim of merging multiple databases. The SQL Server in use had already supported multiple copies for reading and writing. They did not need additional primary-secondary configurations to meet performance requirements. Instead, by physically dividing the database internals rather than the database server, they could balance the load without replication. This approach would also enable joining between databases and reduce the need for application modifications during the migration process.
They then started properly evaluating TiDB and finally selected the solution for the following reasons:
- TiDB is MySQL compatible. When they migrated their data, they didn’t have to change any of their SQL statements.
- TiDB is horizontally scalable. TiDB consists of a TiDB layer that interprets SQL and a TiKV layer for distributed data storage. TiDB’s decoupled compute-storage architecture allows each layer to expand according to demand.
- TiDB has a columnar store, TiFlash, that speeds up analytic processing. This makes TiDB an Hybrid Transactional and Analytical Processing (HTAP) database that allows transaction processing and real-time analytic queries to be processed in the same database without extract, transform, load (ETL). In istyle’s test, TiDB demonstrated impressive results: some aggregate queries that previously took 30 seconds on conventional SQL servers ran in less than a second.
- Throughout istyle’s evaluation, the PingCAP team demonstrated thorough support and excellent R&D capabilities. This gave istyle enough confidence to continue using TiDB Cloud for their database needs.
Results and benefits
After a month of verification, istyle determined that TiDB was the best solution for their migration. TiDB Cloud, the managed service of TiDB on AWS, fits the scenarios of coupled DB groups, while Amazon Aurora is used specifically for applications with independent databases due to its lower costs.
By the fourth quarter of 2023, the company plans to complete the migration to TiDB Cloud. Compared to building SQL Server on EC2, this move is expected to cut costs by half.
Conclusion
istyle’s successful migration to TiDB Cloud is a testament to the power and flexibility of cloud-based solutions. By leveraging TiDB’s advanced features, istyle is set to continue its growth trajectory, providing an optimal user experience and a powerful platform for cosmetic brands to engage with their audience.
Ready to supercharge your data integration with TiDB? Join our Discord community now! 
Connect with fellow data enthusiasts, developers, and experts to: Stay Informed: Get the latest updates, tips, and tricks for optimizing your data integration. Ask Questions: Seek assistance and share your knowledge with our supportive community. Collaborate: Exchange experiences and insights with like-minded professionals. Access Resources: Unlock exclusive guides and tutorials to turbocharge your data projects. Join us today and take your data integration to the next level with TiDB!