Details

    Description

      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

      Attachments

        Issue Links

          Activity

            prohaska7 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 $ |
            +---------------------------------+-----------------------------------+
            

            prohaska7 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 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

            colin 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
            leafonsword guo feng added a comment -

            Hope tokubackup comes to MariaDB soon~

            leafonsword guo feng added a comment - Hope tokubackup comes to MariaDB soon~
            BohuTANG 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

            BohuTANG 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
            f_razzoli 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.

            f_razzoli 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.

            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/

            GeoffMontee 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

              serg Sergei Golubchik
              pprkut Heinz Wiesinger
              Votes:
              13 Vote for this issue
              Watchers:
              19 Start 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.