Updated on 2024-04-19 GMT+08:00

Migration from a Database

Process

Elasticsearch supports full-text search and ad hoc queries. It is often used as a supplement to relational databases, such as GaussDB(for MySQL), to improve the full-text search and high-concurrency ad hoc query capabilities of databases.

The following figure shows the process of migrating data from a database.

Figure 1 Migration from a database

This migration solution is convenient and flexible.

  • Convenient: You can start a cutover while the CSS synchronizes incremental data.
  • Flexible: Data can be added, deleted, modified, and queried on both sides.

Migration Guide

Data Replication Service (DRS) can be used to migrate and synchronize data between relational databases, such as GaussDB(for MySQL). For details about the supported database types, see Synchronization Overview.

Table 1 provides guidance for migrating source databases to CSS.

Table 1 Data synchronization guide

Source DB Type

Destination DB Type

Synchronization Mode

Related Documents

RDS for MySQL

CSS/ES

Full + incremental synchronization

From MySQL to CSS/ES

  • Local user-built MySQL databases
  • User-built MySQL databases on ECS

CSS/ES

Full + incremental synchronization

From MySQL to CSS/ES

GaussDB(for MySQL)

CSS/ES

Full + incremental synchronization

From GaussDB(for MySQL) to CSS/ES