Peronca TokuBackup is currently a bit tricky to get installed, since percona neither has source tarballs nor binary downloads up on their site. The documentation (https://www.percona.com/doc/percona-server/5.6/tokudb/toku_backup.html) mentions that it's shipped as part of Percona Server, but obviously doesn't help much when you're running MariaDB.
Would be nice if there would be some better availability for MariaDB
The source to the tokudb backup plugin is in two repos:
github.com:percona/percona-tokubackup
github.com:percona/tokudb-backup-plugin
These two repo's need to be checked out and built with the mariadb server source. Here is an example on how to build the tokudb backup plugin into mariadb 10.1:
set -e
if [ ! -d mariadb-server ] ; then git clone git@github.com:mariadb/server mariadb-server; fi
if [ ! -d percona-tokubackup ] ; then git clone git@github.com:percona/percona-tokubackup; fi
if [ ! -d tokudb-backup-plugin ] ; then git clone git@github.com:percona/tokudb-backup-plugin; fi
pushd tokudb-backup-plugin
rm -rf backup
ln -s ../percona-tokubackup/backup
popd
pushd mariadb-server/plugin
if [ -d tokudb-backup-plugin ] ; thenrm tokudb-backup-plugin; fi
Rich Prohaska
added a comment - - edited The source to the tokudb backup plugin is in two repos:
github.com:percona/percona-tokubackup
github.com:percona/tokudb-backup-plugin
These two repo's need to be checked out and built with the mariadb server source. Here is an example on how to build the tokudb backup plugin into mariadb 10.1:
set -e
if [ ! -d mariadb-server ] ; then git clone git@github.com:mariadb /server mariadb-server; fi
if [ ! -d percona-tokubackup ] ; then git clone git@github.com:percona /percona-tokubackup ; fi
if [ ! -d tokudb-backup-plugin ] ; then git clone git@github.com:percona /tokudb-backup-plugin ; fi
pushd tokudb-backup-plugin
rm -rf backup
ln -s .. /percona-tokubackup/backup
popd
pushd mariadb-server /plugin
if [ -d tokudb-backup-plugin ] ; then rm tokudb-backup-plugin; fi
rm -rf tokudb-backup-plugin
ln -s ../.. /tokudb-backup-plugin
popd
rm -rf build install
mkdir build install
pushd build
cmake -DCMAKE_BUILD_TYPE=Debug -DCMAKE_INSTALL_PREFIX=.. /install -DMYSQL_MAINTAINER_MODE=OFF .. /mariadb-server
make -j8 install
popd
Need to preload the hot backup library:
LD_PRELOAD=$PWD /lib/libHotBackup .so bin /mysqld_safe --defaults- file =~ /rfp .cnf --plugin-load-add=ha_tokudb.so --plugin-load-add=tokudb_backup.so &
Here is the user interface:
MariaDB [(none)]> show variables like 'version';
+---------------+----------------------+
| Variable_name | Value |
+---------------+----------------------+
| version | 10.1.8-MariaDB-debug |
+---------------+----------------------+
1 row in set (0.00 sec)
MariaDB [(none)]> show variables like 'tokudb_backup%';
+---------------------------------+-----------------------------------+
| Variable_name | Value |
+---------------------------------+-----------------------------------+
| tokudb_backup_allowed_prefix | |
| tokudb_backup_dir | |
| tokudb_backup_exclude | |
| tokudb_backup_last_error | 0 |
| tokudb_backup_last_error_string | |
| tokudb_backup_plugin_version | |
| tokudb_backup_throttle | 18446744073709551615 |
| tokudb_backup_version | tokubackup 1.2 $Revision: 56100 $ |
+---------------------------------+-----------------------------------+
Colin Charles
added a comment - Now that TokuBackup is also completely OSS and integrated into Percona Server we should have this in the next release: https://www.percona.com/doc/percona-server/5.6/tokudb/toku_backup.html
bohutang
added a comment - Hello,
I have hack a patch for Percona Xtrabackup.
With it, now we can backup both InnoDB and TokuDB on PS5.6/PS5.7 and MariaDB.
Patch is:
https://github.com/BohuTANG/percona-xtrabackup/commit/b43ba1b25deff2ba21eb9030b49413e1851f263b
Could anyone explain why this has been closed as "Won't fix"?
The bug is "major" and comments suggested there was some activity around it.
Federico Razzoli
added a comment - - edited Could anyone explain why this has been closed as "Won't fix"?
The bug is "major" and comments suggested there was some activity around it.
Geoff Montee (Inactive)
added a comment - f_razzoli ,
Percona is the primary developer of TokuDB, and it looks like Percona has deprecated TokuDB starting with Percona Server 8.0:
https://www.percona.com/doc/percona-server/8.0/tokudb/tokudb_intro.html
As a consequence, TokuDB might also end up getting deprecated and/or removed from MariaDB. See MDEV-19780 about that.
Percona's replacement for TokuDB appears to be MyRocks. That is also available in MariaDB:
https://mariadb.com/kb/en/myrocks/
People
Sergei Golubchik
Heinz Wiesinger
Votes:
13Vote for this issue
Watchers:
19Start watching this issue
Dates
Created:
Updated:
Resolved:
Git Integration
Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.
{"report":{"fcp":749.2999999523163,"ttfb":207.20000004768372,"pageVisibility":"visible","entityId":53347,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"4a6f1e2e-599a-4e8d-bff6-9f59c4b9ad36","navigationType":0,"readyForUser":818.2000000476837,"redirectCount":0,"resourceLoadedEnd":656.8999999761581,"resourceLoadedStart":232.5,"resourceTiming":[{"duration":14.100000023841858,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":232.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":232.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":246.60000002384186,"responseStart":0,"secureConnectionStart":0},{"duration":15,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":232.70000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":232.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":247.70000004768372,"responseStart":0,"secureConnectionStart":0},{"duration":65.20000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":232.89999997615814,"connectEnd":232.89999997615814,"connectStart":232.89999997615814,"domainLookupEnd":232.89999997615814,"domainLookupStart":232.89999997615814,"fetchStart":232.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":232.89999997615814,"responseEnd":298.10000002384186,"responseStart":298.10000002384186,"secureConnectionStart":232.89999997615814},{"duration":154.60000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":233,"connectEnd":233,"connectStart":233,"domainLookupEnd":233,"domainLookupStart":233,"fetchStart":233,"redirectEnd":0,"redirectStart":0,"requestStart":233,"responseEnd":387.60000002384186,"responseStart":387.60000002384186,"secureConnectionStart":233},{"duration":150.79999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":233,"connectEnd":233,"connectStart":233,"domainLookupEnd":233,"domainLookupStart":233,"fetchStart":233,"redirectEnd":0,"redirectStart":0,"requestStart":233,"responseEnd":383.7999999523163,"responseStart":383.7999999523163,"secureConnectionStart":233},{"duration":154.89999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":233.10000002384186,"connectEnd":233.10000002384186,"connectStart":233.10000002384186,"domainLookupEnd":233.10000002384186,"domainLookupStart":233.10000002384186,"fetchStart":233.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":233.10000002384186,"responseEnd":388,"responseStart":388,"secureConnectionStart":233.10000002384186},{"duration":155.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":233.29999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":233.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":388.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":155,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":233.29999995231628,"connectEnd":233.29999995231628,"connectStart":233.29999995231628,"domainLookupEnd":233.29999995231628,"domainLookupStart":233.29999995231628,"fetchStart":233.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":233.29999995231628,"responseEnd":388.2999999523163,"responseStart":388.2999999523163,"secureConnectionStart":233.29999995231628},{"duration":155.30000007152557,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":233.39999997615814,"connectEnd":233.39999997615814,"connectStart":233.39999997615814,"domainLookupEnd":233.39999997615814,"domainLookupStart":233.39999997615814,"fetchStart":233.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":233.39999997615814,"responseEnd":388.7000000476837,"responseStart":388.7000000476837,"secureConnectionStart":233.39999997615814},{"duration":155.60000002384186,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":233.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":233.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":389.10000002384186,"responseStart":0,"secureConnectionStart":0},{"duration":155.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":233.70000004768372,"connectEnd":233.70000004768372,"connectStart":233.70000004768372,"domainLookupEnd":233.70000004768372,"domainLookupStart":233.70000004768372,"fetchStart":233.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":233.70000004768372,"responseEnd":389.2999999523163,"responseStart":389.2999999523163,"secureConnectionStart":233.70000004768372},{"duration":371.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":234.5,"connectEnd":234.5,"connectStart":234.5,"domainLookupEnd":234.5,"domainLookupStart":234.5,"fetchStart":234.5,"redirectEnd":0,"redirectStart":0,"requestStart":234.5,"responseEnd":606.2999999523163,"responseStart":606.2999999523163,"secureConnectionStart":234.5},{"duration":417.60000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":234.60000002384186,"connectEnd":234.60000002384186,"connectStart":234.60000002384186,"domainLookupEnd":234.60000002384186,"domainLookupStart":234.60000002384186,"fetchStart":234.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":234.60000002384186,"responseEnd":652.2000000476837,"responseStart":652.2000000476837,"secureConnectionStart":234.60000002384186},{"duration":153.30000007152557,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":453.2999999523163,"connectEnd":453.2999999523163,"connectStart":453.2999999523163,"domainLookupEnd":453.2999999523163,"domainLookupStart":453.2999999523163,"fetchStart":453.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":453.2999999523163,"responseEnd":606.6000000238419,"responseStart":606.6000000238419,"secureConnectionStart":453.2999999523163},{"duration":3.899999976158142,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bu7/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":653,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":653,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":656.8999999761581,"responseStart":0,"secureConnectionStart":0},{"duration":253.69999992847443,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":653.7000000476837,"connectEnd":653.7000000476837,"connectStart":653.7000000476837,"domainLookupEnd":653.7000000476837,"domainLookupStart":653.7000000476837,"fetchStart":653.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":653.7000000476837,"responseEnd":907.3999999761581,"responseStart":907.3999999761581,"secureConnectionStart":653.7000000476837},{"duration":257.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/f51ef5507eea4c158f257c66c93b2a3f-CDN/lu2bu7/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":654.1000000238419,"connectEnd":654.1000000238419,"connectStart":654.1000000238419,"domainLookupEnd":654.1000000238419,"domainLookupStart":654.1000000238419,"fetchStart":654.1000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":654.1000000238419,"responseEnd":911.8999999761581,"responseStart":911.8999999761581,"secureConnectionStart":654.1000000238419}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":17,"responseStart":207,"responseEnd":221,"domLoading":229,"domInteractive":881,"domContentLoadedEventStart":881,"domContentLoadedEventEnd":931,"domComplete":1154,"loadEventStart":1155,"loadEventEnd":1155,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":848.7999999523163},{"name":"bigPipe.sidebar-id.end","time":849.7000000476837},{"name":"bigPipe.activity-panel-pipe-id.start","time":849.7999999523163},{"name":"bigPipe.activity-panel-pipe-id.end","time":853.6000000238419},{"name":"activityTabFullyLoaded","time":953.1000000238419}],"measures":[],"correlationId":"36d7d2d603c6a7","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":111,"dbReadsTimeInMs":12,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
The source to the tokudb backup plugin is in two repos:
github.com:percona/percona-tokubackup
github.com:percona/tokudb-backup-plugin
These two repo's need to be checked out and built with the mariadb server source. Here is an example on how to build the tokudb backup plugin into mariadb 10.1:
popd
popd
Need to preload the hot backup library:
Here is the user interface:
MariaDB [(none)]> show variables like 'version';
+---------------+----------------------+
| Variable_name | Value |
+---------------+----------------------+
| version | 10.1.8-MariaDB-debug |
+---------------+----------------------+
1 row in set (0.00 sec)
MariaDB [(none)]> show variables like 'tokudb_backup%';
+---------------------------------+-----------------------------------+
| Variable_name | Value |
+---------------------------------+-----------------------------------+
| tokudb_backup_allowed_prefix | |
| tokudb_backup_dir | |
| tokudb_backup_exclude | |
| tokudb_backup_last_error | 0 |
| tokudb_backup_last_error_string | |
| tokudb_backup_plugin_version | |
| tokudb_backup_throttle | 18446744073709551615 |
| tokudb_backup_version | tokubackup 1.2 $Revision: 56100 $ |
+---------------------------------+-----------------------------------+