際際滷

際際滷Share a Scribd company logo

MySQL Deep dive with FusionIO

?
?
I Goo Lee
I Goo Lee

MySQL Deep dive with FusionIO

1 of 29
Downloaded 26 times
1 ??? MariaDB ???? FusionIO Atomic ??? Sales Engineering
2 MySQL(MariaDB) + Fusionio ??
3 FLASH? ???? ?? ??? ? ??????? FLASH???? ???? ??? ??? ? ??/?? I/O , ??? block size ? ??? ??? DB ??? HDD??? ??? ?? ?? ?? ? ??? ?? ?? ??? ???? ???? ? FLASH? ??? ???(????/bandwidth) ?????? ??? ? ????? ?? ?? ?? ? HDD ??? ??? ??????? Flash ??? ???? ??????? ???? ???, ?? application ?????. ? HDD? ???? ? ??, Flash? ?????? ???? ??? ? ?? ??? ?? ? ? ??.
4 MySQL ? ?? ? ?? ?? ?? ??? ?? ? ??? MySQL ??? storage engine? ?? parameter ??? ?? ? ?? ??? ?? tuning? ??? ? ???? ??(Oracle,Maria,Percona)? ? ??? ?? ?? ??? ??? ? ??? ???, ???, ??? ????? ?? ?? ??? C dev.mysql.com C percona.com C mariadb.com
5 Storage Engines MariaDB Percona Server Oracle MySQL XtraDB InnoDB XtraDB? InnoDB? ?? ??? ??, ?? ?? ??(??) ?? ?? ?? ??? Flash? ??? storage engine ? ?? ??? ?? ?? FLASH ??? ?? ??/???
6 MySQL 5.1.x (MariaDB 5.1,5.2,5.3) ? 5.1.x C ?? ?? ??????, ?????? ???.. C ?? ???? ??? MyISAM C Oracle MySQL 5.1.x ? Flash??? ????? ??(MariaDB/Percona) C Percona/MariaDB ?? ioMemory ??? ???? Flash ???? ? ??? ?? ???? MySQL 5.1.x ??? ???? ???, Flash ???? ???? ???? ??
7 MySQL 5.5.x (MariaDB 5.5.x) ? InnoDB? ?? Storage Engine?? ??? ? Linux? Async I/O ??? ???? ? ??? Platform ??(linux, windows, Solaris, AIX) ? ??? ?????(flash) ?? parameter ??? ? Fusion-IO? API ??? ??? (MariaDB 5.5.31+) ? ????? ????(FLASH)????? ?? ??? ?? ?? ? Fusionio???? Percona/MariaDB ? ?? ???? ??
8 MySQL 5.6.x (MariaDB 10.0.x) ? Oracle? 5.6 ???? FLASH? ?? parameter? ???? ?? ? Percona/MariaDB ???? ??? ?? ??? ? memcached interface? ??? ? ?? DB ??? ?? ? ??? ????? ??? ? ???? ?? CRC32 checksum? ??? ? Binlog group commit? ???, replication ?? ? ???? ??? ???(50% ??) ? 2013? 2? 5? ????. ? FLASH device? ?? API? ?? ?? ?? (Percona/MariaDB)
9 MySQL 5.7.x (MariaDB 10.1.x) ? Multi-threaded page flushing? ???? ? Fusion-io Atomic write ??? (Oracle, auto detected) ? Fusion-io NVM Compression support (Oracle, innoDB page compression) ? ???? ?? ??? ????
10 10 InnoDB/XtraDB Storage Engine innodb_buffer_pool_size=75G # DRAM allocated to mysql innodb_use_native_aio=1 # Use Asynchronous I/O innodb_log_block_size=4096 # XtraDB only, use 4k block for log file. Can add 25% extra performance. innodb_use_atomic_writes=1 # Fusion-io only, enable atomic I/O. XtraDB only innodb_log_files_in_group=2 # 2 log files, 4GB each. Recommended setting innodb_log_file_size=4G innodb_thread_concurrency=32 # Number of threads allowed inside storage engine innodb_flush_method = O_DIRECT # Use direct-io, not buffered innodb_io_capacity=25000 # Indication of much I/O can be submittet innodb_max_dirty_pages_pct=90 # When to start flush dirty memory pages more aggressively innodb_adaptive_flushing=1 # Flush dirty pages adaptively innodb_adaptive_flushing_method=keep_average # use the keep_average algorithm. XtraDB only innodb_read_ahead=0 # No need for read-ahead on seek-less storage innodb_flush_neighbor_pages=0 # No need for sequential flushing on seek-less storage
11 Tuning ??? ?? ????(SSD)?? ??
12 MySQL? ?? Tuning(VSL, Linux) ? ?? database??? ??, ?? ??(log,data)? Flash? ????. ? On-board DRAM? ???? BBWC(better backuped write cache)? ???? HDD? ????, log? HDD? ?? ???.. Fsync? ?? ?? Transaction ???. ? HDD? head ??? ??, ???? I/O? ???? ??? ???. ? ????? EXT4? XFS?? MySQL?? ?? ??? ?????. ? ?? VSL(Driver/Firmware)? ?????, ??? bug patch ? ????? ?????. ? ??: VSL 3.2.5?? + XFS??? ??? I/O Scheduler? ?????. ? ?? mySQL? Fusionio ?? ?? ???? ??? application???, 4K block format? ?????? ?? 5%? ? ?? ??? ?? ? ??. ? ?, ?? ? ?? direct-io? ?? ???sector size? ???(4k, 16k, 512b) ? mySQL??? ??? mount option? ??? ｀-o noatime,discard¨ for TRIM support ? TRIM? MySQL workload? ? ??? ??? ????, DBA/SE?? ?? file system ??? ???? copy/move ?? ??? ???
13 Tuning (cont.) ? ????? VSL(virtual storage layer)? ?? ??? ???, ??? ?? ??? ??? ? ?? C use_workqueue= ? ??? Linux? I/O stack? hocking ?? ??? ?? ? ?? C = 0 (default) I/O scheduler? bypass ??, VSL?? I/O schedule? ?? ??? ?. Latency? high-iops? ??? ?? ? ?? C =3 (linux I/O stack ??) ???? block layer? ???? ?. Kernel? I/O scheduler? ???? ??, ????? ??? ? ?? ? ??? ??? 2? ??? ioMemory ?? C ?? ?? ???? Raid0? ??? C ?? 512k chunk size? ?? C 2?? ??? ?? ??? log ?? ???? data? ?? ???, ?? ???? ???? ?? ? ? ?? C Read? ?? ?? ??
14 ???? MySQL ?? MySQL master MySQL slave MySQL slave MySQL slave Writes Reads
15 MySQL Block I/O? ?? ? Queue depth? ?? ?? (8-32) ? Read/ Write? ?? I/O ?? ??? ??? ???..bandwidth(X) ? Block ??? I/O ????? MySQL ?? ??? ?? ???. MySQL master Redo Logs Binary logs Data 512b buffered sequential sync read/write 512b buffered sequential sync writes 16k direct random a-sync read/write
16 MySQL ???? ? ?? 3?? ???? ?? mysql ???? ?? ?? C Sysbench (OLTP, I/O, memory and thread testing) C tpcc-mysql (TPC-C¨ish workload by Percona) C Linkbench (Facebook social graph benchmark) ? ??? mysql power group?? ???? script.
17 MySQL ?? ?? DATA? Dram? ???? ?? 75% active dataset ? DRAM? load?, CPU ???? ?? transaction ??? ?? ?? ?? ??? ???? ??, ?? ???? ????? ???, ????? Dram ??? caching ??? spike ??
18 Fusinoio? application ??? ?? ??: ??? ?? ??? ? ???´ ? ?? Software vendor?? ???? flash? DISK? ???? ??? ???? software? ???? ?? ? FLASH ??? ???, ???? ??, I/O Scheduler, Seek-less ????? ??, ?? ?? (I/O)? ?? ?? ? ? ? ?? I/O stack ??? ?? ?? ? ?? ?? file-system? ??? ?? ??
19 MySQL ? ?? NVM(FLASH) ???? PX600 and SX300 NVMFS file system MySQL Atomics NVM Compression ? Percona Server 5.6 ? MariaDB 10.0.10 ? Oracle MySQL 5.7.4 Atomics write(Maria 5.5.31+) ? NVM compression(Mariadb 10.1.x) ? ??? ?????????. NVMFS? Fusion-io(Sandisk)?? ??? File system??, 2015??? Open-source ? ?? ??: PX / SX ??? Atomic write/NVM compression? ?? ??: ioDrive/ioScale? ?? ??? ???
20 MySQL Atomic write(????) Value ?? MySQL ???? MySQL with Atomic Writes 20 Page CPage B Page A Buffe r DRAM Buffer SSD (or HDD) Database Database Server Page C Page B Page A Page C Page B Page A Page C Page B Page A ??????? A,B,C ? ?? update ??? ?? ???. 1 MySQL? ????? ???? Memory Buffer? copy ???. 2 MySQL? Media? ?? buffer ?? ??? ?????. 3 3? ??? ?????? ??? ??, MySQL? ????? ??? ?? tablespace? ?????. 4 ioMemory Database Page C Page B Page A DRAM Buffer Page C Page B Page A ??????? A,B,C ? ?? update ??? ?? ???. 1 MySQL? ????? ???? Memory Buffer? copy ???. 2 MySQL? ? ? ?? ??? bypass ?? ?? tablespace? ?? ????. ??? ??? ?? ???? ? write? ?? ???? ?? ????. 3 Database Server Page CPage B Page A
21 Atomics write? ?? ? Atomic write(????) ??? ?? Write ?? 2?~4? ? ?? ????? ?????. ? ? ?? ??? Media? ???? ???, 2x ??? ???? ?? ? ????. 1 - Double write 3 - Data read Dirty pages MySQL buffer pool MySQL dataset 2 - Data flush Double write buffer
22 MySQL NVM Compression(aka; InnoDB Page compression) Compressed Data 16K UNALLOCATED 16K = (32) 512B Sectors 8K = (16) 512B Sectors on Flash 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B Uncompressed Data16K ? ?? ?? ???? ?? ?? ? ???? 16KB??? AS-IS ??? ??? ? ? ????? ?? ???? ? ??? ? ???? ?? ??? ?? TRIM? ??? ? NVMFS file system? Media ??? ?? ? ?? ?????? ? ??? ??? ?? ?? ??? ???? ?? ??? ??. ? ?? ???
23 NVM Compression ?? ? MySQL ??? ?? ????? ?? ? Fusionio? ??? ???? DBMS? ??, ?? ??? ??? ? NVMFS?? ??? ?? ??? ? MariaDB? ? Innodb_compression_algorithm=2 Innodb_use_mt_flush=1 Innodb_mtflush_threads=16 CREATE TABLE <NAME> (<TABLE ATTRIBUTES>) ENGINE=InnoDB PAGE_COMPRESSED=1 PAGE_COMPRESSION_LEVEL=4;
24 NVM Compression ?? 100% 20% 90% 0% 20% 40% 60% 80% 100% Uncompressed Row Compression NVM-Compression Transaction Rate Compression Performance Penalty
25 NVMFS access program (???? ???) ? 1.0.2 GA ?? ?? ? Atomic Series ?? ????? OK~! ? Atomic/NVM Compression ??? ?? Demo Pool ?? ? MariaDB 10.1(Beta, 3?2? C innodb page compression / Atomic write ??) https://www.youtube.com/watch?v=CS6RrX6VreM ´SX300-1600 io Memory and NVMFS filesystem outran by 2.5 (!) hours in MySQL replication and Virident is still catching up, I'll know the exact time gap when completed.
26 MySQL resources ? www.percona.com ? www.mariadb.org/ ? www.mysql.com/ ? www.mysqlperformanceblog.com ? dimitrik.free.fr/blog/ ? MySQL welcome kit, best practices guide and case studies:http://www.fusionio.com/solutions/mysql/ ? NVMFS Video https://www.youtube.com/watch?v=CS6RrX6VreM ( replication ????)
27 Cost Capacity AMP ZetaScale ? Software FlashSoft? Software ioTurbine? Software SanDisk ION Accelerator? Performance (Bandwidth, IOPS, Latency) SanDisk ?????? ????? SplunkLive 2014 27
28 NVMFS / Atomic write / innodb page compression Torben Mathiasen ? ?? Principal Apps Engineer ? SanDisk(Fusionio 2010~)?? ??? ??,MariaDB /MySQL ? ??? NVMFS / Atomic Write / innoDB page compression? ?? ?? ??? ??, Fusionio ??? ?? ??/???? ?? software stack? ?? ?? ????. SanDisk(Fusionio 2010~)? ???? ?? HP?? 11?? BL??? architecture ? firmware ? ??? ?? ? ???, ??? embedded software stack? ?? ??/??/??? ?? ????. Linux Kernel(open)? ??? Ethernet, PCI-X, storage controller drivers / SCSI stack? ?? ??? ?? ????. ?? Spotify/Ebay/FB ? web-scale ???? ?? ?? ????.
29 Thank you! www.sandisk.com | www.fusionio.com changhoon.song@sandisk.com ? 2014 SanDisk Corporation. All rights reserved. SanDisk is a trademark of SanDisk Corporation, registered in the United States and other countries. ZetaScale is a trademark of SanDisk Enterprise IP LLC. Other brand names mentioned herein are for identification purposes only and may be the trademarks of their holder(s).

More Related Content

MySQL Deep dive with FusionIO

  • 1. 1 ??? MariaDB ???? FusionIO Atomic ??? Sales Engineering
  • 3. 3 FLASH? ???? ?? ??? ? ??????? FLASH???? ???? ??? ??? ? ??/?? I/O , ??? block size ? ??? ??? DB ??? HDD??? ??? ?? ?? ?? ? ??? ?? ?? ??? ???? ???? ? FLASH? ??? ???(????/bandwidth) ?????? ??? ? ????? ?? ?? ?? ? HDD ??? ??? ??????? Flash ??? ???? ??????? ???? ???, ?? application ?????. ? HDD? ???? ? ??, Flash? ?????? ???? ??? ? ?? ??? ?? ? ? ??.
  • 4. 4 MySQL ? ?? ? ?? ?? ?? ??? ?? ? ??? MySQL ??? storage engine? ?? parameter ??? ?? ? ?? ??? ?? tuning? ??? ? ???? ??(Oracle,Maria,Percona)? ? ??? ?? ?? ??? ??? ? ??? ???, ???, ??? ????? ?? ?? ??? C dev.mysql.com C percona.com C mariadb.com
  • 5. 5 Storage Engines MariaDB Percona Server Oracle MySQL XtraDB InnoDB XtraDB? InnoDB? ?? ??? ??, ?? ?? ??(??) ?? ?? ?? ??? Flash? ??? storage engine ? ?? ??? ?? ?? FLASH ??? ?? ??/???
  • 6. 6 MySQL 5.1.x (MariaDB 5.1,5.2,5.3) ? 5.1.x C ?? ?? ??????, ?????? ???.. C ?? ???? ??? MyISAM C Oracle MySQL 5.1.x ? Flash??? ????? ??(MariaDB/Percona) C Percona/MariaDB ?? ioMemory ??? ???? Flash ???? ? ??? ?? ???? MySQL 5.1.x ??? ???? ???, Flash ???? ???? ???? ??
  • 7. 7 MySQL 5.5.x (MariaDB 5.5.x) ? InnoDB? ?? Storage Engine?? ??? ? Linux? Async I/O ??? ???? ? ??? Platform ??(linux, windows, Solaris, AIX) ? ??? ?????(flash) ?? parameter ??? ? Fusion-IO? API ??? ??? (MariaDB 5.5.31+) ? ????? ????(FLASH)????? ?? ??? ?? ?? ? Fusionio???? Percona/MariaDB ? ?? ???? ??
  • 8. 8 MySQL 5.6.x (MariaDB 10.0.x) ? Oracle? 5.6 ???? FLASH? ?? parameter? ???? ?? ? Percona/MariaDB ???? ??? ?? ??? ? memcached interface? ??? ? ?? DB ??? ?? ? ??? ????? ??? ? ???? ?? CRC32 checksum? ??? ? Binlog group commit? ???, replication ?? ? ???? ??? ???(50% ??) ? 2013? 2? 5? ????. ? FLASH device? ?? API? ?? ?? ?? (Percona/MariaDB)
  • 9. 9 MySQL 5.7.x (MariaDB 10.1.x) ? Multi-threaded page flushing? ???? ? Fusion-io Atomic write ??? (Oracle, auto detected) ? Fusion-io NVM Compression support (Oracle, innoDB page compression) ? ???? ?? ??? ????
  • 10. 10 10 InnoDB/XtraDB Storage Engine innodb_buffer_pool_size=75G # DRAM allocated to mysql innodb_use_native_aio=1 # Use Asynchronous I/O innodb_log_block_size=4096 # XtraDB only, use 4k block for log file. Can add 25% extra performance. innodb_use_atomic_writes=1 # Fusion-io only, enable atomic I/O. XtraDB only innodb_log_files_in_group=2 # 2 log files, 4GB each. Recommended setting innodb_log_file_size=4G innodb_thread_concurrency=32 # Number of threads allowed inside storage engine innodb_flush_method = O_DIRECT # Use direct-io, not buffered innodb_io_capacity=25000 # Indication of much I/O can be submittet innodb_max_dirty_pages_pct=90 # When to start flush dirty memory pages more aggressively innodb_adaptive_flushing=1 # Flush dirty pages adaptively innodb_adaptive_flushing_method=keep_average # use the keep_average algorithm. XtraDB only innodb_read_ahead=0 # No need for read-ahead on seek-less storage innodb_flush_neighbor_pages=0 # No need for sequential flushing on seek-less storage
  • 12. 12 MySQL? ?? Tuning(VSL, Linux) ? ?? database??? ??, ?? ??(log,data)? Flash? ????. ? On-board DRAM? ???? BBWC(better backuped write cache)? ???? HDD? ????, log? HDD? ?? ???.. Fsync? ?? ?? Transaction ???. ? HDD? head ??? ??, ???? I/O? ???? ??? ???. ? ????? EXT4? XFS?? MySQL?? ?? ??? ?????. ? ?? VSL(Driver/Firmware)? ?????, ??? bug patch ? ????? ?????. ? ??: VSL 3.2.5?? + XFS??? ??? I/O Scheduler? ?????. ? ?? mySQL? Fusionio ?? ?? ???? ??? application???, 4K block format? ?????? ?? 5%? ? ?? ??? ?? ? ??. ? ?, ?? ? ?? direct-io? ?? ???sector size? ???(4k, 16k, 512b) ? mySQL??? ??? mount option? ??? ｀-o noatime,discard¨ for TRIM support ? TRIM? MySQL workload? ? ??? ??? ????, DBA/SE?? ?? file system ??? ???? copy/move ?? ??? ???
  • 13. 13 Tuning (cont.) ? ????? VSL(virtual storage layer)? ?? ??? ???, ??? ?? ??? ??? ? ?? C use_workqueue= ? ??? Linux? I/O stack? hocking ?? ??? ?? ? ?? C = 0 (default) I/O scheduler? bypass ??, VSL?? I/O schedule? ?? ??? ?. Latency? high-iops? ??? ?? ? ?? C =3 (linux I/O stack ??) ???? block layer? ???? ?. Kernel? I/O scheduler? ???? ??, ????? ??? ? ?? ? ??? ??? 2? ??? ioMemory ?? C ?? ?? ???? Raid0? ??? C ?? 512k chunk size? ?? C 2?? ??? ?? ??? log ?? ???? data? ?? ???, ?? ???? ???? ?? ? ? ?? C Read? ?? ?? ??
  • 14. 14 ???? MySQL ?? MySQL master MySQL slave MySQL slave MySQL slave Writes Reads
  • 15. 15 MySQL Block I/O? ?? ? Queue depth? ?? ?? (8-32) ? Read/ Write? ?? I/O ?? ??? ??? ???..bandwidth(X) ? Block ??? I/O ????? MySQL ?? ??? ?? ???. MySQL master Redo Logs Binary logs Data 512b buffered sequential sync read/write 512b buffered sequential sync writes 16k direct random a-sync read/write
  • 16. 16 MySQL ???? ? ?? 3?? ???? ?? mysql ???? ?? ?? C Sysbench (OLTP, I/O, memory and thread testing) C tpcc-mysql (TPC-C¨ish workload by Percona) C Linkbench (Facebook social graph benchmark) ? ??? mysql power group?? ???? script.
  • 17. 17 MySQL ?? ?? DATA? Dram? ???? ?? 75% active dataset ? DRAM? load?, CPU ???? ?? transaction ??? ?? ?? ?? ??? ???? ??, ?? ???? ????? ???, ????? Dram ??? caching ??? spike ??
  • 18. 18 Fusinoio? application ??? ?? ??: ??? ?? ??? ? ???´ ? ?? Software vendor?? ???? flash? DISK? ???? ??? ???? software? ???? ?? ? FLASH ??? ???, ???? ??, I/O Scheduler, Seek-less ????? ??, ?? ?? (I/O)? ?? ?? ? ? ? ?? I/O stack ??? ?? ?? ? ?? ?? file-system? ??? ?? ??
  • 19. 19 MySQL ? ?? NVM(FLASH) ???? PX600 and SX300 NVMFS file system MySQL Atomics NVM Compression ? Percona Server 5.6 ? MariaDB 10.0.10 ? Oracle MySQL 5.7.4 Atomics write(Maria 5.5.31+) ? NVM compression(Mariadb 10.1.x) ? ??? ?????????. NVMFS? Fusion-io(Sandisk)?? ??? File system??, 2015??? Open-source ? ?? ??: PX / SX ??? Atomic write/NVM compression? ?? ??: ioDrive/ioScale? ?? ??? ???
  • 20. 20 MySQL Atomic write(????) Value ?? MySQL ???? MySQL with Atomic Writes 20 Page CPage B Page A Buffe r DRAM Buffer SSD (or HDD) Database Database Server Page C Page B Page A Page C Page B Page A Page C Page B Page A ??????? A,B,C ? ?? update ??? ?? ???. 1 MySQL? ????? ???? Memory Buffer? copy ???. 2 MySQL? Media? ?? buffer ?? ??? ?????. 3 3? ??? ?????? ??? ??, MySQL? ????? ??? ?? tablespace? ?????. 4 ioMemory Database Page C Page B Page A DRAM Buffer Page C Page B Page A ??????? A,B,C ? ?? update ??? ?? ???. 1 MySQL? ????? ???? Memory Buffer? copy ???. 2 MySQL? ? ? ?? ??? bypass ?? ?? tablespace? ?? ????. ??? ??? ?? ???? ? write? ?? ???? ?? ????. 3 Database Server Page CPage B Page A
  • 21. 21 Atomics write? ?? ? Atomic write(????) ??? ?? Write ?? 2?~4? ? ?? ????? ?????. ? ? ?? ??? Media? ???? ???, 2x ??? ???? ?? ? ????. 1 - Double write 3 - Data read Dirty pages MySQL buffer pool MySQL dataset 2 - Data flush Double write buffer
  • 22. 22 MySQL NVM Compression(aka; InnoDB Page compression) Compressed Data 16K UNALLOCATED 16K = (32) 512B Sectors 8K = (16) 512B Sectors on Flash 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B 512B Uncompressed Data16K ? ?? ?? ???? ?? ?? ? ???? 16KB??? AS-IS ??? ??? ? ? ????? ?? ???? ? ??? ? ???? ?? ??? ?? TRIM? ??? ? NVMFS file system? Media ??? ?? ? ?? ?????? ? ??? ??? ?? ?? ??? ???? ?? ??? ??. ? ?? ???
  • 23. 23 NVM Compression ?? ? MySQL ??? ?? ????? ?? ? Fusionio? ??? ???? DBMS? ??, ?? ??? ??? ? NVMFS?? ??? ?? ??? ? MariaDB? ? Innodb_compression_algorithm=2 Innodb_use_mt_flush=1 Innodb_mtflush_threads=16 CREATE TABLE <NAME> (<TABLE ATTRIBUTES>) ENGINE=InnoDB PAGE_COMPRESSED=1 PAGE_COMPRESSION_LEVEL=4;
  • 24. 24 NVM Compression ?? 100% 20% 90% 0% 20% 40% 60% 80% 100% Uncompressed Row Compression NVM-Compression Transaction Rate Compression Performance Penalty
  • 25. 25 NVMFS access program (???? ???) ? 1.0.2 GA ?? ?? ? Atomic Series ?? ????? OK~! ? Atomic/NVM Compression ??? ?? Demo Pool ?? ? MariaDB 10.1(Beta, 3?2? C innodb page compression / Atomic write ??) https://www.youtube.com/watch?v=CS6RrX6VreM ´SX300-1600 io Memory and NVMFS filesystem outran by 2.5 (!) hours in MySQL replication and Virident is still catching up, I'll know the exact time gap when completed.
  • 26. 26 MySQL resources ? www.percona.com ? www.mariadb.org/ ? www.mysql.com/ ? www.mysqlperformanceblog.com ? dimitrik.free.fr/blog/ ? MySQL welcome kit, best practices guide and case studies:http://www.fusionio.com/solutions/mysql/ ? NVMFS Video https://www.youtube.com/watch?v=CS6RrX6VreM ( replication ????)
  • 27. 27 Cost Capacity AMP ZetaScale ? Software FlashSoft? Software ioTurbine? Software SanDisk ION Accelerator? Performance (Bandwidth, IOPS, Latency) SanDisk ?????? ????? SplunkLive 2014 27
  • 28. 28 NVMFS / Atomic write / innodb page compression Torben Mathiasen ? ?? Principal Apps Engineer ? SanDisk(Fusionio 2010~)?? ??? ??,MariaDB /MySQL ? ??? NVMFS / Atomic Write / innoDB page compression? ?? ?? ??? ??, Fusionio ??? ?? ??/???? ?? software stack? ?? ?? ????. SanDisk(Fusionio 2010~)? ???? ?? HP?? 11?? BL??? architecture ? firmware ? ??? ?? ? ???, ??? embedded software stack? ?? ??/??/??? ?? ????. Linux Kernel(open)? ??? Ethernet, PCI-X, storage controller drivers / SCSI stack? ?? ??? ?? ????. ?? Spotify/Ebay/FB ? web-scale ???? ?? ?? ????.
  • 29. 29 Thank you! www.sandisk.com | www.fusionio.com changhoon.song@sandisk.com ? 2014 SanDisk Corporation. All rights reserved. SanDisk is a trademark of SanDisk Corporation, registered in the United States and other countries. ZetaScale is a trademark of SanDisk Enterprise IP LLC. Other brand names mentioned herein are for identification purposes only and may be the trademarks of their holder(s).