Figure 4 SysBench Results for the HP ProLiant BL685c Server
Summary
The results of the SysBench testing indicated that the HP Proliant c-Class Blade Servers provide a solid platform for the MySQL database server. Along with the integrated Smart Array controller these servers provide the security of RAID storage to the host operating system and database files, while also offering excellent performance for many applications.
The results of the benchmarks tests are provided in Figure 5 and indicate that the HP ProLiant BL465c server is a good choice for an entry-level database server with scalability to SAN, as the size of the database grows. When higher performance levels are required from a single server, both the HP ProLiant BL460c and HP ProLiant BL480c servers (when configured with two Quad-Core processors) provided a good option for scalability.
Figure 5 Benchmark Test Results
The test results indicated that optimum price and performance could be achieved using a MySQL Replication configuration with a pair of HP ProLiant BL460c or BL480c servers with 8 cores in a high-availability cluster where HP Proliant c-Class Blade Servers acted as the MySQL master database server. This, combined with a number of ProLiant BL465c servers acting as the MySQL slave database servers, provided a robust, scalable database environment within a single HP BladeSystem enclosure.
Resources
For additional information on the hardware and software used in the MySQL sizing tests, see the following websites:
HP and MySQL http://h71028.www7.hp.com/enterprise/cache/77721-0-0-0-121.html