What is the best way to migrate 200G database

MySQL & MariaDB Percona Server for MySQL 8.0
1

Hello,

I’ve mysql 5.6 running on production server. And now i’ve a new VM with mysql version 8.0, I need to migrate 200G database from the old vm to the new vm with version 8.0…I’ve tried mysqldump and mysql restore but it takes about 24 hours to restore the 200G database.

So the question is:

  1. what is the best option to migrate the 200G database from the old vm to the new vm?
  2. Is there any option to increase the mysqldump restore? NOTE: the vm have many resources that not usable while restore process running.
2

Hello @elkhedewy,
You need to look at GitHub - mydumper/mydumper: Official MyDumper Project
mysqldump is single-threaded, which is why you are not seeing many resources used. mydumper is multi-threaded for both dump and restore (myloader). You will see much faster export times using mydumper.

1 Like