MySQL infobright的安裝步驟
更新時(shí)間：2021年04月07日 11:16:21 作者：AsiaYe
這篇文章主要介紹了MySQL infobright的安裝步驟，幫助大家更好的理解和學(xué)習(xí)使用MySQL，感興趣的朋友可以了解下
整個(gè)安裝過程過了一遍，感覺跟MySQL的安裝差不太多。步驟如下：
1、使用"rpm -ivh 安裝包"命令來安裝一下rpm的包，如下：
[root@tk01-dba-mysql dba_mysql]# rpm -ivh infobright-4.0.7-0-x86_64-ice.rpm --prefix=/usr/local Preparing... ################################# [100%] Installing infobright 4.0.7-0 (x86_64) The installer will generate /tmp/ib4.0.7-0-install.log install trace log. Updating / installing... 1:infobright-4.0.7-0 ################################# [100%] Creating/Updating datadir and cachedir Creating user mysql and group mysql Installing default databases Installing MySQL system tables... OK Filling help tables... OK To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /usr/local/infobright-4.0.7-x86_64/bin/mysqladmin -u root password 'new-password' /usr/local/infobright-4.0.7-x86_64/bin/mysqladmin -u root -h tk01-dba-mysql-7-197 password 'new-password' Alternatively you can run: /usr/local/infobright-4.0.7-x86_64/bin/mysql_secure_installation which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers. See the manual for more instructions. You can start the MySQL daemon with: cd /usr/local/infobright-4.0.7-x86_64 ; /usr/local/infobright-4.0.7-x86_64/bin/mysqld_safe & You can test the MySQL daemon with mysql-test-run.pl cd /usr/local/infobright-4.0.7-x86_64/mysql-test ; perl mysql-test-run.pl Please report any problems with the /usr/local/infobright-4.0.7-x86_64/scripts/mysqlbug script! The latest information about MySQL is available at http://www.mysql.com/ Support MySQL by buying support/licenses from http://shop.mysql.com/ System Physical memory: 15866(MB) Infobright optimal ServerMainHeapSize is set to 6000(MB) Infobright optimal LoaderMainHeapSize is set to 800(MB) Infobright server installed into folder /usr/local/infobright Installation log file /tmp/ib4.0.7-0-install.log -------------------------------------- To activate infobright server, please run ./postconfig.sh script from /usr/local/infobright-4.0.7-x86_64. Example command: cd /usr/local/infobright-4.0.7-x86_64; ./postconfig.sh
我這里是將文件解壓到了/usr/local/目錄下面，如果有其他目錄，則可以使用其他目錄進(jìn)行解壓，解壓后的文件如下：
[root@tk01-dba-mysql local]# ll total 54932 drwxr-xr-x. 2 root root 20 Oct 11 11:45 bin drwxr-xr-x 8 root root 297 Sep 27 09:10 cma_tcollector drwxr-xr-x. 2 root root 6 Apr 11 2018 etc drwxr-xr-x. 2 root root 6 Apr 11 2018 games drwxr-xr-x. 2 root root 6 Apr 11 2018 include lrwxrwxrwx 1 root root 34 Oct 15 21:42 infobright -> /usr/local/infobright-4.0.7-x86_64 -rw-r--r-- 1 root root 56249223 Oct 15 21:30 infobright-4.0.7-0-x86_64-ice.rpm drwxr-xr-x 11 root root 252 Oct 15 21:42 infobright-4.0.7-x86_64
2、根據(jù)最后一行提示，激活infobright server，運(yùn)行腳本./postconfig.sh ，如下：
[root@tk01-dba-mysql infobright]# ./postconfig.sh Infobright post configuration -------------------------------------- Infobright server activated. -------------------------------------- Register your copy of ICE and receive a free copy of the User Manual (a $50 value) as well as a copy of the Bloor Research Spotlight Report "What's Cool About Columns" which explains the differences and benefits of a columnar versus row database. Registration will require opening an HTTP connection to Infobright, do you wish to register now? [Y/N]: n Register now http://www.infobright.org/Downloads/ICE/.
第一次運(yùn)行的時(shí)候，會(huì)提醒是否注冊(cè)，選擇N，不注冊(cè)，此時(shí)再次運(yùn)行這個(gè)腳本：
[root@tk01-dba-mysql infobright]# ./postconfig.sh Infobright post configuration -------------------------------------- Using postconfig you can: -------------------------------------- (1) Move existing data directory to other location, (2) Move existing cache directory to other location, (3) Configure server socket, (4) Configure server port, (5) Relocate datadir path to an existing data directory. Please type 'y' for option that you want or press ctrl+c for exit. Current configuration: -------------------------------------- Current config file: [/etc/my-ib.cnf] Current brighthouse.ini file: [/usr/local/infobright-4.0.7-x86_64/data/brighthouse.ini] Current datadir: [/usr/local/infobright-4.0.7-x86_64/data] Current CacheFolder in brighthouse.ini file: [/usr/local/infobright-4.0.7-x86_64/cache] Current socket: [/tmp/mysql-ib.sock] Current port: [5029] -------------------------------------- (1) Do you want to copy current datadir [/usr/local/infobright-4.0.7-x86_64/data] to a new location? [y/n]:y Give new datadir path (e.g. /opt/datadirnewpath/data):/data/infobright_5029/data (2) Option to change CacheFolder is disabled when option 1 is chosen! (3) Do you want to change current socket [/tmp/mysql-ib.sock]? [y/n]:n (4) Do you want to change current port [5029]? [y/n]:n (5) Relocation is disabled when options 1-4 are chosen! -------------------------------------- Datadir(/usr/local/infobright-4.0.7-x86_64/data) is going to be copied to /data/infobright_5029/data -------------------------------------- Please confirm to proceed? [y/n]:y Copying /usr/local/infobright-4.0.7-x86_64/data to /data/infobright_5029/data ...is done. You can now remove/backup your old /usr/local/infobright-4.0.7-x86_64/data ... Done!
此時(shí)安裝包會(huì)提示是否修改相關(guān)的目錄，按照自己的需求去修改，我這里只是簡單的改了下data盤的目錄，其他的選項(xiàng)都選擇的是N，這樣最終有一條提示：
Datadir(/usr/local/infobright-4.0.7-x86_64/data) is going to be copied to /data/infobright_5029/data
一路yes，就安裝完畢了。
3、查看data文件。此時(shí)進(jìn)入剛才設(shè)定的data目錄，/data/infobright_5029/data里面，查看初始化好的文件。
[root@tk01-dba-mysql data]# ll total 16 -rw-rw---- 1 mysql mysql 0 Oct 15 21:42 bh.err -rw-r--r-- 1 mysql mysql 1898 Oct 15 21:42 brighthouse.ini -rw-r--r-- 1 mysql mysql 8 Oct 15 21:42 ib_data_version drwxr-xr-x 2 mysql mysql 4096 Oct 15 21:42 mysql drwxr-xr-x 2 mysql mysql 4096 Oct 15 21:42 sys_infobright drwxr-xr-x 2 mysql mysql 6 Oct 15 21:42 test
4、啟動(dòng)服務(wù)。安裝完軟件之后，使用自帶的工具/etc/init.d/mysqld-ib啟動(dòng)服務(wù)，啟動(dòng)完之后可以查看相關(guān)進(jìn)程，啟動(dòng)方法和進(jìn)程查看方法如下：
[root@tk01-dba-mysql infobright_5029]# /etc/init.d/mysqld-ib start Starting MySQL. SUCCESS! [root@tk01-dba-mysql-7-195 infobright_5029]# ps -ef|grep 5029 root 78369 1 0 10:34 pts/1 00:00:00 sudo -u mysql /usr/local/infobright-4.0.7-x86_64/bin/mysqld_safe --defaults-file=/etc/my-ib.cnf --log-queries-not-using-indexes --user=mysql --pid-file=/data/infobright_5029/data/tk01-dba-mysql-7-195.pid mysql 78372 78369 0 10:34 pts/1 00:00:00 /bin/sh /usr/local/infobright-4.0.7-x86_64/bin/mysqld_safe --defaults-file=/etc/my-ib.cnf --log-queries-not-using-indexes --user=mysql --pid-file=/data/infobright_5029/data/tk01-dba-mysql-7-195.pid mysql 78507 78372 0 10:34 pts/1 00:00:00 /usr/local/infobright-4.0.7-x86_64/bin/mysqld --defaults-file=/etc/my-ib.cnf --basedir=/usr/local/infobright-4.0.7-x86_64 --datadir=/data/infobright_5029/data --log-queries-not-using-indexes --log-error=/data/infobright_5029/data/bh.err --pid-file=/data/infobright_5029/data/tk01-dba-mysql-7-195.pid --socket=/tmp/mysql-ib.sock --port=5029 root 78570 68493 0 10:35 pts/1 00:00:00 grep --color=auto 5029 [root@tk01-dba-mysql-7-195 infobright_5029]#
5、創(chuàng)建root用戶的密碼，這一步和mysql很像，使用/usr/local/infobright/bin/mysqladmin創(chuàng)建密碼,方法如下：
[root@tk01-dba-mysql bin]# ./mysqladmin -uroot password '123456' Warning: ./mysqladmin: unknown variable 'loose-local-infile=1'
6、連接數(shù)據(jù)庫，連接方法：
[root@tk01-dba-mysql bin]# mysql-ib -uroot -p123456 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.1.40 build number (revision)=IB_4.0.7_r16961_17249(ice) (static) Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | BH_RSI_Repository | | mysql | | sys_infobright | | test | +--------------------+ 5 rows in set (0.00 sec) mysql> show engines; +-------------+---------+-----------------------------------------------------------+--------------+------+------------+ | Engine | Support | Comment | Transactions | XA | Savepoints | +-------------+---------+-----------------------------------------------------------+--------------+------+------------+ | BRIGHTHOUSE | DEFAULT | Brighthouse storage engine | YES | NO | NO | | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | CSV | YES | CSV storage engine | NO | NO | NO | | MyISAM | YES | Default engine as of MySQL 3.23 with great performance | NO | NO | NO | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | +-------------+---------+-----------------------------------------------------------+--------------+------+------------+ 5 rows in set (0.00 sec)
如果不設(shè)置進(jìn)入infobright的用戶名和密碼，則可以直接使用命令mysql-ib進(jìn)入上述界面?？梢钥吹剑J(rèn)的存儲(chǔ)引擎是brighthouse。到這里，infobright的安裝過程算是全部完成了。
7、導(dǎo)入數(shù)據(jù)。
社區(qū)版的目前只能通過load data的方法進(jìn)行數(shù)據(jù)導(dǎo)入，語法如下：
LOAD DATA [LOW_PRIORITY| CONCURRENT] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE] INTO TABLE tbl_name [FIELDS [TERMINATED BY 'string'] [[OPTIONALLY] ENCLOSED BY 'char'] [ESCAPED BY 'char' ] ] [LINES [STARTING BY 'string'] [TERMINATED BY 'string'] ] [IGNORE number LINES] [(col_name_or_user_var,...)] [SET col_name = expr,...)]
其中有很多關(guān)鍵字信息，這里解釋一些重要的：
- LOW_PRIORITY關(guān)鍵字
如果load data語句使用了LOW_PRIORITY關(guān)鍵字，則在碰到其他會(huì)話操作相同表時(shí)，則會(huì)延遲執(zhí)行LOAD DATA語句，直到其他會(huì)話操作表結(jié)束為止。
- replace和ignore關(guān)鍵字
控制對(duì)現(xiàn)有的唯一鍵記錄的重復(fù)的處理。如果你指定replace，新行將代替有相同的唯一鍵值的現(xiàn)有行。如果你指定ignore，跳過有唯一鍵的現(xiàn)有行的重復(fù)行的輸入。
- fields關(guān)鍵字
指定了文件字段的分割格式：
- terminated by關(guān)鍵字
以什么字符作為分隔符；
- enclosed by
字段括起字符；
- lines
指定了每條記錄的分隔符默認(rèn)為'\n'即為換行符；
更多信息，請(qǐng)參考官方文檔。
現(xiàn)在我們生成一個(gè)文本，然后寫入數(shù)據(jù)：
mysql> use test; Database changed mysql> show tables; +----------------+ | Tables_in_test | +----------------+ | test | +----------------+ 1 row in set (0.00 sec) mysql> load data infile '/tmp/a.txt' ignore into table test character set utf8 fields terminated by ' ' lines terminated by '\n'; Query OK, 4 rows affected (0.04 sec) Records: 4 Deleted: 0 Skipped: 0 Warnings: 0 mysql> system cat /tmp/a.txt 1 aaa 2 bbb 3 ccc 4 ddd mysql> select * from test; +------+-------+ | id | name | +------+-------+ | 1 | aaa | | 2 | bbb | | 3 | ccc | | 4 | ddd | +------+-------+ 4 rows in set (0.00 sec)
最終，所有的數(shù)據(jù)都導(dǎo)入了。大家可以嘗試用這種方法導(dǎo)入大量的數(shù)據(jù)，然后對(duì)infobright的查詢性能進(jìn)行評(píng)估。
以上就是MySQL infobright的安裝步驟的詳細(xì)內(nèi)容，更多關(guān)于MySQL infobright的安裝的資料請(qǐng)關(guān)注腳本之家其它相關(guān)文章！
相關(guān)文章
mysql “ Every derived table must have its own alias”出現(xiàn)錯(cuò)誤解決辦法
這篇文章主要介紹了mysql “ Every derived table must have its own alias”出現(xiàn)錯(cuò)誤解決辦法的相關(guān)資料,需要的朋友可以參考下2017-01-01
MySQL系列數(shù)據(jù)庫設(shè)計(jì)三范式教程示例
這篇文章主要為大家介紹了MySQL系列之?dāng)?shù)據(jù)庫設(shè)計(jì)三范式的教程示例講解，有需要的朋友可以借鑒參考下，希望能夠有所幫助，祝大家多多進(jìn)步2021-10-10
本文主要介紹了mysql判斷查詢條件是否包含某字符串,主要介紹了7種方式,具有一定的參考價(jià)值,感興趣的可以了解一下2023-10-10
MySql創(chuàng)建帶解釋的表及給表和字段加注釋的實(shí)現(xiàn)代碼
這篇文章主要介紹了MySql創(chuàng)建帶解釋的表以及給表和字段加注釋的實(shí)現(xiàn)方法,非常不錯(cuò)，具有參考借鑒價(jià)值，需要的朋友可以參考下2016-12-12
本文主要介紹了MySQL常用登錄命令小結(jié)，文中通過示例代碼介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值，需要的朋友們下面隨著小編來一起學(xué)習(xí)學(xué)習(xí)吧2023-05-05
mysql使用GROUP BY分組實(shí)現(xiàn)取前N條記錄的方法
這篇文章主要介紹了mysql使用GROUP BY分組實(shí)現(xiàn)取前N條記錄的方法,結(jié)合實(shí)例形式較為詳細(xì)的分析了mysql中GROUP BY分組的相關(guān)使用技巧,需要的朋友可以參考下2016-06-06
這篇文章主要介紹了MySql命令,結(jié)合實(shí)例分析了MySQL數(shù)據(jù)庫的創(chuàng)建、連接及增刪改查等各種常用操作的使用方法與相關(guān)注意事項(xiàng),非常具有實(shí)用價(jià)值,需要的朋友可以參考下2015-11-11
MYSQL設(shè)置字段自動(dòng)獲取當(dāng)前時(shí)間的sql語句
整理數(shù)據(jù)庫數(shù)據(jù)，看到好多表都有加create_time和 update_time字段，來記錄數(shù)據(jù)插入的時(shí)間和更新時(shí)間，但是時(shí)間插入是通過代碼來維護(hù)的,這篇文章主要介紹了MYSQL設(shè)置字段自動(dòng)獲取當(dāng)前時(shí)間,需要的朋友可以參考下2023-07-07
物理服務(wù)機(jī)的CPU、內(nèi)存、存儲(chǔ)設(shè)備、連接數(shù)等資源有限，某個(gè)時(shí)段大量連接同時(shí)執(zhí)行操作，會(huì)導(dǎo)致數(shù)據(jù)庫在處理上遇到性能瓶頸。為了解決這個(gè)問題，行業(yè)先驅(qū)門充分發(fā)揚(yáng)了分而治之的思想，對(duì)大庫表進(jìn)行分割2022-01-01
命令行模式下備份、還原 MySQL 數(shù)據(jù)庫的語句小結(jié)
為了安全起見，需要經(jīng)常對(duì)數(shù)據(jù)庫作備份，或者還原,學(xué)會(huì)在命令行模式下備份、還原數(shù)據(jù)庫，還是很有必要2012-11-11