MySQL infobright的安裝步驟

整個安裝過程過瞭一遍,感覺跟MySQL的安裝差不太多。步驟如下:

1、使用”rpm -ivh  安裝包”命令來安裝一下rpm的包,如下:

[[email protected] 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/目錄下面,如果有其他目錄,則可以使用其他目錄進行解壓,解壓後的文件如下:

[[email protected] 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、根據最後一行提示,激活infobright server,運行腳本./postconfig.sh ,如下:

[[email protected] 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/.

第一次運行的時候,會提醒是否註冊,選擇N,不註冊,此時再次運行這個腳本:

[[email protected] 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!

此時安裝包會提示是否修改相關的目錄,按照自己的需求去修改,我這裡隻是簡單的改瞭下data盤的目錄,其他的選項都選擇的是N,這樣最終有一條提示:

Datadir(/usr/local/infobright-4.0.7-x86_64/data) is going to be copied to /data/infobright_5029/data

   一路yes,就安裝完畢瞭。

3、查看data文件。此時進入剛才設定的data目錄,/data/infobright_5029/data裡面,查看初始化好的文件。

[[email protected] 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、啟動服務。安裝完軟件之後,使用自帶的工具/etc/init.d/mysqld-ib啟動服務,啟動完之後可以查看相關進程,啟動方法和進程查看方法如下:

[[email protected] infobright_5029]# /etc/init.d/mysqld-ib start
Starting MySQL. SUCCESS! 
[[email protected] 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
[[email protected] infobright_5029]# 

5、創建root用戶的密碼,這一步和mysql很像,使用/usr/local/infobright/bin/mysqladmin創建密碼,方法如下:

[[email protected] bin]# ./mysqladmin -uroot password '123456'
Warning: ./mysqladmin: unknown variable 'loose-local-infile=1'

6、連接數據庫,連接方法:

[[email protected] 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)

   如果不設置進入infobright的用戶名和密碼,則可以直接使用命令mysql-ib進入上述界面。可以看到,默認的存儲引擎是brighthouse。到這裡,infobright的安裝過程算是全部完成瞭。

7、導入數據。

    社區版的目前隻能通過load data的方法進行數據導入,語法如下:

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,...)]

其中有很多關鍵字信息,這裡解釋一些重要的:

  • LOW_PRIORITY關鍵字

   如果load data語句使用瞭LOW_PRIORITY關鍵字,則在碰到其他會話操作相同表時,則會延遲執行LOAD DATA語句,直到其他會話操作表結束為止。

  • replace和ignore關鍵字

 控制對現有的唯一鍵記錄的重復的處理。如果你指定replace,新行將代替有相同的唯一鍵值的現有行。如果你指定ignore,跳過有唯一鍵的現有行的重復行的輸入。

  • fields關鍵字

指定瞭文件字段的分割格式:

  • terminated by關鍵字

以什麼字符作為分隔符;

  • enclosed by

字段括起字符;

  • lines

指定瞭每條記錄的分隔符默認為’\n’即為換行符;

   更多信息,請參考官方文檔。

   現在我們生成一個文本,然後寫入數據:

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)

   最終,所有的數據都導入瞭。大傢可以嘗試用這種方法導入大量的數據,然後對infobright的查詢性能進行評估。

以上就是MySQL infobright的安裝步驟的詳細內容,更多關於MySQL infobright的安裝的資料請關註WalkonNet其它相關文章!