copy data from one mysql server to another in parallel

copy-database.sh

#!bash

mysql_config_editor set --login-path=source -hmysql.source.com -uuser -p
mysql_config_editor set --login-path=destination -hmysql.destination.com -uuser -ppass
export ignoreSchema="'information_schema','mysql','performance_schema', 'awsdms_control'"

#get db list
mysql --login-path=source -ANe"SELECT distinct table_schema FROM information_schema.tables WHERE table_schema NOT IN (${ignoreSchema})" > dbs

#get table list
mysql --login-path=source -ANe"SELECT concat(table_schema, '/', table_name) FROM information_schema.tables WHERE table_schema NOT IN (${ignoreSchema})" > tables

#dump
mkdir schema
mkdir data
parallel --joblog job.log --bar 'mysqldump --login-path=source --add-drop-database --add-drop-table --no-data -B {} > schema/{}.sql 2>>mysql.log' :::: dbs
parallel --joblog job.log --bar 'mysqldump --login-path=source -CK --hex-blob --no-create-info {//} {/} > data/{//}.{/}.sql 2>>mysql.log' :::: tables

#load
parallel --joblog job.log --bar 'mysql --login-path=source -AC < schema/{}.sql &>> mysql.log' :::: dbs
parallel --joblog job.log --bar 'mysql --login-path=source -AC {//} < data/{//}.{/}.sql &>> mysql.log' :::: tables

# add --dry-run to any parallel command to see to see the list of commands it will run