The issue I get with the mysql cluster is the size of my db and the fact that the cluster is using today a in-memory storage. I have around 10gigs of Data , so I need a cluster with 2.5 * 10 = 25 gigs of memory As the customer is using intel servers with 4 gigs of memory each, that means I will have to setup at least 8 servers. As the customer don't want to spend more money, this is not a solution. I will test and will publish the result with GFS (on debian) within the next two weeks.. Benoit On Mon, 20 Dec 2004 13:58:27 +0100, Lazar Obradovic <laza@xxxxxx> wrote: > You should check this out: > > http://www.mysql.com/products/cluster/ > > You don't need GFS nor a shared storage for it. I'm using it for a > shared Bayes database for SpamAssassin and for storing sessions for our > web farm. It's still work-in-a-progress, but it works fairly good > (almost no glitches :) > > Thinking about your idea, I'm not quite sure that it will work with > MySQL after all (and, if you even do manage to make it work, I'm pretty > sure it will have severe performance penalty). > > Note to list admin: could you please change the value of a List-Id: > header field? I'm not sure that 'linux clistering' is the right name for > the list ;) > > > On Sun, 2004-12-19 at 16:12 -0500, Benoit de Mulder wrote: > > I would like to know if there are some users of this list using GFS > > for mysql databases. I have some issues with the replication delay (I > > need a sync time less than 3s between 4 DB servers) > > > > I'm planning to use GFS (setup on multipath GNBD devices and Gigabit > > network ) in order to share a database among multiples MySQL server. > > > > MySQL will use external lock method with MyISAM tables and GFS will be > > mounted with the noatime option. > > > > I was planning to test two scenarios: > > - multiple write servers, all gfs volume mounted RW > > - one write and 3 servers with database mounted RO > > > > Does someone get an experience with a similar setup and some feedback > > about perfomances and reliability ? > > > > Thanks > > > > Benoit > > > > -- > > > > Linux-cluster@xxxxxxxxxx > > http://www.redhat.com/mailman/listinfo/linux-cluster > -- > Lazar Obradovic, System Engineer > ----- > laza@xxxxxx > YUnet International http://www.EUnet.yu > Dubrovacka 35/III, 11000 Belgrade > Tel: +381 11 3119901; Fax: +381 11 3119901 > ----- > This e-mail is confidential and intended only for the recipient. > Unauthorized distribution, modification or disclosure of its > contents is prohibited. If you have received this e-mail in error, > please notify the sender by telephone +381 11 3119901. > ----- > >
