MySQL Infobright warehouse Installation

Infobright is an open source Data Warehouse (Datawarehouse) solution, which is based on a columnstore engine that enables massive data storage with a high data compression ratio of 10:1,40:1 or even larger, depending on data repeatability, The data type and the distribution state of the data on the disk. can achieve high-speed data loading performance: A variety of data import methods, simple syntax, and has an optimized statistical algorithm (Sum/group/count ...) : In the case of manual distribution of dynamic Data, static tables need to be designed, involving additional work, modifying code, etc. Infobright does not involve similar issues when importing

Infobright in the application of the advantages of the outstanding: for example, there is no complex Data warehouse model design requirements (such as star model, snowflake model), the application of Infobright can save the design cost, do not need materialized view, data partition, index establishment, save storage resources; High compression ratio is typically 10 : 1, some applications may reach 40:1, integration is widely used, and many bi suites are compatible, such as Pentaho, Cognos, jaspersof

Reduce operation and maintenance cost; With the increasing of database, the performance of query and loading is stable, the implementation and management is simple and requires very little management; it is the first commercially supported open source warehousing Analysis database and the ORACLE/MYSQL is the official recommended warehousing integration architecture.

Infobright Application Cases

Infobright scenarios include: Analysis and application of large data volumes, web/online analysis, mobile analytics (word analysis), Customer behavior analysis (supermarket purchase of hot goods statistics, etc.), analysis of marketing and advertising, log/Event management systems, telecom detailed analysis and reporting, System/network security certification records (logging , event logging, Data Mart, enterprise-specific data warehousing, data warehousing for SMEs, embedded analytics, embedded analytics for independent software vendors/SaaS vendors ...

infobright-4.0.7 requires more than boost_1_42 version, so install boost first, compile and install for a long time

cd/home/data/
wgetHttp://downloads.sourceforge.net/project/boost/boost/1.43.0/boost_1_43_0.tar.gz 
Tar-xzf boost_1_43_0.tar.gz
CD Boost_1_43_0
./bootstrap.sh--prefix=/usr/local/boost
Yum Install Python-devel
./bjam Install
Export Boost_root=/usr/local/boost
echo "/usr/local/boost/lib" >/etc/ld.so.conf.d/boost-x86_64.conf
Ldconfig
CD..

Installing infobright-4.0.7

wgethttp://www.infobright.org/downloads/ice/infobright-4.0.7-0-src-ice.tar.gz 
Tar-xzf infobright-4.0.7-0-src-ice.tar.gz
CD infobright-4.0.7
Make prefix=/usr/local/infobright edition=community release
Make prefix=/usr/local/infobright edition=community install-release
mkdir-p/usr/local/infobright/conf/usr/local/infobright/logs/data/infobright/data
chown-r Mysql.mysql/usr/local/infobright/conf/usr/local/infobright/logs/data/infobright/data
CP src/build/pkgmt/my-ib.cnf/usr/local/infobright/conf/my-ib.cnf
/usr/local/infobright/bin/mysql_install_db--basedir=/usr/local/infobright--datadir=/data/infobright/data-- User=mysql
vim/usr/local/infobright/conf/my-ib.cnf

grep -v ^\# /usr/local/infobright/conf/my-ib.cnf|sed  '/^$/d ' [client]port= 3307socket=  /tmp/mysql-ib.sockloose-local-infile=1[mysqld]basedir = /usr/local/infobrightdatadir =  /data/infobright/datalog-error = /usr/local/infobright/var/bh.errlog-output =  Fileport= 3307socket= /tmp/mysql-ib.sockskip-lockingkey_buffer = 16mmax_allowed_packet  = 500mtable_cache = 16sort_buffer_size = 1mread_buffer_size = 1mread_ Rnd_buffer_size = 4mmyisam_sort_buffer_size = 8mnet_buffer_length = 8kthread_ Cache_size = 32thread_stack = 512kquery_cache_size = 8mquery_cache_type=0thread_ Concurrency = 8 server-id=1 default-storage-engine=brighthousecollation_server=latin1_ BINCHARACTER_SET_SERVER=LATIN1[MYSQLDUMP]QUICKMAX_ALLOWED_PACKET = 16M[MYSQL]NO-AUTO-REHASH[ISAMCHK] Key_buffer = 32msort_buffer_size = 32mread_buffer = 1mwrite_buffer = 1m[myisamchk]key_buffer =  32msort_buffer_size = 32mread_buffer = 1mwrite_buffer = 1m[mysqlhotcopy] interactive-timeout[mysql-test]host=localuser=rootport=5029database=dktestcase-timeout=3600

< Span style= "FONT-SIZE:16PX;" >mkdir/usr/local/ infobright/var 
/usr/local/infobright/ Bin/mysqld_safe--defaults-file=/usr/local/infobright/conf/my-ib.cnf--user=mysql >/dev/null 2>&1 &  
ps Aux|grep mysql 

Root 809 0.0 0.1 106064 1492 pts/0 T 10:05 0:00/bin/sh/usr/local/infobright/bin/mysqld_safe--defaults- FILE=/USR/LOCAL/INFOBRIGHT/CONF/MY-IB.CNF--user=mysql

MySQL 938 0.0 3.1 849624 32048 pts/0 Sl 10:05 0:00/usr/local/infobright/libexec/mysqld--defaults-file=/usr /LOCAL/INFOBRIGHT/CONF/MY-IB.CNF--basedir=/usr/local/infobright--datadir=/data/infobright/data--user=mysql-- Log-error=/usr/local/infobright/var/bh.err--pid-file=/data/infobright/data/localhost.localdomain.pid--socket=/ Tmp/mysql-ib.sock--port=3307

/usr/local/infobright/bin/mysqladmin-u root Password "123456"
/usr/local/infobright/bin/mysql-uroot-p 123456

This article is from "Back on the Swallow's blog" blog, please be sure to keep this source http://bbotte.blog.51cto.com/6205307/1559644

MySQL Infobright warehouse Installation