[Beowulf] MPI mysql

[Michael Will]

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.

Mysql
./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
running.


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.scyld.com/pipermail/beowulf/attachments/20060622/f431fe28/attachment.html