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.
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 01:13 PM PST #
256 hardware threads, 28 MySQL instances, 64GB RAM, 10 disks
Posted by Mark Callaghan on November 11, 2008 at 01:29 PM 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 07:04 PM 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 07:10 PM PST #
Ok that is good point.
Posted by motel for sale on November 12, 2008 at 12:02 AM PST #
good
Posted by rem on November 26, 2008 at 07:32 AM PST #
That medium for me.
Posted by structured settlements on April 09, 2009 at 08:10 PM PDT #
There isn't anything simple about database sharding and application partitioning
Posted by san francisco vacation on April 09, 2009 at 08:12 PM PDT #
"256 hardware threads, 28 MySQL instances, 64GB RAM, 10 disks"
good
Posted by health care guide on April 09, 2009 at 08:16 PM PDT #