Baidao helps with the data cloud migration of FOLLWME

FOLLOWME was founded in 2015 and is a trading community. Global foreign exchange trading users can connect through FOLLOWME. In this community, users can share trading experiences, showcase trading strategies, and communicate with other traders. Over 400,000 users from more than 170 countries have registered on FOLLOWME. It supports account connections with over 2,000 global brokers, and users can achieve automated copy trading through COPYTRADE.

industry

finance

Case background and challenges

FOLLOWME is a fintech company founded in 2015 by a group of tech-savvy programmers. It provides an open community trading platform where traders and investors from around the world can post trading strategies, share experiences and ideas in real-time. Their real accounts have all been connected to FOLLOWME. Adhering to the concept of “putting users first” and “using technology for good”, FOLLOWME continuously innovates in technology, striving to become the world’s most popular trading community and making trading transparent and easy.

Followme users are located in various regions around the world. For any database that serves multiple copies of its data in different available zones or geographical regions, trade – offs are needed to improve reliability. Databases designed to ensure that everyone sees a consistent view of the latest data may use a consensus algorithm to update these copies synchronously, which will affect the speed of serving data. On the other hand, databases optimized for faster data service may update each copy asynchronously and cannot guarantee consistent reads across records. Customers’ expansion needs can easily affect millions of concurrent users within a few hours or even minutes. Sharded MySQL databases are mainly used in database scaling use cases that require transactions. Since sharding a MySQL database manually increases operational costs, it also affects the user experience.

The architecture is as follows:

Description of the solution architecture

With Cloud Spanner, automatic sharding can be done based on request load and data size, improving performance. Therefore, customers don’t have to worry too much about how to scale the database and can focus on expanding their business. Cloud Spanner is built on Google’s private network and has been well-tested in Google services used by billions of users. It can achieve up to 99.999% availability and zero downtime during planned maintenance and schema changes. Cloud Spanner has all the functions that a relational database should have and can be scaled globally at any time. No matter where the users are, customers can provide a consistent and reliable user experience.

Use the product

• Database Migration Service
• Cloud SQL
• Cloud Spanner
• Compute Engine
• StackDriver

Features of the plan

Database Migration Service (DMS): DMS is a serverless product that relies on local database replication to quickly and securely migrate databases to Cloud SQL with minimal downtime. DMS provides a wizard – based experience, guiding you through the creation of migrations via built – in, customized source configuration information, setup of multiple secure network connection options, and built – in scripts for easy execution.

Datastream: Datastream is a serverless change data capture (CDC) and replication service. For migration scenarios not covered by DMS, Datastream can provide useful building blocks for building data migrations.

migVisor: migVisor is a tool used by Google Professional Services to assist in planning database migration strategies for database products. migVisor scans database instances to determine the exact features, specifications, attributes, and objects present in the database to help determine how they are affected

Striim: Striim is a Google Partner Service that ingests data from relational databases, log files, messaging systems, and sensors via log – based CDC. While the data is in motion, Striim can perform inline transformations before delivering it to Google Cloud services.

Customer benefits

• After using Cloud Spanner, the customer’s cost was reduced by 30%.
• With Cloud SQL, it also saved the customer about 12% of the cost in migration.
• After migrating to the cloud data warehousing and analytics solution, the cost was reduced by 40%.