New article: "Will Sun rise higher after MySQL deal?" by Cath Jennings
http://www.computerweekly.com/Articles/2008/04/25/230456/will-sun-rise-higher-after-mysql-deal.htm
|
|
|
|
Excellent performance with open-source software! Some of you may have missed this, so I'll post the summary here (see Vanga's blog below for more info). Sun's MySQL running on a Sun SPARC Enterprise T5220 server supports 700 concurrent SugarCRM users using the SugarCRM workload. SugarCRM is a popular open-source CRM application.
On this benchmark Sun consolidated both the open-source MySQL Database and the open-source SugarCRM Application on the same UltraSPARC T2. In addition the UltraSPARC T2 hardware design is also open-sourced.
This open-source combination of SugarCRM and MySQL dramatically reduces the price of deploying CRM on Sun SPARC Enterprise T5220 server, and industry-leading free and open Solaris 10 OS.
This open-source combination of SugarCRM and MySQL supports 700 concurrent SugarCRM users on Sun's SPARC Enterprise T5220 server on top of Solaris 10 consumed only 260 watts in a 2U rack space (16GB memory)
See Also:
SugarCRM users (bigger is better)
| System | Processors | Users | Database | ||||
|---|---|---|---|---|---|---|---|
| Type | GHz | Chips | Cores | Threads | |||
| Sun T5220 | US-T2 | 1.4 | 1 | 8 | 64 | 700 | MySQL |
SugarCRM does not allow vendors to compare to other vendors in public, you'll have to do you own digging 
.
Benchmark Description
SugarCRM is a popular open source CRM application, that runs on Apache, MySQL and PHP also known as AMP stack. There are close to 1200 customers and the community is growing much faster. SugarCRM supports only MySQL and Oracle DB.
Results Summary
| Certified Results | 700 users | ||
| Reference Date: | February 26, 2008 | ||
| Systems: | 1 x Sun SPARC Enterprise T5220 16GB | ||
| Total Number Processors: | 1 | ||
| Processor/GHz of Server: | UltraSPARC T2 1.4 GHz | ||
| Operating System: | Solaris 10 8/07 | ||
| Software: | SugarCRM v4.5.1i | ||
|
|
|
|
{update} There is a lot of information about MySQL and Sun at http://www.sun.com/mysql In addition, I've put together a list of several blogs on MySQL performance.
* a very interesting results that compares Solaris Open-source stack (OS, DB, Web, Virtualizaion) on a 1-chip UltraSPARC T2 server and beating a proprietary stack on a 4-chip QC Xeon. Also measured actual watts and costs. Seems real configurations of HP DL580's draw lots of watts:
http://blogs.sun.com/ritu/entry/mysql_benchmark_us_t2_beats
* an ERP result using MySQL with SugarCRM:
http://blogs.sun.com/vanga/entry/scaling_sugarcrm_with_mysql_on
* great information about tuning MySQL on linux and some performance results:
http://blogs.sun.com/allanp/entry/tuning_mysql_on_linux
* nice writeup on InnoDB on SysBench:
http://blogs.sun.com/realneel/entry/tuning_mysql_innodb_for_sysbench
For a For a variety of things on MySQL see:
http://blogs.sun.com/barton808/entry/mysql_done_deal_talking_with
|
|
|
|
Getting ready to head off for lunch and I took off my blinders and I see all of the MySQL announcements. There are even several blogs on MySQL performance. Already some very interesting things coming from bringing MySQL into Sun.
* a very interesting results that compares Solaris Open-source stack (OS, DB, Web, Virtualizaion) on a 1-chip UltraSPARC T2 server and beating a proprietary stack on a 4-chip QC Xeon. Also measured actual watts and costs. Seems real configurations of HP DL580's draw lots of watts:
http://blogs.sun.com/ritu/entry/mysql_benchmark_us_t2_beats
* an ERP result using MySQL with SugarCRM:
http://blogs.sun.com/vanga/entry/scaling_sugarcrm_with_mysql_on
* great information about tuning MySQL on linux and some performance results:
http://blogs.sun.com/allanp/entry/tuning_mysql_on_linux
For a For a variety of things on MySQL see:
http://blogs.sun.com/barton808/entry/mysql_done_deal_talking_with
|
|
|
|
This link is flying around Sun Engineering, it is public info so I'd thought I'd make sure that my readers saw it as well. Basically MySQL University has a one hour session each week. If you are interested to learn more about MySQL, please see:
http://forge.mysql.com/wiki/MySQL_University
|
|
|
|
A reminder of the URL for a great Best practices Wiki. There are Application-specific Best Practices entry (Oracle RDBMS, SAP, MySQL, PostgreSQL, Apache...), a lot of info on ZFS Best Practices, ...and many more.
This wiki the companion to the Solaris Internals Book.
I've also added the URL to the 'cool links' section on this blog.
40 6250 abaqus amd benchmarks best blackbox blade blogwatch cmt compilers core cryptography e25k e6900 eco exa fire fluent hp hpc ibm intel itanium itanium2 java jvm linpack linux lotus m8000 m9000 mcad mysql networking niagara opensolaris opensource opensparc opteron oracle performance power power5+ power6 powerflow practices record sap sap-sd scaling siebel solaris sparc spc-1 spc-2 spec specapc specfp_rate2006 specint_rate2000 specint_rate2006 specjappserver specjappserver2004 specjbb specjbb2005 specomp specompm2001 specpower storage storagetek studio studio11 sun sunw suse swap t1 t2 t2000 t5120 t5220 t6300 tpc-c tpc-e tpc-h ultra ultrasparc us-iv+ utilization virtualization wattage watts windows woodcrest x4100 x4200 x4500 x6250 x64 xeon
This theme brought to you by the Sun Green Team.
Go Green!