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?
習慣沉默2017-05-24 11:32:37
Using the open source ETL tool, kettle, is very good, and various databases can be transferred to each other.
大家讲道理2017-05-24 11:32:37
1.可以使用使用MySQL master/slave机制，将数据同步过去．
2.使用rsync(http://mah.everybody.org/docs/mysql-rsync)将MySQL的数据目录同步到另一台机器上．
漂亮男人2017-05-24 11:32:37
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.
PHPz2017-05-24 11:32:37
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).
phpcn_u15822017-05-24 11:32:37
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!
