荔枝
Baidao helps with litchi data migration
Company Profile
Litchi is a leading online UGC audio community and interactive audio entertainment platform in China. Since the launch of the Litchi app in 2013, Litchi has created a vibrant and sustainable audio community that encourages the creation and sharing of audio content. Litchi has now become an audio playground, offering a variety of podcasts and audio entertainment products, including live audio and various interactive audio products, enabling users to enjoy an immersive and diverse audio entertainment experience.
industry
Online audio entertainment platform
User needs
The user hopes to achieve network communication between the Google VPC and the local data center. When using the MySQL database, the customer hopes to achieve local and remote data disaster prevention. In this case, the traditional approach is unwise because of the long construction cycle and high cost. For this situation, it is recommended to use Cloud SQL of GCP. Its backup solutions include high-availability configuration, backup, and remote replicas to solve the problem.
Scheme architecture
High – availability configurations provide data redundancy. Cloud SQL instances configured as HA, also known as regional instances, are located in the primary and secondary zones within the configured region.
In the regional instance, the configuration includes the primary instance and the standby instance. Data is replicated to the persistent disks of each region through synchronization, and all writes to the primary instance are applied to the standby instance. If an instance or local location fails, this configuration reduces downtime and the data is still available to client applications.
Products used
- Google Cloud SQL
- Google Cloud Engine
- Google Cloud Storage
- StackDriver
Features of the plan
1. You can use mysqldump to import and export data, migrating the MySQL database from local to GCP.
2. Enable HA and configure the first – layer protection of the database. When the primary instance fails, the secondary instance takes over and provides data services for the business.
3. Backups can restore lost data to a Cloud SQL instance. You can also restore a problematic instance through backups. Enable automatic backups for any instance containing the required data. Backups protect data from loss or corruption.
4. Create a copy of the Cloud SQL instance or local database and stream work into the copy.
The main reason for using replicas is to increase the usage of data in the database without affecting performance. Other reasons include:
- Migrate data between regions
- Migrate data between platforms
- Migrate data from the local database to Cloud SQL
In addition, if the original instance is damaged, the system can promote the replica.
