Multi-source replication is an awesome way to aggregate data for BI/Analytics, But how to get all those 42 database instances (Total 8T) into one instance when keeping weeks of binlog is not an option ? Comparing performance, ease of use, and load on source system for mysqldump and Xtrabackup/TT. Special cases : * 5.6 and Partitioned tables. * Tables in mixed formats (Partitions created over time) Partitions
