Joinutility seperatorLogin utility separator Infobright.com
   
 
mysql InnoDB and Infobright coexist in same server
 
evergeldedios
Posted: 28 April 2010 01:56 PM   [ Ignore ]  
Newbie
Rank
Total Posts:  3
Joined  2010-04-08

Can we install a MySQL community server and the Infobright MySQL on one server?
We are assuming that this is the only way we can have InnoDB tables for transactions and the Brighthouse tables for the warehouse.

Thanks.

Profile
 
Geoffrey Falk
Posted: 28 April 2010 02:05 PM   [ Ignore ]   [ # 1 ]  
Sr. Member
Avatar
RankRankRankRank
Total Posts:  505
Joined  2008-08-18

Yes. Just ensure that the port numbers are different. MySQL by default uses 3306 and Infobright uses 5029.

Also ensure that there is enough RAM for both to run.

You are correct, that is currently the only way to get InnoDB on the same box.

Geoffrey

Signature 
Profile
 
   
 
 
‹‹ Use LOAD DATA INFILE with Named Pipes in Java/Scala      UNION performance ››