meeeejin/mysql-with-face

Flash Memory as Cache Extension for MySQL

MySQL with FaCE

Flash Memory as Cache Extension for MySQL 5.6.26.

FaCE is a new low-overhead caching strategy that uses flash memory as an extension to the RAM buffer of database systems. FaCE aims at improving the transaction throughput as well as shortening the recovery time from a system failure.

You can see the previous version of FaCE in here.

Documentation

Main features

• Caching dirty pages
• Multi-Vesion FIFO replacement
• Group replacement
• Group second chance

Configuration

You can add and set the value of parameter related to the SSD cache in the MySQL option file (my.cnf).

innodb_use_ssd_cache	Specifies whether to use SSD cache. true or false.
innodb_ssd_cache_file	The paths to SSD cache.
innodb_ssd_cache_size	The size in bytes of the SSD cache. The default value is 2GB.

my.cnf example:

#ssd cache settings
innodb_use_ssd_cache=true
innodb_ssd_cache_file=/home/mijin/test_data/ssd_cache.db
innodb_ssd_cache_size=10G

Reference

• Woon-Hak Kang, Sang-Won Lee, Bongki Moon, "Flash-based Extended Cache for Higher Throughput and Faster Recovery", Proceedings of the VLDB Endowment (PVLDB), Vol. 5, No. 11, pp. 1615-1626 (2012)
• Woon-Hak Kang, Sang-Won Lee, Bongki Moon, "Flash as cache extension for online transactional workloads", The VLDB Journal, Special Issue, Online ( 2015-11-30, pp 1-22 )
• Detailed presentaion

Project Details

Powerpoint slide on SlideShare