Empirical Analysis of Database Server Scalability Using an N-Tier Benchmark With Read-Intensive Workload

The performance evaluation of database servers in N-tier applications is a serious challenge due to requirements such as non-stationary complex workloads and global consistency management when replicating database servers. The authors conducted an experimental evaluation of database server scalability and bottleneck identification in N-tier applications using the RUBBoS benchmark. The experiments are comprised of a full scale-out mesh with up to nine database servers and three application servers. Additionally, the fourtier system was run in a variety of configurations, including two database management systems (MySQL and PostgreSQL), two hardware node types (Normal and low-cost), and two database replication techniques (C-JDBC and MySQL Cluster).