IEE Database Setup Wizard

RHEL 5 with RPM package, directly installed after the configuration data and cache directory.

Rhel 6 with a tar package + configuration file, this article is a wizard that installs IEE on Rhel 6.

① uploading Infobright-4.0.6-x86_64.tar packages and configuration files My-ib.cnf,mysqld-ib to any directory on the server② Unpack The tar package, move to the/usr/local/directory, and move the configuration files to the/etc/directory,/etc/init.d/directory

tar -xvf infobright-4.0. 6-x86_64. Tar MV infobright-4.0. 6-x86_64/usr/local/mv my-ib.cnf/etc/mv mysqld-ib/etc/init.d/chmod u+x/etc/ Init.d/mysqld-ib

③ Start IEE Service, turn off IEE service

-- start IEE service /etc/init.d/mysqld-IB start-- close IEE service /etc/init.d/mysqld-ib stop

④ Create a shortcut to the IEE Database command line interface Mysql-ib

LN -s/usr/local/infobright-4.0. 6

⑤ configuration changes the data directory and cache directory of the IEE database (operation when the IEE service is off)

# pwd (cut to software catalog)

/usr/local/infobright-4.0. 6-x86_64

#./postconfig.sh (The first time you run postconfig.sh, change the data directory of the IEE database)

infobright Post Configuration--------------------------------------Using Postconfig You can:--------------------------------------(1) Move Existing data directory to other location, (2Move Existing cache directory to the other location, (3) Configure server socket, (4) Configure server port, (5) relocate DataDir path to an existing data directory. Please type'y'  foroption that you want or press CTRL + C forexit. Current configuration:--------------------------------------Current configfile: [/etc/my-IB.CNF] Current Brighthouse.inifile: [/usr/local/infobright-4.0.6-x86_64/data/Brighthouse.ini] Current DataDir: [/usr/local/infobright-4.0.6-x86_64/Data] Current CachefolderinchBrighthouse.inifile: [/usr/local/infobright-4.0.6-x86_64/Cache] Current socket: [/tmp/mysql-Ib.sock] Current port: [5029]--------------------------------------(1Want to copy the current DataDir [/usr/local/infobright-4.0.6-x86_64/data] to a new location? [y/n]:ygive new datadir path (e.g./opt/datadirnewpath/data):/ieedata/Data (2Option to change Cachefolder was disabled when option1Is chosen!(3Does you want to change the current socket [/tmp/mysql-ib.sock]? [y/N]:n (4Do you want the change of current port [5029]? [y/N]:n (5) relocation is disabled when options1-4is chosen!--------------------------------------DataDir (/usr/local/infobright-4.0.6-x86_64/data) is going to be copied to/ieedata/Data--------------------------------------Confirm to proceed? [y/n]:ycopying/usr/local/infobright-4.0.6-x86_64/data To/ieedata/data ... is Done. You can now remove/backup your old/usr/local/infobright-4.0.6-x86_64/data ... Done!

# ./postconfig.sh(second run postconfig.sh, changing the cache directory of the IEE database)

infobright Post Configuration--------------------------------------Using Postconfig You can:--------------------------------------(1) Move Existing data directory to other location, (2Move Existing cache directory to the other location, (3) Configure server socket, (4) Configure server port, (5) relocate DataDir path to an existing data directory. Please type'y'  foroption that you want or press CTRL + C forexit. Current configuration:--------------------------------------Current configfile: [/etc/my-IB.CNF] Current Brighthouse.inifile: [/ieedata/data/Brighthouse.ini] Current DataDir: [/ieedata/Data] Current CachefolderinchBrighthouse.inifile: [/usr/local/infobright-4.0.6-x86_64/Cache] Current socket: [/tmp/mysql-Ib.sock] Current port: [5029]--------------------------------------(1Want to copy current DataDir [/ieedata/data] to a new location? [y/N]:n (2Want to move the current Cachefolder [/usr/local/infobright-4.0.6-x86_64/cache] to a new location? [y/n]:y Give New cachefolder path:/ieedata/Cache (3Does you want to change the current socket [/tmp/mysql-ib.sock]? [y/N]:n (4Do you want the change of current port [5029]? [y/N]:n (5) relocation is disabled when options1-4is chosen!--------------------------------------New Cachefolder is going/ieedata/Cache--------------------------------------Confirm to proceed? [y/n]:ycreating New Cachedir/ieedata/cache ... is Done. Done!

⑥ Start the IEE service, enter the database command line, give the root user of the IEE database all permissions, the password is initialized to 123456# /etc/init.d/mysqld-ib start # Mysql-ib

Welcome to the MySQL Monitor. Commands End With; or \g.your MySQL connectionIDIs3Server Version:5.1. +Build number (revision) =ib_4.0.6_r16086_16275 (IEE-commercial) (Static) Type'Help ;'Or'\h'  forHelp. Type'\c'ToClearThe current input statement.mysql> Grant all privileges on * * to'Root'@'%'Identified by'123456'With GRANT OPTION; Query OK,0Rows Affected (0.00sec) MySQL>flush Privileges; Query OK,0Rows Affected (0.00sec) MySQL>

⑦ users use the Navicate tool to connect to the IEE database, build tables, and select the character set Utf-8:

Character Set:utf8--utf-8  unicodecollation:utf8_bin

IEE Database Setup Wizard