1 / 20

scaling MySQL in 3d

Learn about scaling MySQL in a three-dimensional approach that encompasses storage choices, engine options, and high volume reads and writes. Discover how to optimize performance, choose the right filesystem, and manage large datasets efficiently.

erlene
Download Presentation

scaling MySQL in 3d

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. scaling MySQL in 3d sarah novotny – sarah@bluegecko.net open databases and LAMP services www.BlueGecko.net

  2. things you’ve heard about scale write 1 / read many partitioning / sharding multimaster / rings memcached / nosql www.BlueGecko.net

  3. large datasets • high volume reads • high volume writes http://www.flickr.com/photos/elbragon www.BlueGecko.net

  4. storage choices engine options storage engine filesystem volume manager hardware http://www.flickr.com/photos/shuttercat7 www.BlueGecko.net

  5. large datasets large objects many rows http://www.flickr.com/photos/olivander www.BlueGecko.net

  6. storage flexibility, reliability, clone-ability http://www.flickr.com/photos/wwworks www.BlueGecko.net

  7. http://www.flickr.com/photos/alreadytaken www.BlueGecko.net

  8. high volume reads more memory fast disks more memory http://www.flickr.com/photos/teclasorg www.BlueGecko.net

  9. myisam vs innodb http://www.flickr.com/photos/redjar www.BlueGecko.net

  10. not to be obvious, but -- read less data! compress data (if you can) don’t use limit http://www.flickr.com/photos/rogersmith www.BlueGecko.net

  11. use thoughtful primary keys www.BlueGecko.net

  12. a short diversion to swap or not to swap that is the question www.BlueGecko.net

  13. high volume reads writes more memory fast disks more memory fast disks http://www.flickr.com/photos/teclasorg www.BlueGecko.net

  14. high volume writes choose your filesystem well understand how your filesystem and raid controller work together tune them to work in concert www.BlueGecko.net

  15. facebook game case: highly concurrent writes low risk of -- omg, i lost my most recent score! www.BlueGecko.net

  16. shard data innodb_log_flush_at_trx_commit=0 benchmark i/o schedulers www.BlueGecko.net

  17. free tools innotop maatkit MySQL proxy monitoring/trending cacti templates $monitoring_server – the one you know www.BlueGecko.net

  18. additional resources • irc.freenode.org • #mysql • #maatkit • mysql.com • HPM2e -Baron Schwartz, Peter Zaitsev, Vadim Tkachenko, and Jeremy Zawodny www.BlueGecko.net

  19. credits swap image http://www.vocw.edu.vn/content/m10106/latest/ special thanks to gabriel cain and mike hamrick for suggestions on content and slides www.BlueGecko.net

  20. Blue Gecko and contact info • sarah@bluegecko.net • sarah.novotny@gmail.com • @sarahnovotny • @bluegecko • senk on #mysql Blue Gecko provides Remote DBA services for companies around the world 7x24x365 support including monitoring, performance analysis, proactive maintenance and architectural guidance for small and large datasets. www.BlueGecko.net

More Related