Database performance is closely related to disk I/O performance. This chapter describes the disk configuration-related matters.
Storage for Database
It should be fundamentally excluded from affecting the performance of the database due to disk I/O of other external factors such as OS or application program. Dedicated storage for the database physically separated from the disk used by other elements such as OS and application programs is required.
RAID
RAID 10, which is known to have the best input-output per second (IOPS), is mainly used for the RAID (Redundant Array of Independent Disk) configuration for the database. RAID 10 is a combination of RAID 1 and RAID 0.
Since the number of disks used may vary depending on the RAID configuration method, according to the size of the database and the number of available disks, choose an appropriate method with a consultation with an expert.
- mirror (RAID 1)
It is flexible with data loss because it stores the same data on multiple disks.
- striping (RAID 0)
The speed of I/O can be greatly improved because data is divided into blocks and stored on multiple disks.
Disk Performance
The disk performance depends on the traffic of the system and is calculated with the maximum traffic test. In the case of a disk DB where random I/O occurs frequently due to its characteristics, an SSD with excellent random I/O performance is recommended.