[Beowulf] MPI mysql

[Hugo Kohmann]

Hi,

MySQL has its own cluster solution --> MySQL Cluster. Look for more
informaiton at the MySQL web.

Best regards

Hugo



On Thu, 22 Jun 2006, Michael Will wrote:

>Date: Thu, 22 Jun 2006 16:38:54 -0700
>From: Michael Will <mwill at penguincomputing.com>
>To: Felipe Duran <fduran at terra.com.br>, beowulf at beowulf.org
>Subject: RE: [Beowulf] MPI mysql
>
>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
>