Hybrid Disk Drive Configuration on Database Server Virtualization

Ferdy Nirwansyah, Suharjito Suharjito

Abstract


SSD is a revolutionary new storage technologies. Enterprise storage system using full SSD is still very expensive, while HDD is still widely used. This study discusses hybrid configuration storage in virtualized server database with benchmark against four hybrid storage configuration for four databases, ORACLE, SQL Server, MySQL and PostgreSQL on Windows Server virtualization. Benchmark using TPC-C and TPC-H to get the best performance of four configurations were tested. The results of this study indicate HDD storage configurations as visual disk drive OS and SSD as visual disk drives database get better performance as OLTP and OLAP database server compared with SSD as visual disk drive OS and HDD as a visual disk drive database. Based on the data research TPC-C, OLTP get best performance at HDD storage configurations as visual disk drive OS and SSD as a visual disk drives database and temporary files.

Keywords


Database; High availability; Server virtualization; Hybrid storage

Full Text:

PDF


DOI: http://doi.org/10.11591/ijeecs.v2.i3.pp720-728

Refbacks

  • There are currently no refbacks.


Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

shopify stats IJEECS visitor statistics