Performance Evaluation of High Availability Database Systems Using Low-latency I/O Devices

Abstract

Low-latency I/O devices are connected to the peripheral component interconnect express bus on a database server. Most practical database systems are built as a high availability system to avoid a single point of failure. Therefore, we evaluated a high availability database system configured with servers using low-latency I/O devices. We have shown that the performance overhead of the high availability configuration using low-latency solid state drives is 12% compared to a single server configuration, in a primitive update test case. The result of a mixed-workload benchmark indicated that the database system configuration using low-latency I/O devices was up to 6.1 times faster than the performance using traditional external storage when the allocated database buffer was 5% of the database size.