IEE Database Installation Wizard

IEE Database Installation Wizard

RHEL 5 uses an rpm package to directly install the package and configure the data and cache directory.

RHEL 6 uses the tar package + configuration file. This article is a wizard for installing IEE on RHEL 6.

Upload infobright-4.0.6-x86_64.tar package and configuration file my-ib.cnf, mysqld-ib to any directory on the server ② decompress the tar package, move to the/usr/local/directory, the configuration file respectively to the/etc/directory, /etc/init. d/directory

tar -xvf infobright-4.0.6-x86_64.tarmv 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 the IEE service and disable the IEE Service

-- Start IEE service/etc/init. d/mysqld-ib start -- disable IEE service/etc/init. d/mysqld-ib stop

④ Create a shortcut to enter the command line interface of the IEE database mysql-ib

ln -s /usr/local/infobright-4.0.6-x86_64/bin/mysql /usr/local/bin/mysql-ib 

⑤ Configure and change the data directory and cache directory of the IEE database (when the IEE service is disabled) # pwd (switch to the Software Directory)

/usr/local/infobright-4.0.6-x86_64

#./Postconfig. sh (first run postconfig. sh to change the data directory of the IEE database)

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.6-x86_64/data/brighthouse.ini]Current datadir: [/usr/local/infobright-4.0.6-x86_64/data]Current CacheFolder in brighthouse.ini file: [/usr/local/infobright-4.0.6-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.6-x86_64/data] to a new location? [y/n]:yGive new datadir path (e.g. /opt/datadirnewpath/data):/ieedata/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.6-x86_64/data) is going to be copied to /ieedata/data--------------------------------------Please 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 (run postconfig. sh for the second time to change the cache directory of the IEE database)
 

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: [/ieedata/data/brighthouse.ini]Current datadir: [/ieedata/data]Current CacheFolder in brighthouse.ini file: [/usr/local/infobright-4.0.6-x86_64/cache]Current socket: [/tmp/mysql-ib.sock]Current port: [5029]--------------------------------------(1) Do you want to copy current datadir [/ieedata/data] to a new location? [y/n]:n(2) Do you want to move current CacheFolder [/usr/local/infobright-4.0.6-x86_64/cache] to a new location? [y/n]:y Give new CacheFolder path:/ieedata/cache(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!--------------------------------------New CacheFolder is going to be /ieedata/cache--------------------------------------Please confirm to proceed? [y/n]:yCreating new cachedir /ieedata/cache ...is done.Done!

6. start the IEE service, enter the database command line, and grant all permissions to the root user of the IEE database. 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 connection id is 3Server version: 5.1.40 build number (revision)=IB_4.0.6_r16086_16275(iee - commercial) (static)Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> grant all privileges on *.* to 'root'@'%' identified by '123456'  WITH GRANT OPTION;Query OK, 0 rows affected (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)mysql> 

7. You can use the navicate tool to connect to the IEE database and create databases and tables. The character set is UTF-8:

character set : utf8 -- UTF-8 Unicodecollation : utf8_bin

This article permanently updates the link address: