Comments on: MySQL 5.6 Transportable Tablespaces best practices

By: Joakim Karlsson

Joakim Karlsson — Wed, 26 Oct 2016 08:24:58 +0000

Hello Muhammed

This is a realy nice feature. But it turns out it desyncs cluster members if you try to import tablespace to a running cluster.

To restore a table on a running cluster i have to stop the additional kluster members, do the import on one machine and then force a full SST when starting the slave nodes again, elsewise they will have a empty version of the database and a galera kluster that says it’s synched when it’s not.

By: Mithun

Mithun — Thu, 07 May 2015 08:59:16 +0000

Hi,

Could you please help me out how to take backup of database tables in mysql version ..?

Regards,
Mithun

By: Daz

Daz — Mon, 15 Dec 2014 06:58:12 +0000

even you can restore table to the backup point, how to get the incremental binlog for this table?

By: Dilip

Dilip — Thu, 11 Dec 2014 14:45:34 +0000

Nice article for MySQL DBA and also for our Customer who always prefer on Table recovery.

By: Arnoldas

Arnoldas — Wed, 10 Dec 2014 06:58:06 +0000

That’s great news! Nice write up. I had some hacking to do to import single table from mylvmbackup, it’s way easier to to manage backups with innobackupex and new functions in Percona Server 5.6