1

We have an old MYSQL server contains huge data ~5TB and wanted to migrate to the new server in order to minimize the costs and get rid of very old hardware.

My one and only idea in my mind is using mysqldump for the migration but I’m pretty sure that it’s a poor and risk option with that huge data.

Then someone in my team came up with the idea for using ETL tools but we haven’t go into the deeper details and not really sure if this ETL way can literally help us.

Any idea are always welcomed

thanks

5
  • Is there an overwhelming reason why cannot use a snapshot or xtrabackup? – Gordan Bobic Sep 18 '20 at 8:04
  • My one and only idea in my mind is using mysqldump Reimporting 5Gb of data will be very long. Does the database scheme is too complex, or it is relatively simple? What is: tables amount, FKs amount, SP/UDF amount, etc.? Do you want to store server version, or you want to upgrade it at the same time? – Akina Sep 18 '20 at 8:11
  • Is there a way to migrate the storage to the new hardware and to place that into a mirrored raid? – danblack Sep 18 '20 at 11:28
  • Unix or Windows? – Rick James Sep 19 '20 at 5:32
  • @RickJames It's Ubuntu 18.04 – BTH.S3 Sep 19 '20 at 9:52
0
$ mysqldump -h source ... | mysql -h dest ...

I'm assuming:

  • You have the tow machines (source and dest) set up.
  • The two machines are "close" (not on opposite sides of the globe) so that network delays, etc would need to be considered
  • That script would be run on one machine -- either one.
  • If the versions are different, I cannot predict whether there will be some hiccups based on inconsistencies between versions. If it fails running on one server, try the other. If that fails come back with the error message(s).
  • It will take time because 5TB takes time to read and write.

If the versions are radically different, there could be major changes that we need to discuss.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.