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?
9
0
0
Using the open source ETL tool, kettle, is very good, and various databases can be transferred to each other.
1.可以使用使用MySQL master/slave機(jī)制，將數(shù)據(jù)同步過(guò)去．
2.使用rsync(http://mah.everybody.org/docs/mysql-rsync)將MySQL的數(shù)據(jù)目錄同步到另一臺(tái)機(jī)器上．
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.
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).
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!
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
