主页 / dba / 问题 / 121517
Accepted
atxdba
Asked: 2015-11-19 12:39:49 +0800 CST

Tokudb热备份

  • 772

我正在尝试为 percona 的 tokudb 引擎评估最新的 tokudb Hotbackup。

此安装在 debian (Ubuntu 14) 下

我能够在没有错误的情况下安装所有软件包，并安装所有基本的 toku 插件。

尝试安装我得到的备用插头

mysql> install plugin tokudb_backup soname 'tokudb_backup.so';
ERROR 1126 (HY000): Can't open shared library '/usr/lib/mysql/plugin/tokudb_backup.so' (errno: 2 /usr/lib/mysql/plugin/tokudb_backup.so: undefined symbol: tokubackup_version_string)

mysql> select @@version;
+-------------+
| @@version   |
+-------------+
| 5.6.27-75.0 |
+-------------+
1 row in set (0.00 sec)

mysql> select @@tokudb_version;
+------------------+
| @@tokudb_version |
+------------------+
| 5.6.27-75.0      |
+------------------+
1 row in set (0.00 sec)

*编辑评论：*

该文件确实存在于文件系统中

# ls -l /usr/lib/mysql/plugin/tokudb_backup.so
-rw-r--r-- 1 root root 23736 Nov  3 05:30 /usr/lib/mysql/plugin/tokudb_backup.so

我怎样才能安装这个？

backup percona-server

2 个回答

  1. Best Answer

    安装 Percona TokuBackup：

    运行ps_tokudb_admin --enable-backup以将 preload-hotbackup 选项添加到 my.cnf 的 [mysqld_safe] 部分。

    $ sudo ps_tokudb_admin --enable-backup
Checking SELinux status...
INFO: SELinux is disabled.

Checking if preload-hotbackup option is already set in config file...
INFO: Option preload-hotbackup is not set in the config file.

Checking TokuBackup plugin status...
INFO: TokuBackup plugin is not installed.

Adding preload-hotbackup option into /etc/my.cnf
INFO: Successfully added preload-hotbackup option into /etc/my.cnf
PLEASE RESTART MYSQL SERVICE AND RUN THIS SCRIPT AGAIN TO FINISH INSTALLATION!

    重启mysql服务

    $ sudo service mysql restart

    再次运行ps_tokudb_admin --enable-backup完成TokuBackup插件的安装

    $ sudo ps_tokudb_admin --enable-backup
Checking SELinux status...
INFO: SELinux is disabled.

Checking if preload-hotbackup option is already set in config file...
INFO: Option preload-hotbackup is set in the config file.

Checking TokuBackup plugin status...
INFO: TokuBackup plugin is not installed.

Checking if Percona Server is running with libHotBackup.so preloaded...
INFO: Percona Server is running with libHotBackup.so preloaded.

Installing TokuBackup plugin...
INFO: Successfully installed TokuBackup plugin.
    • 3

  2. 我认为，这是权限问题。你的错误：

    ERROR 1126 (HY000): Can't open shared library

    您的插件文件权限：

    # ls -l /usr/lib/mysql/plugin/tokudb_backup.so
-rw-r--r-- 1 root root 23736 Nov  3 05:30 /usr/lib/mysql/plugin/tokudb_backup.so

    用户 mysql - 没有执行插件的权限

    与其他插件对比（安装后默认权限）：

    [tech@XXX ~]$ ls -l /usr/lib64/mysql/plugin
total 2512
-rwxr-xr-x 1 root root  27932 Jul 15 00:47 adt_null.so
-rwxr-xr-x 1 root root  38471 Jul 15 00:47 auth.so
-rwxr-xr-x 1 root root  25887 Jul 15 00:47 auth_socket.so
    • 0

相关问题