Scaling MySQL on a 256-way T5440 server with ZFS

Recently, some tests were conducted at Sun that show that MySQL with ZFS can scale on our servers with Cool Threads technology.  These tests show that MySQL can scale on these systems with  little tuning expertise.  The tests used database sharding and application partitioning to obtain the optimal configuration.  Some details of the tests can be found here

Sun systems with CoolThreads technology deliver breakthrough performance, scalability and reliability with dramatic space, power, and cost efficiency on Sun's proven open source chip multithreading (CMT) architecture. In addition, you get open source Solaris 10 OS and virtualization technology at no extra cost.  Take the Sun savings challenge here.


Comments:

The linked "benchmark" does not give any info about the configuration, the "ksh scripts" are mentionned but not shown, the procedure to scale horizontally is not described and the article is generally empty of any useful information. (28 instances of... what? are we talking about replication? NDB?) In short, this is a "benchmark" that no one can verify or reproduce.

Posted by Mike on November 11, 2008 at 05:13 AM PST #

256 hardware threads, 28 MySQL instances, 64GB RAM, 10 disks

Posted by Mark Callaghan on November 11, 2008 at 05:29 AM PST #

Database sharding and application partitioning cannot be done successfully with "little expertise." I know that's not what the article says -- but I want to point out that Sun doesn't magically make your systems scale if you're not good at it.

Posted by Anonymous on November 11, 2008 at 11:04 AM PST #

@Anonymous: That is a good point. There isn't anything simple about database sharding and application partitioning. That does take expertise. It's more that once that was complete in the environment, there wasn't this extensive need for system tuning.

Posted by Jennifer Glore on November 11, 2008 at 11:10 AM PST #

Ok that is good point.

Posted by motel for sale on November 11, 2008 at 04:02 PM PST #

good

Posted by rem on November 25, 2008 at 11:32 PM PST #

That medium for me.

Posted by structured settlements on April 09, 2009 at 01:10 PM PDT #

There isn't anything simple about database sharding and application partitioning

Posted by san francisco vacation on April 09, 2009 at 01:12 PM PDT #

"256 hardware threads, 28 MySQL instances, 64GB RAM, 10 disks"
good

Posted by health care guide on April 09, 2009 at 01:16 PM PDT #

that good for me.

Posted by jacksonville realestate on February 08, 2010 at 05:31 PM PST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Jennifer Glore

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today