Performance Evaluation of Distributed Database on PC Cluster Computers using MySQL Cluster

摘要

MySQL database is one of the most deployed DBMSs in both personnel and businesses. MySQL database can be deployed as personnel database, small and medium business and including enterprise organizations. MySQL database also has a version of distributed processing and distributed data, named MySQL Cluster. MySQL Cluster intends to be used in higher performance processing and can be scaled capability of capacity. The objective of this research was to evaluate the performance of scalability of MySQL Cluster on PC Cluster computers. We had used Benchw benchmark as the performance evaluating tool. The results of the research showed the relations between time of processing of each query of Benchw benchmark and the scalability of number of storage nodes. The results also showed that increasing the number storage nodes trended to improve processing time of each query of Benchw benchmark. Therefore the research is advantages for personnel or businesses that can plan the capability of database system to meet their business requirements. Furthermore, we had deployed MySQL Cluster on personnel computers that can reduce cost of hardware budgets dynamically and also can reduce cost of software license significantly.