RE: MySQL on GFS benchmarks

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxx [mailto:linux-cluster-bounces@xxxxxxxxxx] On Behalf Of Sander van Beek - Elexis
Sent: Monday, May 01, 2006 6:09 AM
To: linux clustering
Subject: Re: 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@xxxxxxxxx > 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@xxxxxxxxx
> Web:    http://www.elexis.nl
>
> --
>
> Linux-cluster@xxxxxxxxxx
> https://www.redhat.com/mailman/listinfo/linux-cluster
>

--

Linux-cluster@xxxxxxxxxx
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@xxxxxxxxx
Web:     http://www.elexis.nl

--

Linux-cluster@xxxxxxxxxx
https://www.redhat.com/mailman/listinfo/linux-cluster

[Index of Archives]     [Corosync Cluster Engine]     [GFS]     [Linux Virtualization]     [Centos Virtualization]     [Centos]     [Linux RAID]     [Fedora Users]     [Fedora SELinux]     [Big List of Linux Books]     [Yosemite Camping]

  Powered by Linux