8x Quad-Core Opteron PostgreSQL/MySQL Server Try and Buy Offer
Somehow I must have missed this try and buy offer before. Evaluate the Sun Fire X4600 with PostgreSQL, MySQL or Microsoft SQL Server 2005. The Sun Fire X4600 M2 Server included in the program is available in two configurations. First configuration is 4 x Quad-Core with 16GB RAM and second configuration is with 8x Quad-Core (yes 32 cores in all) with 64GB RAM. Of course it only comes with two disks in it which means also need to "Try and Buy" the Sun StorageTek 2540 Array or the Sun Storage 7110 Unified Storage System with it.
Would love to see some real life deployment saturate 32-core Opteron system using only PostgreSQL or MySQL as the database system in it.
Jignesh,
There is a well known way to saturate the system with MySQL Only:
http://blogs.sun.com/mrbenchmark/entry/scaling_mysql_on_a_256
Run 32 MySQL instances one per core and MySQL scaling issues should not bite you :)
Posted by Peter Zaitsev on November 12, 2008 at 12:04 AM EST #
I love Percona, but seriously, it is well known that MySQL doesn't scale linearly even to 8 cores. The fact that you have to run 32 MySQL instances is a joke.
I would love to see PostgreSQL scale to full 256 threads on the T5440. That should be the challenge for Sun/PostgreSQL for 2009 I guess. Even Intel will get 64 threads this year with Nehalem-EX, possibly 128 threads in 2010.
I would also suggest that Sun let open some T5440 systems online for software developers to test SMP scalability on the 256 threads monster. Charge them something like 10-15 dollars an hour in 15 minute increments(similar to Amazon EC2 rates) Most software benchmark can be done in a few minutes but they don't have access to 256 threaded hardware.
Posted by TS on February 28, 2009 at 08:02 PM EST #
Yes it is a joke. That is Some Sun guys suggesting that solution :)
Sorry if it sounds like I recommended such approach in practice.
Posted by Peter Zaitsev on February 28, 2009 at 08:29 PM EST #