Besides Amazon EC2 - any cloud hosting with >24-32 cpu cores >24-32GB ram ?
Recently, I got brief access to a Quad Intel L7555 1.86Ghhz Nehalem-EX based 32 cpu core server with 64GB DDR3 memory for some testing I did.
I ran MySQL both MyISAM and InnoDB benchmark comparisons and scalability benchmarks from 1 to 64 cpu threads for MySQL 5.0.92, 5.1.55, 5.5.10, 5.5.11, Percona 5.1.55, Percona 5.5.8, Percona 5.5.10 and MariaDB 5.2.5.
But I no longer have access to this beast of a server, but I still have further tests I would like to run but as all I would be doing to running tests, going the dedicated server route would be expensive so cloud hosting servers billed by the hour would be next best thing.
But besides Amazon EC2, alot of cloud hosting servers don't offer past 8 cpu cores and 8GB memory and well disk I/O is much less than the test server I used (specs below).
█ Michael Wallace - [email protected]
█ Innovative Scaling Technologies Inc. - A Cloud Service Provider
█ 24/7 Support, Call us @ 1-307-200-4880
█ www.innoscale.net - Seattle, Silicon Valley, Dallas, Chicago, Washington D.C., and Europe
hehe you and Brent both xtreme systems members ? As I said to Brent, yup the one and the same eva2000 in the pc hardware world As to how much to spend - less is better
Originally Posted by CloudWeb
Are you just looking to do benchmarks or what exactly? I have clouds in operation that are very close to that spec if you're just toying around...
It's just to do benchmarks mainly sysbench, mysqlslap etc, I have been rolling out my own MariaDB 5.2.5 RPMs from source rpms optimized for Intel based servers and on the above tested server it was up to 44% faster than the official MariaDB 5.2.5 rpm and up to 50-82% faster than MySQL 5.5.11 in benchmarks. But since i did those benchmarks, I have optimized my RPMs further but have no server to test them on
I wonder how much overhead the virtualization may add to the benchmark result. I am sure benchmarking on a VM with 64 threads would give different result than a physical server with the same number threads. But if you only care about relative comparisons, then the differences may not count.
Fluid Hosting, LLC - HSphere Shared and Reseller hosting - Now with HIGH AVAILABILITY Fluid VPS - Linux and Windows Virtuozzo VPS - Enterprise VPS with up to 2 GB guaranteed memory! Get your N+1 High Availability Enterprise Cloud Equinix Secaucus NY2 (NYC Metro)
You're not going to get close to the performance of your hardware system on a mass cloud computing platform with over-contended shared network storage.
You *might* get close if you put your database into a ram disk on the VM, but that has implications for your data. MySQL isn't very threaded in my experience any way - you'll struggle to get a single instance to use more than 8 threads.
Darren Lingham - UK Webhosting Ltd. - (0800) 024 2931 Tsohost.co.uk - Quality UK Windows and Linux hosting since 2003 UK WordPress Hosting - Fast, easy, cloud based WordPress Hosting
Actually both percona 5.5.x and mariadb 5.2.x versions of mysql improve on that and can scale well into 24-32 cpu cores from my tests so far. It's reason why i need >32 cpu core server to continue testing. No idea how cloud based storage will affect the results though.