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 <[EMAIL PROTECTED]> >To: Felipe Duran <[EMAIL PROTECTED]>, beowulf@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:[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
