Tokudb 熱備份

我試圖為 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

我怎樣才能安裝這個？

要安裝 Percona TokuBackup：

執行ps_tokudb_admin --enable-backup以將 preload-hotbackup 選項添加到

$$ mysqld_safe $$my.cnf 的部分。

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

引用自：https://dba.stackexchange.com/questions/121517