Now we have a database here that reaches 10G. We want to export it and import it to other servers. Basic exports can no longer be used, such as mysqldump and navicat exports. Are there any other methods or tools that can export the database and then migrate it to other places?
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
Using the open source ETL tool, kettle, is very good, and various databases can be transferred to each other.
Importing is impossible, just write a script and run it
The simpler way is to first convert the database table to MyIsam, and then directly copy the database file to other servers. Then modify it to the original database table engine.
Should we consider distributed storage?
Use xtrabackup to back up, then use rsync to transfer the backup to another server, and then use xtrabackup to restore. If it is transmitted through the intranet, the entire backup and restore time for 10G of data can be controlled within 1 hour (I am here 16 Core 32G server).
Offline the database and copy the physical files of the database
Can’t use mysqldump with only 10G? What the hell? I am running dump as usual with 100G here, and xtrabackup is also available
What level? Don't understand the answer? Report me? Weird! ! If you don’t understand, look it up! Please ask any questions, thank you!
Package data files directly?