Re: using large databases

Hello Uwe Applet,

Thank you for taking the time to write.

On Tue, 2006-09-12 at 11:52 +0200, Appelt, Uwe wrote:
> Dear Developers,
> 
> i'm currently working on a very database intensive project. In fact,
> we have a bunch of computers (50-60), that could be used as a
> db-cluster, but unfortunatly those computers are part of a public
> available pool, so that we cannot run mysql as a classicly-fashioned
> dbms-cluster. instead, we developed a java-rmi cluster, where each
> host eats 'database jobs', when it is not loaded by an locally logged
> on user. these jobs actually consist of massive selecting data from a
> several gigabytes database (genetic data as provided by ensembl.org).
> as i saw (or guess) you are deploying embedded databases from the
> ressource dir, that also contains the data-dir as a jar-archive.

A default data dir is included in the Connector/MXJ jar, yes.

>  but in the above case, it would not make any sense at all, to
> decompress a several gb-jar everytime, the java-app is started (which
> is actually done, when the user loggs off) => question:
> is it possible, to use connector/MXJ with a fully preconfigured
> mysql-directory including 'bin/mysqld', 'data/myhugedb/*.*' and a
> 'my.ini', which is already lying on a local harddrive?

With Connector/MXJ we can provide the "datadir" parameter to point to
any directory we wish.

Although it might work to point the "basedir" at an existing mysql
install directory, I have not tried it, and it is not really expected
that we would use it that way. Also the "my.ini" would be ignored
because Connector/MXJ expects all configuration options to be provided
to it as parameters.

>  if so, i would preconfigure the database to be used by clusterclients
> as an embedded ressource on a standalone system and patch later on
> each clusterhost with the whole mysql-dir prior to install the
> java-app. would that make sense to you?

I would suggest that you start out by giving Connector/MXJ a try simply
pointing the "datadir" to the directory of your choosing, and see if
that will do the trick for you.
> 
> thanks in advance and kind regards

Absolutely! And please write us back and tell us how things go. 

> Uwe Appelt

Cheers,
 -Eric

> 
> 
> 
> 
> 
> 
> 
> (Dipl. Inform. Med.)
> Universitätsklinikum Heidelberg
> Institut für Transplantationsimmunologie
> Friedrich-Ebert-Anlage 17
> 69117 Heidelberg
> Tel.: 06221 1370-22
> Fax.: 06221 1370-45
> [email protected]
> 
-- 
Eric Herman, Software Developer
MySQL AB, www.mysql.com
VoIP Ext: 6594   US: +1 408 213 6540  Europe: +46 18 174 400
Mobile: +31 [0]6-20719662
Are you MySQL certified?  www.mysql.com/certification


-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/[email protected]