<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<TITLE>RE: [Beowulf] MPI mysql</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>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.<BR>
<BR>
-----Original Message-----<BR>
From: Felipe Duran [<A HREF="mailto:fduran@terra.com.br">mailto:fduran@terra.com.br</A>]<BR>
Sent: Thu Jun 22 16:31:40 2006<BR>
To: beowulf@beowulf.org<BR>
Subject: [Beowulf] MPI mysql<BR>
<BR>
Hello All.<BR>
<BR>
Could some make mysql run over mpich on a Beowulf cluster?<BR>
<BR>
I have a monitoring toll that uses mysql to store host status, but have<BR>
more than 2000 devices to monitor and the DB burn CPU and Memory. To take a<BR>
notion of the problem, I have a dual Xeon 3.2 with 4GB of memory going to 0<BR>
idle on top acess. Becouse this I need to put the DB to run over a cluster<BR>
gaining power and scalability.<BR>
<BR>
I make the following configuration.<BR>
<BR>
Mysql<BR>
./configure --prefix=/usr/local/mysql CC=/usr/mpi-beowulf/bin/mpicc<BR>
CCFLAGS=-I/usr/mpi-beowulf/include/ CXX=/usr/mpi-beowulf/bin/mpiCC<BR>
CXXFLAGS=-I/usr/mpi-beowulf/include/ F77=/usr/mpi-beowulf/bin/mpif77<BR>
F77FLAGS=-I/usr/mpi-beowulf/include/ F90=/usr/mpi-beowulf/bin/mpif90<BR>
<BR>
When mpirun the database returns<BR>
060621 22:53:56 mysqld started<BR>
060621 22:53:56 [ERROR] /usr/local/mysql/libexec/mysqld: unknown option '-p'<BR>
060621 22:53:56 mysqld ended<BR>
<BR>
<BR>
The bpstat show the nodes<BR>
The beostatus show the procs and memory<BR>
The mpi_mandel runs OK, and beostatus show the sharing of cpu.<BR>
<BR>
I dont know, but I think my beowulf version is old. On the disk show me to<BR>
be the version 2.0 but I couldnt find the way to show the right version im<BR>
running.<BR>
<BR>
<BR>
Thanks in Advance.<BR>
Felipe Duran<BR>
<BR>
_______________________________________________<BR>
Beowulf mailing list, Beowulf@beowulf.org<BR>
To change your subscription (digest mode or unsubscribe) visit <A HREF="http://www.beowulf.org/mailman/listinfo/beowulf">http://www.beowulf.org/mailman/listinfo/beowulf</A><BR>
</FONT>
</P>
</BODY>
</HTML>