Last time I was checked, how can TokuDB be used as a drop-in replacement for InnoDB. The first impressions were jolly good; way less disk space usage, and the TokuDB host can be a part of the current replication cluster.<\/p>\n
So far so good.<\/p>\n
<\/p>\n
Well, actually not everything is that nice because there is a very big part of the infrastructure is built on the top of xtrabackup.<\/p>\n
So let\u2019s see what can we do backing up TokuDB.<\/p>\n
The first and most clean way should be the mysqldump utility, but sadly this is not really useful for us, the restore process could be taken too many time because a lot of indexes has to be rebuilt.<\/p>\n
So we need to take binary backups. Sadly TokuDB currently offers the only tokudbhotbackup for hot backup which is a part of the enterprise feature set. Sadly that seems not opensource (yet!), but I hope Percona will change that soon.<\/p>\n
Until that the following things are sure: xtrabackup cannot back up TokuDB, so if you want to have binary backups, then I think the best way would be shut down the instance, and make the backup of the files. Maybe it should be done with an LVM snapshot.<\/p>\n
That\u2019s +1 for InnoDB.<\/p>\n","protected":false},"excerpt":{"rendered":"
Last time I was checked, how can TokuDB be used as a drop-in replacement for InnoDB. The first impressions were jolly good; way less disk space usage, and the TokuDB host can be a part of the current replication cluster. So far so good.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[134],"tags":[144,126,222],"class_list":["post-49","post","type-post","status-publish","format-standard","hentry","category-tech-en","tag-mysql-en","tag-oldblog-en","tag-tokudb-en"],"_links":{"self":[{"href":"https:\/\/banyek.net\/index.php?rest_route=\/wp\/v2\/posts\/49","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/banyek.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/banyek.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/banyek.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/banyek.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=49"}],"version-history":[{"count":1,"href":"https:\/\/banyek.net\/index.php?rest_route=\/wp\/v2\/posts\/49\/revisions"}],"predecessor-version":[{"id":432,"href":"https:\/\/banyek.net\/index.php?rest_route=\/wp\/v2\/posts\/49\/revisions\/432"}],"wp:attachment":[{"href":"https:\/\/banyek.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=49"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/banyek.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=49"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/banyek.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=49"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}