# Server resources required for 2TB of remote mysql backup with Percona Xtrabackup

**URL:** https://forums.percona.com/t/server-resources-required-for-2tb-of-remote-mysql-backup-with-percona-xtrabackup/8178
**Category:** Percona XtraBackup
**Tags:** mysql
**Created:** [October 23, 2020, 8:02am UTC](https://forums.percona.com/t/server-resources-required-for-2tb-of-remote-mysql-backup-with-percona-xtrabackup/8178 "2020-10-23T08:02:40Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Supriya](https://avatars.discourse-cdn.com/v4/letter/s/5f8ce5/32.png) [@Supriya](https://forums.percona.com/u/Supriya)
#### Post date: [October 23, 2020, 8:02am UTC](https://forums.percona.com/t/server-resources-required-for-2tb-of-remote-mysql-backup-with-percona-xtrabackup/8178/1 "2020-10-23T08:02:40Z")

</div>

Hello,

I have migration of MySQL database with Innodb engine of 2Tb data with zero data loss on existing application.

How many CPU, RAM & network speed link is required to complete this migration within same day.

Is there any benchmarking in Percona Xtrabackup for such huge database backup?

---

<div class="post-metadata">

### Author: ![Marcelo\_Altmann](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/marcelo_altmann/32/11299_2.png) [@Marcelo\_Altmann](https://forums.percona.com/u/Marcelo_Altmann)
#### Post date: [October 26, 2020, 11:25am UTC](https://forums.percona.com/t/server-resources-required-for-2tb-of-remote-mysql-backup-with-percona-xtrabackup/8178/2 "2020-10-26T11:25:10Z")

</div>

Hi Supriya,

Here you will be looking into some best practices. For example:

1. Compression - Since you are streaming it over the wire, it’s better to waste some CPU cycles (fast) and have a smaller backup to send over the wire (slow) . Have a look at --compress parameter [https://www.percona.com/doc/percona-xtrabackup/2.4/backup\_scenarios/compressed\_backup.html](https://www.percona.com/doc/percona-xtrabackup/2.4/backup_scenarios/compressed_backup.html)

2. Parallelism - In order to speed up copy / compress operations, you can do them in parallel, check --parallel (for copying multiple files) and --compress-threads to fork multiple threads to perform compression

3. Apply log - There is one very important parameter to speed up --prepare phase which is --use-memory [https://www.percona.com/doc/percona-xtrabackup/2.4/xtrabackup\_bin/xbk\_option\_reference.html#cmdoption-xtrabackup-use-memory](https://www.percona.com/doc/percona-xtrabackup/2.4/xtrabackup_bin/xbk_option_reference.html#cmdoption-xtrabackup-use-memory)

In summary, for such operations we always advise you to test with a limited scope (smaller dataset), note down all the steps required to perform the backup / restore and once you are comfortable with the whole process you can perform it with your live data.