Á¤º¸°úÇÐȸ³í¹®Áö (Journal of KIISE)
ÇѱÛÁ¦¸ñ(Korean Title) |
µ¥ÀÌÅͺ£À̽º ½Ã½ºÅÛÀÇ ¿øÀÚ¼º ¾²±â º¸ÀåÀ» À§ÇÑ ½ºÅ丮Áö I/O ¼ºê½Ã½ºÅÛ |
¿µ¹®Á¦¸ñ(English Title) |
Storage I/O Subsystem for Guaranteeing Atomic Write in Database Systems |
ÀúÀÚ(Author) |
ÇѱÔÈ
½Åµ¿±º
±è¿ë¼®
Kyuhwa Han
Dongkun Shin
Yongserk Kim
|
¿ø¹®¼ö·Ïó(Citation) |
VOL 42 NO. 02 PP. 0169 ~ 0176 (2015. 02) |
Çѱ۳»¿ë (Korean Abstract) |
ÃÖ±Ù µ¥ÀÌÅͺ£À̽º °ü¸® ½Ã½ºÅÛ¿¡¼´Â ÀÌÁß ¾²±â ¹öÆÛ ±â¹ýÀÇ ´ÜÁ¡À» º¸¿ÏÇÒ ¼ö ÀÖ´Â ¿øÀÚ¼º¾²±â ±â¹ýÀÌ Á¦½ÃµÇ¾ú´Ù. ¿øÀÚ¼º ¾²±â ±â¹ýÀ» Áö¿øÇϱâ À§Çؼ´Â ÆÄÀϽýºÅÛ°ú I/O ½ºÄÉÁÙ·¯ µîÀÇ I/O ¼ºê½Ã½ºÅÛ°ú SSDÀÇ ¿øÀÚ¼º ¾²±âÀÇ º¸ÀåÀÌ ÇÊ¿äÇÏ´Ù. º» ¿¬±¸¿¡¼´Â MariaDBÀÇ µ¥ÀÌÅÍ ¾²±âÀÇ ±âº» ´ÜÀ§¸¦ »ç¿ëÇÏ¿©, ¾²±â ´ÜÀ§ ¿¬¼Ó ºí·Ï ÇÒ´ç ±â¹ý, Ç÷¡±× Àü´ÞÀ» ÅëÇÑ I/O ¸í·É º´ÇÕ ¹æÁö ±â¹ý, ¿øÀÚ¼º ¾²±â¸¦ Áö¿øÇÏ´Â SSD¸¦ ÅëÇØ MariaDBÀÇ ¿øÀÚ¼º ¾²±â¸¦ Áö¿øÇÏ´Â ¿¬±¸¸¦ ÁøÇàÇÏ¿´´Ù. Tpcc-mysql¿Í SysBench¸¦ »ç¿ëÇÏ¿© MariaDB¿¡ Á¦¾ÈµÈ ±â¹ýÀ» Àû¿ëÇÑ °á°ú, ¿øÀÚ¼º ¾²±â ±â¹ýÀÇ ¼º´ÉÀ» Æò°¡ÇÑ °á°ú, µ¥ÀÌÅͺ£À̽ºÀÇ Ã³¸®·®ÀÌ ÀÌÁß ¾²±â ¹öÆÛ ±â¹ýÀ» »ç¿ëÇÑ MariaDB ´ëºñ ¾à 40%¢¦50% Çâ»óµÈ °ÍÀ» È®ÀÎÇÏ¿´´Ù.
|
¿µ¹®³»¿ë (English Abstract) |
The atomic write technique is a good solution to solve the problem of the double write buffer. The atomic write technique needs modified I/O subsystems (i.e., file system and I/O schedulers) and a special SSD that guarantees the atomicity of the write request. In this paper, we propose the writing unit aligned block allocation technique (for EXT4 file system) and the merge prevention of requests technique for the CFQ scheduler. We also propose an atomic write-supporting SSD which stores the atomicity information in the spare area of the flash memory page. We evaluate the performance of the proposed atomic write scheme in MariaDB using the tpcc-mysql and SysBench benchmarks. The experimental results show that the proposed atomic write technique shows a performance improvement of 1.4¢¦1.5 times compared to the double write buffer technique.
|
Å°¿öµå(Keyword) |
µ¥ÀÌÅͺ£À̽º
¿øÀÚ¼º ¾²±â
I/O ¼ºê½Ã½ºÅÛ
SSD
database
atomic write
i/o subsystem
solid state
|
ÆÄÀÏ÷ºÎ |
PDF ´Ù¿î·Îµå
|