Analysis of Service-Oriented DBMS Organization

Cloud database management systems (DBMSs) often decouple database instances from physical storage to provide reliability and high availability to users. This design can robustly handle a single point of failure, but needs substantial effort to attain good performance. In this paper, we analyze the decoupled architecture and present important optimization issues that we faced in implementing the design. For implementing the prototyped system, we decouple MariaDB into a database instance and storage managing log and data pages. We evaluate the prototyped system using standard database benchmarks, and experimental results show that adopting the decoupled architecture for cloud DBMSs needs to address numerous optimization issues for achieving better performance.