[Beowulf] MPI mysql

Michael Will mwill at penguincomputing.com
Thu Jun 22 16:38:54 PDT 2006

It's not going to be as easy as that. You have to use whatever mechanisms for scaling are available within mysql, i.e. Master/slave replication or the more advanced ndb stuff. In either case you probably will need to find somebody experienced to assist you.

 -----Original Message-----
From: 	Felipe Duran [mailto:fduran at terra.com.br]
Sent:	Thu Jun 22 16:31:40 2006
To:	beowulf at beowulf.org
Subject:	[Beowulf] MPI mysql

Hello All.

	Could some make mysql run over mpich on a Beowulf cluster?

	I have a monitoring toll that uses mysql to store host status, but have
more than 2000 devices to monitor and the DB burn CPU and Memory. To take a
notion of the problem, I have a dual Xeon 3.2 with 4GB of memory going to 0
idle on top acess. Becouse this I need to put the DB to run over a cluster
gaining power and scalability.

I make the following configuration.

./configure --prefix=/usr/local/mysql CC=/usr/mpi-beowulf/bin/mpicc
CCFLAGS=-I/usr/mpi-beowulf/include/ CXX=/usr/mpi-beowulf/bin/mpiCC
CXXFLAGS=-I/usr/mpi-beowulf/include/ F77=/usr/mpi-beowulf/bin/mpif77
F77FLAGS=-I/usr/mpi-beowulf/include/ F90=/usr/mpi-beowulf/bin/mpif90

When mpirun the database returns
060621 22:53:56  mysqld started
060621 22:53:56 [ERROR] /usr/local/mysql/libexec/mysqld: unknown option '-p'
060621 22:53:56  mysqld ended

The bpstat show the nodes
The beostatus show the procs and memory
The mpi_mandel runs OK, and beostatus show the sharing of cpu.

I dont know, but I think my beowulf version is old. On the disk show me to
be the version 2.0 but I couldnt find the way to show the right version im

Thanks in Advance.
Felipe Duran

Beowulf mailing list, Beowulf at beowulf.org
To change your subscription (digest mode or unsubscribe) visit http://www.beowulf.org/mailman/listinfo/beowulf
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.beowulf.org/pipermail/beowulf/attachments/20060622/f431fe28/attachment.html>

More information about the Beowulf mailing list