MySQL infobright的安装步骤
来源:脚本之家
时间:2023-01-07 18:22:01 394浏览 收藏
知识点掌握了,还需要不断练习才能熟练运用。下面golang学习网给大家带来一个数据库开发实战,手把手教大家学习《MySQL infobright的安装步骤》,在实现功能的过程中也带大家重新温习相关知识点,温故而知新,回头看看说不定又有不一样的感悟!
整个安装过程过了一遍,感觉跟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/目录下面,如果有其他目录,则可以使用其他目录进行解压,解压后的文件如下:
[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、根据最后一行提示,激活infobright server,运行脚本./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/.
第一次运行的时候,会提醒是否注册,选择N,不注册,此时再次运行这个脚本:
[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!
此时安装包会提示是否修改相关的目录,按照自己的需求去修改,我这里只是简单的改了下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里面,查看初始化好的文件。
[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、启动服务。安装完软件之后,使用自带的工具/etc/init.d/mysqld-ib启动服务,启动完之后可以查看相关进程,启动方法和进程查看方法如下:
[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、创建root用户的密码,这一步和mysql很像,使用/usr/local/infobright/bin/mysqladmin创建密码,方法如下:
[root@tk01-dba-mysql bin]# ./mysqladmin -uroot password '123456' Warning: ./mysqladmin: unknown variable 'loose-local-infile=1'
6、连接数据库,连接方法:
[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)
如果不设置进入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的安装步骤》的内容了。个人认为,基础知识的学习和巩固,是为了更好的将其运用到项目中,欢迎关注golang学习网公众号,带你了解更多关于mysql的知识点!
-
318 收藏
-
358 收藏
-
186 收藏
-
269 收藏
-
275 收藏
-
475 收藏
-
266 收藏
-
273 收藏
-
283 收藏
-
210 收藏
-
371 收藏
-
- 前端进阶之JavaScript设计模式
- 设计模式是开发人员在软件开发过程中面临一般问题时的解决方案,代表了最佳的实践。本课程的主打内容包括JS常见设计模式以及具体应用场景,打造一站式知识长龙服务,适合有JS基础的同学学习。
- 立即学习 542次学习
-
- GO语言核心编程课程
- 本课程采用真实案例,全面具体可落地,从理论到实践,一步一步将GO核心编程技术、编程思想、底层实现融会贯通,使学习者贴近时代脉搏,做IT互联网时代的弄潮儿。
- 立即学习 507次学习
-
- 简单聊聊mysql8与网络通信
- 如有问题加微信:Le-studyg;在课程中,我们将首先介绍MySQL8的新特性,包括性能优化、安全增强、新数据类型等,帮助学生快速熟悉MySQL8的最新功能。接着,我们将深入解析MySQL的网络通信机制,包括协议、连接管理、数据传输等,让
- 立即学习 497次学习
-
- JavaScript正则表达式基础与实战
- 在任何一门编程语言中,正则表达式,都是一项重要的知识,它提供了高效的字符串匹配与捕获机制,可以极大的简化程序设计。
- 立即学习 487次学习
-
- 从零制作响应式网站—Grid布局
- 本系列教程将展示从零制作一个假想的网络科技公司官网,分为导航,轮播,关于我们,成功案例,服务流程,团队介绍,数据部分,公司动态,底部信息等内容区块。网站整体采用CSSGrid布局,支持响应式,有流畅过渡和展现动画。
- 立即学习 484次学习
-
- 直率的夕阳
- 这篇文章内容太及时了,大佬加油!
- 2023-07-13 05:21:30
-
- 害羞的电灯胆
- 细节满满,码起来,感谢作者的这篇技术贴,我会继续支持!
- 2023-05-06 00:50:03
-
- 纯情的热狗
- 很棒,一直没懂这个问题,但其实工作中常常有遇到...不过今天到这,帮助很大,总算是懂了,感谢师傅分享文章!
- 2023-04-17 21:45:49
-
- 干净的蚂蚁
- 受益颇多,一直没懂这个问题,但其实工作中常常有遇到...不过今天到这,看完之后很有帮助,总算是懂了,感谢作者分享文章内容!
- 2023-04-06 03:41:37
-
- 听话的鞋垫
- 这篇技术文章太及时了,太全面了,写的不错,收藏了,关注作者了!希望作者能多写数据库相关的文章。
- 2023-03-15 10:30:07
-
- 迷人的金针菇
- 这篇技术文章真及时,好细啊,很有用,已收藏,关注大佬了!希望大佬能多写数据库相关的文章。
- 2023-03-13 18:16:31
-
- 怡然的小甜瓜
- 太详细了,已收藏,感谢作者大大的这篇技术文章,我会继续支持!
- 2023-01-09 03:00:26