Joinutility seperatorLogin utility separator Infobright.com
   
 
Multiple instance of Infobright?
Posted: 31 July 2009 04:57 AM   Ignore ]  
Newbie
Rank
Total Posts:  20
Joined  2009-06-19

Hi,

    I have installed IEE 3.1 as one instance in my server. I have to install the ICE 3.2 RC1 as another instance, is it possible?
if possible, how to install and config as multiple instance?

Thanks.

S.Ashokkumar.
DBA,
India.

Profile
 
Posted: 31 July 2009 05:06 AM   Ignore ]   [ # 1 ]  
Sr. Member
Avatar
RankRankRankRank
Total Posts:  738
Joined  2008-08-18

write2ashokkumar,

Hello!  It is certainly possible.  I have many multiple installations on my server and run some simultaneously.  The points to address are that the software directory, data directory, cache directory and ports must all be different so as not to conflict with each other.  Assuming you are using the TAR installation on Linux, the help text details these parameters to the installation script and I paste it below:

./install-infobright.sh --help

--datadir=infobright data folder                [--datadir=/usr/local/infobright/data] 
--cachedir=infobright cache folder              [--cachedir=/usr/local/infobright/cache] 
--config=mysql conf file to be created          [--config=/etc/my-ib.cnf] 
--port=infobright server port                   [--port=3306] 
--socket=socket file to be used by this server  [--socket=/tmp/mysql-ib.sock] 
--user=user to be created if not exist          [--user=mysql] 
--group=user group to be created if not exist   [--group=mysql] 
Signature 
Profile
 
Posted: 03 August 2009 07:01 PM   Ignore ]   [ # 2 ]  
Newbie
Rank
Total Posts:  1
Joined  2009-08-03

Hi, Do I need to have multiple instances of MySQL installed for this? Or do I only need to have one? Thanks!

Profile
 
Posted: 03 August 2009 07:10 PM   Ignore ]   [ # 3 ]  
Sr. Member
Avatar
RankRankRankRank
Total Posts:  738
Joined  2008-08-18
dwang - 03 August 2009 07:01 PM

Hi, Do I need to have multiple instances of MySQL installed for this? Or do I only need to have one? Thanks!

Per the previous message:

if possible, how to install and config as multiple instance?

If you wish to have multiple instances, these are the steps to take.  If not, one only needs to perform the upgrade steps and use the previous installation’s already indicated and defined/loaded databases.

Signature 
Profile
 
Posted: 24 October 2009 07:39 AM   Ignore ]   [ # 4 ]  
Newbie
Rank
Total Posts:  1
Joined  2009-10-24

Hi David Lutz! Could you please post the steps. Im really having a hard time with this one..


Regards,
haticia
Disque dur multimedia

Profile
 
Posted: 24 October 2009 09:42 AM   Ignore ]   [ # 5 ]  
Sr. Member
Avatar
RankRankRankRank
Total Posts:  738
Joined  2008-08-18

haticia,

The only thing that needs to be considered is the location of the data and cache directories for an instance along with which port number and socket file the server communicates on. 

The following assumes installation with the TAR distribution installer on Unix.

For an example of installing two instances of the same edition and version, use the following example.  For installation of different editions or versions, you will have to unpack the software file in two separate directories and run the installer from each of those directories, but the options will be the same.

First instance - data1, cache1, my-ib1.cnf, port 5029, mysql-ib1.sock

/usr/local/infobright/install-infobright.sh --datadir=/usr/local/infobright/data1 --cachedir=/usr/local/infobright/cache1 --config=/etc/my-ib1.cnf --port=5029 --socket=/tmp/mysql-ib1.sock --user=mysql --group=mysql 

Before installing the second instance, I recommend that you rename the default start/stop and command line client scripts as follows (since they will be overwritten otherwise on the second installation):

[root@localhost infobright]mv /etc/init.d/mysqld-ib /etc/init.d/mysqld-ib1
[root
@localhost infobright]mv /usr/bin/mysql-ib /usr/bin/mysql-ib1 

Second instance - data2, cache2, my-ib2.cnf, port 5030, mysql-ib2.sock

/usr/local/infobright/install-infobright.sh --datadir=/usr/local/infobright/data2 --cachedir=/usr/local/infobright/cache2 --config=/etc/my-ib2.cnf --port=5030 --socket=/tmp/mysql-ib2.sock --user=mysql --group=mysql 

Also:

[root@localhost infobright]mv /etc/init.d/mysqld-ib /etc/init.d/mysqld-ib2
[root
@localhost infobright]mv /usr/bin/mysql-ib /usr/bin/mysql-ib2 

Configuration of the memory settings in the data1/brighthouse.ini and data2/brighthouse.ini files should consider whether both instances will be running at the same time or not so as not to allocate more memory than is physically available.

To start the two instances:

[root@localhost infobright]$ /etc/init.d/mysqld-ib1 start
[root
@localhost infobright]$ /etc/init.d/mysqld-ib2 start 
Signature 
Profile
 
Posted: 03 October 2010 07:23 PM   Ignore ]   [ # 6 ]  
Newbie
Rank
Total Posts:  10
Joined  2009-03-23

Hi David,
I have an existing instance of IB running and I want to create another (smaller) instance on the same server using the latest version for testing (before migration).  I reviewed your steps and the trouble is they start after the install of the package.  When I unpacked and installed the tarball of ICE 3.4.2 into a test directory it still created files in /usr/local/infobright where the existing install is.  How do I make it create a new install-infobright.sh in another directory besides /usr/local/infobright?  The install script in that directory was not updated when I ran the command ‘make EDITION=community install-release’, and there was not another install-infobright.sh script created.  Will the same install script install two different versions of IB if I pass it different options pointing to different config files?
Thanks,
Robert

Profile
 
Posted: 18 November 2010 03:20 PM   Ignore ]   [ # 7 ]  
Administrator
RankRankRankRank
Total Posts:  413
Joined  2010-09-22

Hi Robert,

I wanted to close the loop on this thread.  I believe your issue was solved via e-mail; is that true?  If you’re still having trouble, please let us know.

Cheers!

Jeff

Signature 

jeff kibler

Profile
 
Posted: 18 November 2010 04:01 PM   Ignore ]   [ # 8 ]  
Newbie
Rank
Total Posts:  10
Joined  2009-03-23

Hi Jeff,
Yes I got the help I needed, 3.4.2 is running great for us now.
Thanks,
Robert

Profile
 
Posted: 02 December 2010 11:44 AM   Ignore ]   [ # 9 ]  
Administrator
RankRankRankRank
Total Posts:  413
Joined  2010-09-22

Awesome—Thanks, Robert!

Signature 

jeff kibler

Profile