Shulou(Shulou.com)06/01 Report--

mycat data migration test

mycat data migration test

Testing data migration using mysqldump

Data volume 20 million

1. derived

-c parameter is required, otherwise the fragment table cannot be imported

mysqldump -udata_dev -p -h227.0.0.1 -P3307 -c --skip-add-locks data_dev data_dev >data_dev.sql

zip data_dev.sql.zip data_dev.sql

2. import

unzip data_dev.sql.zipmysql -uroot -p -h227.0.0.1 -P3306 mysql>source /home/myuser/data_dev.sql

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.