[Linux-cluster] MySQL on GFS benchmarks

[Michael Will]

I would be interested in any numbers you could provide, but make sure to
also state exactly what
the underlying hardware is, i.e. node model, cpu speed, ram speed and
size, ethernet switch, disk model etc.
 
Michael

________________________________

From: linux-cluster-bounces at redhat.com
[mailto:linux-cluster-bounces at redhat.com] On Behalf Of Sander van Beek -
Elexis
Sent: Monday, May 01, 2006 6:09 AM
To: linux clustering
Subject: Re: [Linux-cluster] MySQL on GFS benchmarks


Hi,

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. 
I'll keep the list updated when I get more benchmarks.

Best regards,
Sander

At 05:07 1-5-2006, you wrote:


	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. 
	
	Kishore Jalleda 
	http://kjalleda.googlepages.com/projects
	
	
	
	On 4/26/06, Sander van Beek - Elexis <sander at elexis.nl > wrote:
	> Hi all,
	> 
	> We did a quick benchmark on our 2 node rhel4 testcluster with
gfs and
	> a gnbd storage server. The results were very sad. One of the
nodes
	> (p3 1ghz, 512 mb) could run +/- 2400 insert queries per second
when 
	> running mysqld-max 5.0.20 on a local ext3 filesystem. With a 2
node
	> GFS over GNBD setup and inserts on both nodes at the same
time, we
	> only could do 80 inserts per second. I'm very interested in
the 
	> perfomance others got in a similar setup. Would the
performance
	> increase when we use software based iscsi instead of gnbd?
	> Or should we simply buy SAN equipment? Does anyone have
statistics to
	> compare a standalone mysql setup to a small gfs cluster using
a san?
	> 
	> 
	> With best regards,
	> Sander van Beek
	> 
	> ---------------------------------------
	> 
	> Ing. S. van Beek 
	> Elexis
	> Marketing 9
	> 6921 RE Duiven
	> The Netherlands
	> 
	> Tel:    +31 (0)26 7110329
	> Mob:    +31 (0)6 28395109
	> Fax:    +31 (0)318 611112
	> Email: sander at elexis.nl
	> Web:    http://www.elexis.nl
	> 
	> --
	> Linux-cluster mailing list
	> Linux-cluster at redhat.com 
	> https://www.redhat.com/mailman/listinfo/linux-cluster
	> 
	
	--
	Linux-cluster mailing list
	Linux-cluster at redhat.com
	https://www.redhat.com/mailman/listinfo/linux-cluster
	No virus found in this incoming message.
	Checked by AVG Free Edition.
	Version: 7.1.385 / Virus Database: 268.5.1/327 - Release Date:
28-4-2006

Met vriendelijke groet,
Sander van Beek

---------------------------------------

Ing. S. van Beek
Elexis
Marketing 9 
6921 RE Duiven

Tel:    +31 (0)26 7110329
Mob:    +31 (0)6 28395109
Fax:    +31 (0)318 611112
Email: sander at elexis.nl
Web:     http://www.elexis.nl
<http://www.elexis.nl/> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/linux-cluster/attachments/20060501/24ab25c3/attachment.htm>