Updated on 2023-06-20 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 MySQL and 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.

Procedure

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

  1. Set up the data synchronization link. Set up a synchronization link from a database to CSS.
  2. Synchronize data from the database. Use a third-party tool, such as DRS or DataX, to synchronize data to CSS.