Introduction
DBT2 is a TPC-C like benchmark tool supporting MySQL. The results of a test run include transactions per minute, CPU utilization, I/O activity, and memory utilization. The DBT2 test kit can be downloaded from the DBT sourceforge site. The purpose of this document is to show how to use the virtualization technology: Solaris container to scale-out multiple mysql instances on the Sun's CoolThreads server.
Hardware and Software configurations
Sun SPARC T5240 Server: 2x8-core UltraSPARC T2 Plus(1165 Mhz,128 Threads) Processor; 64GB RAM; 2x146GB Internal Disk
Database: MySQL 5.1.30
Operating System: Solaris Express Community Edition snv_98 SPARC
Test Case 1: Single MySQL server on T5240 in 32 warehouse DBT2 Test …
[Read more]