TokuDB熱備測(cè)試
1、啟動(dòng)后嘗試安裝TokuDB插件
創(chuàng)新互聯(lián)是一家專業(yè)從事成都網(wǎng)站建設(shè)、成都做網(wǎng)站的網(wǎng)絡(luò)公司。作為專業(yè)的建站公司,創(chuàng)新互聯(lián)依托的技術(shù)實(shí)力、以及多年的網(wǎng)站運(yùn)營(yíng)經(jīng)驗(yàn),為您提供專業(yè)的成都網(wǎng)站建設(shè)、營(yíng)銷型網(wǎng)站及網(wǎng)站設(shè)計(jì)開發(fā)服務(wù)！
[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
文章標(biāo)題：TokuDB熱備測(cè)試
URL分享：http://www.rwnh.cn/article2/gpoioc.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供Google、網(wǎng)站制作、App開發(fā)、定制開發(fā)、ChatGPT、微信公眾號(hào)
聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)
- 網(wǎng)站建設(shè)的時(shí)候應(yīng)該選擇靜態(tài)頁(yè)面還是動(dòng)態(tài)頁(yè)面 2016-10-30
- 靜態(tài)HTML真的非常有利于SEO嗎？ 2016-07-10
- 為什么seo都建議大家做靜態(tài)頁(yè)面? 2013-07-27
- 網(wǎng)站建設(shè)中有關(guān)靜態(tài)頁(yè)面和動(dòng)態(tài)頁(yè)面的區(qū)分 2016-10-11
- SEO優(yōu)化中動(dòng)態(tài)頁(yè)面、靜態(tài)頁(yè)面和偽靜態(tài)頁(yè)面哪個(gè)好？ 2015-01-31
- 成都網(wǎng)站建設(shè)-偽靜態(tài)有什么用 2014-09-20
- 動(dòng)態(tài)網(wǎng)站，靜態(tài)網(wǎng)站，偽靜態(tài)網(wǎng)站有什么區(qū)別？ 2021-01-30
- 做網(wǎng)站的時(shí)候是制作動(dòng)態(tài)網(wǎng)站好還是制作靜態(tài)網(wǎng)站好呢？ 2016-11-14
- 所謂動(dòng)態(tài)網(wǎng)站和靜態(tài)網(wǎng)站的兩種解釋 2020-04-22
- 企業(yè)應(yīng)選擇靜態(tài)網(wǎng)站，還是動(dòng)態(tài)網(wǎng)站設(shè)計(jì)？ 2016-08-11
- 成都SEO優(yōu)化：動(dòng)態(tài)URL和靜態(tài)URL那種更利于網(wǎng)站優(yōu) 2016-11-14
- 成都網(wǎng)站建設(shè)公司告訴你什么叫靜態(tài)網(wǎng)頁(yè) 2015-02-21