Skip to content

Latest commit

 

History

History
74 lines (52 loc) · 4.91 KB

dm-hardware-and-software-requirements.md

File metadata and controls

74 lines (52 loc) · 4.91 KB
Raw
title summary aliases
Software and Hardware Requirements for TiDB Data Migration
Learn the software and hardware requirements for DM cluster.
/docs/tidb-data-migration/dev/hardware-and-software-requirements/

Software and Hardware Requirements for TiDB Data Migration

TiDB Data Migration (DM) supports mainstream Linux operating systems. See the following table for specific version requirements:

Linux OS Version
Red Hat Enterprise Linux 7.3 or later
CentOS 7.3 or later
Oracle Enterprise Linux 7.3 or later
Ubuntu LTS 16.04 or later

DM can be deployed and run on Intel architecture servers and mainstream virtualization environments.

Recommended server requirements

DM can be deployed and run on a 64-bit generic hardware server platform (Intel x86-64 architecture). For servers used in the development, testing, and production environments, this section illustrates recommended hardware configurations (these do not include the resources used by the operating system).

Development and test environments

Component CPU Memory Local Storage Network Number of Instances (Minimum Requirement)
DM-master 4 core+ 8 GB+ SAS, 200 GB+ Gigabit network card 1
DM-worker 8 core+ 16 GB+ SAS, 200 GB+ (Greater than the size of the migrated data) Gigabit network card The number of upstream MySQL instances

Note:

  • In the test environment, DM-master and DM-worker used for functional verification can be deployed on the same server.
  • To prevent interference with the accuracy of the performance test results, it is not recommended to use low-performance storage and network hardware configurations.
  • If you need to verify the function only, you can deploy a DM-master on a single machine. The number of DM-worker deployed must be greater than or equal to the number of upstream MySQL instances. To ensure high availability, it is recommended to deploy more DM-workers.
  • DM-worker stores full data in the dump and load phases. Therefore, the disk space for DM-worker needs to be greater than the total amount of data to be migrated. If the relay log is enabled for the migration task, DM-worker needs additional disk space to store upstream binlog data.

Production environment

Component CPU Memory Hard Disk Type Network Number of Instances (Minimum Requirement)
DM-master 4 core+ 8 GB+ SAS, 200 GB+ Gigabit network card 3
DM-worker 16 core+ 32 GB+ SSD, 200 GB+ (Greater than the size of the migrated data) 10 Gigabit network card Greater than the number of upstream MySQL instances
Monitor 8 core+ 16 GB+ SAS, 200 GB+ Gigabit network card 1

Note:

  • In the production environment, it is not recommended to deploy and run DM-master and DM-worker on the same server, because when DM-worker writes data to disks, it might interfere with the use of disks by DM-master's high availability component.
  • If a performance issue occurs, you are recommended to modify the task configuration file according to the Optimize Configuration of DM document. If the performance is not effectively optimized by tuning the configuration file, you can try to upgrade the hardware of your server.

Downstream storage space requirements

The target TiKV cluster must have enough disk space to store the imported data. In addition to the standard hardware requirements, the storage space of the target TiKV cluster must be larger than the size of the data source x the number of replicas x 2. For example, if the cluster uses 3 replicas by default, the target TiKV cluster must have a storage space larger than 6 times the size of the data source. The formula has x 2 because:

  • Indexes might take extra space.
  • RocksDB has a space amplification effect.

You can estimate the data volume by using the following SQL statements to summarize the data-length field:

  • Calculate the size of all schemas, in MiB. Replace ${schema_name} with your schema name.

    {{< copyable "sql" >}}

    select table_schema,sum(data_length)/1024/1024 as data_length,sum(index_length)/1024/1024 as index_length,sum(data_length+index_length)/1024/1024 as sum from information_schema.tables where table_schema = "${schema_name}" group by table_schema;

  • Calculate the size of the largest table, in MiB. Replace ${schema_name} with your schema name.

    {{< copyable "sql" >}}

    select table_name,table_schema,sum(data_length)/1024/1024 as data_length,sum(index_length)/1024/1024 as index_length,sum(data_length+index_length)/1024/1024 as sum from information_schema.tables where table_schema = "${schema_name}" group by table_name,table_schema order by sum  desc limit 5;