1 / 15

Answering the Database Scale Out Problem: SSDs in the Data Center April 14, 2010

Answering the Database Scale Out Problem: SSDs in the Data Center April 14, 2010 Dan Marriott Director - Production Operations danm@answers.com. Answers.com. The world’s leading Q&A site Rank in top Web properties # 18 in the U.S. (02/2010) (1) # 31 worldwide (02/2010) (1)

joben
Télécharger la présentation

Answering the Database Scale Out Problem: SSDs in the Data Center April 14, 2010

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. Answering the Database Scale Out Problem:SSDs in the Data Center April 14, 2010 Dan MarriottDirector - Production Operationsdanm@answers.com

  2. Answers.com • The world’s leading Q&A site • Rank in top Web properties • #18in the U.S. (02/2010)(1) • #31worldwide (02/2010) (1) • Unique monthly visitors • 50 million in the U.S. (02/2010)(1) • 72 million worldwide (02/2010) (1) (1) Source: comScore – Hybrid Measurement Methodology (U.S. only) beginning August 2009

  3. ReferenceAnswers

  4. WikiAnswers: Q&A the Wiki Way

  5. Database layer • MySQL 5.0.87-b20-percona • MySQL 5.0.51a

  6. Challenges • Keep site fast • while site traffic and stored data are ever-increasing • Replication lag = 0 • or users get stale data • Forever being forced to further optimize queries • constantly vying for dev resources to do this • Controlling hardware growth (Cap & OpEx $$$) • regularly adding servers to handle growth

  7. Handling high growth – database tier • Separate reads and writes • Add more read DB slaves • Use Memcached where possible • Optimize Queries • Partition large databases _________ Started hitting a wall: Replication Lag even when servers handling modest # queries/sec

  8. Typical DB read cluster

  9. Fusion-io for HP Blade Servers • March ’09: HP announce IO Accelerator card for blades (manuf. by Fusion-io) • Sizes: • 80 & 160GB SLC • 320GB MLC • April ’09: received two cards – began testing

  10. Easy to install • One man job. Takes 60 secs.

  11. Performance Tests Additionally, CPU load dropped from 30% to 18% (even with Fusion-io driver overhead)

  12. Typical DB read cluster

  13. Fusion-io Value Add for Answers.com • Scalability. >Twice the performance capacity on 1/4 servers • 100% ROI on day of purchase (repurpose other 3/4) • 75% reduction in operating costs: • Rack Space, Power and Cooling • Server Administration • Database Administration • 75% fewer failure points

  14. Other SSD uses in the Data Center • Varnish (Web caching layer) • DB Backup Servers • Log Analysis • Data Warehouse

  15. Thank you. Slideshow: http://tinyurl.com/mysqlconf2010-ssd-dan

More Related