A Tale of 8T (Transportable Tablespaces Vs Mysqldump)

Thursday 4:10 PM - 4:35 PM

@ Hill Country D


25 minutes conference


Migration, Polyglot Persistence

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)



Kristofer Grahn

Kristofer Grahn (Verisure AB)

Senior Systems Specialist


Kristofer Grahn - Swiss-army knife Sysadmin and Dba. Started of as a Novell administrator working with Netware/Groupwise for Malmö university. Add Suse, Vmware and some Iscsi to the mix and you are ready to go Dba. Started @Verisure as a Linux Sysadmin and ended up caring for the the sharded Mysql databases and Cassandra cluster backing the platform.


  Download Slides  

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863