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:[EMAIL PROTECTED]]
Sent: Thu Jun 22 16:31:40 2006
To: beowulf@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@beowulf.org
To change your subscription (digest mode or unsubscribe) visit http://www.beowulf.org/mailman/listinfo/beowulf
_______________________________________________ Beowulf mailing list, Beowulf@beowulf.org To change your subscription (digest mode or unsubscribe) visit http://www.beowulf.org/mailman/listinfo/beowulf
