Would like to loop over source databases/tables, mysqldump’ing in parallel on forked processes…
…gather the resulting files, move them to target server
and then loop over them in individual, parallel mysql import statement in parallel
…and catch up the inconsistencies of this “hot” logical backup using mysqlbinlog to make the target database consistent?
Looking for MYSQLDUMP incremental and pitr recovery options
Thanks.
PS (for now, physical/xtrabackup not an option.)