Oracle集群数据库压力测试与分析

The Stress Test and Analysis of Oracle Cluster Database

通过VirtualBox虚拟化平台搭建RAC集群数据库,以Swingbench为压力测试工具,对Oracle RAC数据库的性能进行压力测试研究,完成双节点和单节点集群数据库的压力测试,并分析增加节点对数据库性能带来的变化,压力测试的结果可供应用程序开发人员参考。实践操作证明Oracle RAC集群在节点增加之后,若不进行优化工作,并不会对数据库性能带来太大的改观。

In this paper,the performance of Oracle RAC database is tested.Build RAC cluster database through VirtualBox virtualization platform,use Swingbench as the stress test tool,complete the stress test of dual node and single node cluster database,and analyze the changes of database performance caused by adding nodes.The results of stress test can be used for reference by application developers.It is proved that add node without optimization,Oracle RAC cluster doesn′t improve a lot on performance.