Logical backup with mysqldump

Facebook's MySQL 5.6 added enhancements into mysqldump to support MyRocks consistent backup. To take MyRocks backup with mysqldump, you need to use mysqldump built from Facebook's MySQL 5.6.

Like InnoDB, MyRocks supports consistent logical backup with mysqldump, with same options. Here is an example.

mysqldump -h 127.0.0.1 -P 3306 --default-character-set=binary --single-transaction --master-data=2

Facebook's mysqldump checks default_storage_engine global variable. It default_storage_engine is RocksDB, mysqldump takes consistent RocksDB backup. If it is InnoDB, mysqldump takes consistent InnoDB backup.