<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2873" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=326585316-01052006><FONT face=Arial
color=#0000ff size=2>I would be interested in any numbers you could provide, but
make sure to also state exactly what</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=326585316-01052006><FONT face=Arial
color=#0000ff size=2>the underlying hardware is, i.e. node model, cpu speed, ram
speed and size, ethernet switch, disk model etc.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=326585316-01052006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=326585316-01052006><FONT face=Arial
color=#0000ff size=2>Michael</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> linux-cluster-bounces@redhat.com
[mailto:linux-cluster-bounces@redhat.com] <B>On Behalf Of </B>Sander van Beek -
Elexis<BR><B>Sent:</B> Monday, May 01, 2006 6:09 AM<BR><B>To:</B> linux
clustering<BR><B>Subject:</B> Re: [Linux-cluster] MySQL on GFS
benchmarks<BR></FONT><BR></DIV>
<DIV></DIV>Hi,<BR><BR>Ofcourse I understand that the performance will be less
because of extra overhead. My goal is to be as close to standalone server
performance as possible, with a certain budget in mind. One of the demands I
have is that the cluster solution I'm building is transparent to clients, highly
available, load balanced, and has to be scalable up to 2-8 servers. Both
replication and mysql-cluster are not fully transparent, mysql on gfs can be I
Think. <BR>I'll keep the list updated when I get more benchmarks.<BR><BR>Best
regards,<BR>Sander<BR><BR>At 05:07 1-5-2006, you wrote:<BR>
<BLOCKQUOTE class=cite cite="" type="cite">No matter what you do, a standalone
server would be faster than a clustered architecture, if it is GFS over SAN,
or even the MySQL cluster, due to obvious reasons of latency invloved. Anyway
what exactly are you trying to build with MySQL, I mean what kind of
performance you want from MySQL, may be you could try Replication or if you
want good scalability, then you would be better off with the MySQL cluster.
<BR><BR>Kishore Jalleda <BR><A
href="http://kjalleda.googlepages.com/projects">http://kjalleda.googlepages.com/projects</A><BR><BR><BR><BR>On
4/26/06, Sander van Beek - Elexis <<A
href="mailto:sander@elexis.nl">sander@elexis.nl </A>> wrote:<BR>> Hi
all,<BR>> <BR>> We did a quick benchmark on our 2 node rhel4 testcluster
with gfs and<BR>> a gnbd storage server. The results were very sad. One of
the nodes<BR>> (p3 1ghz, 512 mb) could run +/- 2400 insert queries per
second when <BR>> running mysqld-max 5.0.20 on a local ext3 filesystem.
With a 2 node<BR>> GFS over GNBD setup and inserts on both nodes at the
same time, we<BR>> only could do 80 inserts per second. I'm very interested
in the <BR>> perfomance others got in a similar setup. Would the
performance<BR>> increase when we use software based iscsi instead of
gnbd?<BR>> Or should we simply buy SAN equipment? Does anyone have
statistics to<BR>> compare a standalone mysql setup to a small gfs cluster
using a san?<BR>> <BR>> <BR>> With best regards,<BR>> Sander van
Beek<BR>> <BR>> ---------------------------------------<BR>> <BR>>
Ing. S. van Beek <BR>> Elexis<BR>> Marketing 9<BR>> 6921 RE
Duiven<BR>> The Netherlands<BR>> <BR>> Tel: +31
(0)26 7110329<BR>> Mob: +31 (0)6 28395109<BR>>
Fax: +31 (0)318 611112<BR>> Email: <A
href="mailto:sander@elexis.nl">sander@elexis.nl</A><BR>>
Web: <A
href="http://www.elexis.nl">http://www.elexis.nl</A><BR>> <BR>>
--<BR>> Linux-cluster mailing list<BR>> <A
href="mailto:Linux-cluster@redhat.com">Linux-cluster@redhat.com </A><BR>>
<A href="https://www.redhat.com/mailman/listinfo/linux-cluster"
eudora="autourl">https://www.redhat.com/mailman/listinfo/linux-cluster</A><BR>>
<BR><BR>--<BR>Linux-cluster mailing list<BR>Linux-cluster@redhat.com<BR><A
href="https://www.redhat.com/mailman/listinfo/linux-cluster"
eudora="autourl">https://www.redhat.com/mailman/listinfo/linux-cluster</A><BR>No
virus found in this incoming message.<BR>Checked by AVG Free
Edition.<BR>Version: 7.1.385 / Virus Database: 268.5.1/327 - Release Date:
28-4-2006</BLOCKQUOTE><X-SIGSEP>
<P></X-SIGSEP>Met vriendelijke groet,<BR>Sander van
Beek<BR><BR>---------------------------------------<BR><BR>Ing. S. van
Beek<BR>Elexis<BR>Marketing 9 <BR>6921 RE Duiven<BR><BR>Tel:
<X-TAB> </X-TAB>+31 (0)26 7110329<BR>Mob:
<X-TAB> </X-TAB>+31 (0)6 28395109<BR>Fax:
<X-TAB> </X-TAB>+31 (0)318 611112<BR>Email:
sander@elexis.nl<BR>Web: <X-TAB> </X-TAB> <A
href="http://www.elexis.nl/"
eudora="autourl">http://www.elexis.nl<BR></A></P></BODY></HTML>