溫馨提示×
您好，登錄后才能下訂單哦！
點(diǎn)擊 登錄注冊(cè) 即表示同意《億速云用戶服務(wù)條款》
您好，登錄后才能下訂單哦！
1、啟動(dòng)后嘗試安裝TokuDB插件
[root@es3?mysql]#?export?PATH=$PATH:/usr/local/mysql/bin [root@es3?mysql]#?ps_tokudb_admin??-h227.0.0.1?--enable Checking?SELinux?status... INFO:?SELinux?is?disabled. Checking?location?of?jemalloc?library?... INFO:?Using?jemalloc?library?from?/usr/lib64/libjemalloc.so.1 Checking?transparent?huge?pages?status?on?the?system... INFO:?Transparent?huge?pages?are?enabled?(should?be?disabled). Checking?if?THP_SETTING?variable?is?set?to?never?or?madvise?in?/etc/sysconfig/mysql... INFO:?Variable?THP_SETTING?is?not?set?to?never?or?madvise?in?/etc/sysconfig/mysql. Checking?if?LD_PRELOAD?variable?is?set?for?libjemalloc.so.1?in?/etc/sysconfig/mysql... INFO:?Variable?LD_PRELOAD?for?libjemalloc.so.1?is?set?in?/etc/sysconfig/mysql. Checking?TokuDB?engine?plugin?status... INFO:?TokuDB?engine?plugin?is?not?installed. Disabling?transparent?huge?pages?for?the?current?session... INFO:?Successfully?disabled?transparent?huge?pages?for?this?session. Adding?THP_SETTING=never?variable?into?/etc/sysconfig/mysql INFO:?Successfully?added?THP_SETTING=never?option?into?/etc/sysconfig/mysql Installing?TokuDB?engine... 2019-08-27T08:51:36.877238Z?5?[ERROR]?TokuDB?is?not?initialized?because?jemalloc?is?not?loaded 2019-08-27T08:51:36.877264Z?5?[ERROR]?Plugin?'TokuDB'?init?function?returned?error. 2019-08-27T08:51:36.877279Z?5?[ERROR]?Plugin?'TokuDB'?registration?as?a?STORAGE?ENGINE?failed. 2019-08-27T08:51:36.877307Z?5?[Note]?Shutting?down?plugin?'TokuDB' ERROR:?Failed?to?install?TokuDB?engine?plugin.?Please?check?error?log.
2、添加jemalloc 后
[root@es3?lib]#?sh?/usr/local/mysql/support-files/mysql.server?start ????????????????????????????????????????????????????????????????????????????????? [root@es3?support-files]#?ps_tokudb_admin??-h227.0.0.1?--enable Checking?SELinux?status... INFO:?SELinux?is?disabled. Checking?if?Percona?Server?is?running?with?jemalloc?enabled... INFO:?Percona?Server?is?running?with?jemalloc?enabled. Checking?transparent?huge?pages?status?on?the?system... INFO:?Transparent?huge?pages?are?currently?disabled?on?the?system. Checking?if?thp-setting=never?option?is?already?set?in?config?file... INFO:?Option?thp-setting=never?is?not?set?in?the?config?file. ??????(needed?only?if?THP?is?not?disabled?permanently?on?the?system) Checking?TokuDB?engine?plugin?status... INFO:?TokuDB?engine?plugin?is?not?installed. Adding?thp-setting=never?option?into?/etc/my.cnf INFO:?Successfully?added?thp-setting=never?option?into?/etc/my.cnf Installing?TokuDB?engine... INFO:?Successfully?installed?TokuDB?engine?plugin.
3、安裝熱備插件
[root@es3?support-files]#?ps_tokudb_admin??-h227.0.0.1?--enable-backup Checking?SELinux?status... INFO:?SELinux?is?disabled. Checking?if?Percona?Server?is?running?with?jemalloc?enabled... INFO:?Percona?Server?is?running?with?jemalloc?enabled. Checking?transparent?huge?pages?status?on?the?system... INFO:?Transparent?huge?pages?are?currently?disabled?on?the?system. Checking?if?thp-setting=never?option?is?already?set?in?config?file... INFO:?Option?thp-setting=never?is?set?in?the?config?file. Checking?if?preload-hotbackup?option?is?already?set?in?config?file... INFO:?Option?preload-hotbackup?is?not?set?in?the?config?file. Checking?TokuDB?engine?plugin?status... INFO:?TokuDB?engine?plugin?is?installed. 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!
4、啟動(dòng)查看tokudb相關(guān)信息，嘗試備份，并配置關(guān)閉異步IO
innodb_use_native_aio?=0
5、重新運(yùn)行一遍， --enable-backup（PLEASE RESTART MYSQL SERVICE AND RUN THIS SCRIPT AGAIN TO FINISH INSTALLATION!）
[root@es3?lib]#?sh?/usr/local/mysql/support-files/mysql.server?restart Shutting?down?MySQL?(Percona?Server)...?SUCCESS!? Starting?MySQL?(Percona?Server)..?SUCCESS!? [root@es3?lib]#??mkdir?-p?/data/backup/ [root@es3?lib]#??chown?mysql.mysql?-R?/data/backup/ [root@es3?lib]#?mysql?-h227.0.0.1 Welcome?to?the?MySQL?monitor.??Commands?end?with?;?or?\g. Your?MySQL?connection?id?is?3 Server?version:?5.7.17-13?Percona?Server?(GPL),?Release?13,?Revision?fd33d43 Copyright?(c)?2009-2016?Percona?LLC?and/or?its?affiliates Copyright?(c)?2000,?2016,?Oracle?and/or?its?affiliates.?All?rights?reserved. Oracle?is?a?registered?trademark?of?Oracle?Corporation?and/or?its affiliates.?Other?names?may?be?trademarks?of?their?respective owners. Type?'help;'?or?'\h'?for?help.?Type?'\c'?to?clear?the?current?input?statement. mysql>??set?tokudb_backup_dir='/data/backup/'; mysql>?exit Bye [root@es3?lib]#?ps_tokudb_admin??-h227.0.0.1?--enable-backup Checking?SELinux?status... INFO:?SELinux?is?disabled. Checking?if?Percona?Server?is?running?with?jemalloc?enabled... INFO:?Percona?Server?is?running?with?jemalloc?enabled. Checking?transparent?huge?pages?status?on?the?system... INFO:?Transparent?huge?pages?are?currently?disabled?on?the?system. Checking?if?thp-setting=never?option?is?already?set?in?config?file... INFO:?Option?thp-setting=never?is?set?in?the?config?file. Checking?if?preload-hotbackup?option?is?already?set?in?config?file... INFO:?Option?preload-hotbackup?is?set?in?the?config?file. Checking?TokuDB?engine?plugin?status... INFO:?TokuDB?engine?plugin?is?installed. 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.
6、執(zhí)行備份，并觀察
[root@es3?lib]#?mysql?-h227.0.0.1?????????????????????????????? Welcome?to?the?MySQL?monitor.??Commands?end?with?;?or?\g. Your?MySQL?connection?id?is?7 Server?version:?5.7.17-13?Percona?Server?(GPL),?Release?13,?Revision?fd33d43 Copyright?(c)?2009-2016?Percona?LLC?and/or?its?affiliates Copyright?(c)?2000,?2016,?Oracle?and/or?its?affiliates.?All?rights?reserved. Oracle?is?a?registered?trademark?of?Oracle?Corporation?and/or?its affiliates.?Other?names?may?be?trademarks?of?their?respective owners. Type?'help;'?or?'\h'?for?help.?Type?'\c'?to?clear?the?current?input?statement. mysql>??set?tokudb_backup_dir='/data/backup/'; Query?OK,?0?rows?affected?(13.16?sec) mysql>?exit Bye [root@es3?lib]#?cd?/data/backup/ [root@es3?backup]#?ll 總用量?4 drwxr-x---?6?mysql?mysql?4096?8月??27?17:56?mysql_data_dir [root@es3?backup]#?cd?mysql_data_dir/ [root@es3?mysql_data_dir]#?ll 總用量?126896 -rwxr-x--x?1?mysql?mysql???????56?8月??27?17:56?auto.cnf -rwxr-x--x?1?mysql?mysql?????1676?8月??27?17:56?ca-key.pem -rwxr-x--x?1?mysql?mysql?????1083?8月??27?17:56?ca.pem -rwxr-x--x?1?mysql?mysql?????1087?8月??27?17:56?client-cert.pem -rwxr-x--x?1?mysql?mysql?????1680?8月??27?17:56?client-key.pem -rwxr-x--x?1?mysql?mysql????????5?8月??27?17:56?es3.pid -rwxr-x--x?1?mysql?mysql??????292?8月??27?17:56?ib_buffer_pool -rwxr-x--x?1?mysql?mysql?12582912?8月??27?17:57?ibdata1 -rwxr-x--x?1?mysql?mysql?50331648?8月??27?17:56?ib_logfile0 -rwxr-x--x?1?mysql?mysql?50331648?8月??27?17:57?ib_logfile1 -rwxr-x--x?1?mysql?mysql?12582912?8月??27?17:56?ibtmp1 -rwxr-x--x?1?mysql?mysql?????2908?8月??27?17:56?log000000000003.tokulog29 -rwxr-x--x?1?mysql?mysql????23625?8月??27?17:56?mariadb.log drwxr-x--x?2?mysql?mysql?????4096?8月??27?17:56?mysql -rwxr-x--x?1?mysql?mysql????????5?8月??27?17:56?mysql.sock.lock drwxr-x--x?2?mysql?mysql?????8192?8月??27?17:56?performance_schema -rwxr-x--x?1?mysql?mysql?????1680?8月??27?17:56?private_key.pem -rwxr-x--x?1?mysql?mysql??????452?8月??27?17:56?public_key.pem -rwxr-x--x?1?mysql?mysql?????1087?8月??27?17:56?server-cert.pem -rwxr-x--x?1?mysql?mysql?????1676?8月??27?17:56?server-key.pem drwxr-x--x?2?mysql?mysql?????8192?8月??27?17:56?sys -rwxr-x--x?1?mysql?mysql????24576?8月??27?17:56?tc.log drwxr-x--x?2?mysql?mysql???????60?8月??27?17:56?tktest -rwxr-x--x?1?mysql?mysql????16384?8月??27?17:56?tokudb.directory -rwxr-x--x?1?mysql?mysql????16384?8月??27?17:56?tokudb.environment -rwxr-x--x?1?mysql?mysql????????0?8月??27?17:56?__tokudb_lock_dont_delete_me_data -rwxr-x--x?1?mysql?mysql????????0?8月??27?17:56?__tokudb_lock_dont_delete_me_environment -rwxr-x--x?1?mysql?mysql????????0?8月??27?17:56?__tokudb_lock_dont_delete_me_logs -rwxr-x--x?1?mysql?mysql????????0?8月??27?17:56?__tokudb_lock_dont_delete_me_recovery -rwxr-x--x?1?mysql?mysql????????0?8月??27?17:56?__tokudb_lock_dont_delete_me_temp -rwxr-x--x?1?mysql?mysql????16384?8月??27?17:56?tokudb.rollback -rwxr-x--x?1?mysql?mysql??3932160?8月??27?17:56?xb_doublewrite
免責(zé)聲明：本站發(fā)布的內(nèi)容（圖片、視頻和文字）以原創(chuàng)、轉(zhuǎn)載和分享為主，文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱：is@yisu.com進(jìn)行舉報(bào)，并提供相關(guān)證據(jù)，一經(jīng)查實(shí)，將立刻刪除涉嫌侵權(quán)內(nèi)容。
億速云公眾號(hào)
手機(jī)網(wǎng)站二維碼
