1 / 12

MySql Scaling

Join Chris Schneider and Kevin Knapp as they explore MySQL scaling methodologies, including local vs. shared storage solutions, and the impact of different file systems like EXT3, XFS, and ZFS on performance. This presentation highlights key considerations for optimizing InnoDB and MyISAM configurations, effective backup strategies, and the importance of benchmarking with tools like Sysbench and Supersmack. Discover real-world case studies, including shared hosting environments with thousands of users, and learn how to enhance your MySQL database performance through best practices and insightful Q&A.

keiki
Download Presentation

MySql Scaling

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. MySql Scaling Presenters: Chris Schneider And Kevin Knapp

  2. Intro • Consolidation methodologies • Local vs Shared • Local storage, NFS, iSCSI, Fiber • File systems • EXT3, XFS, VXFS and ZFS • Sun hardware • Innodb Performance • Sharding

  3. Local vs. SAN • Considerations • Partitioning • Type of disk and setup • Backups • LVM, mysqldump, parallel, rdiff, innodb hot backup • The key is to Benchmark • Sysbench • Supersmack • Home grown

  4. Test on different file systems • EXT3 • Traditional and widely used • XFS • Has been great to work with in my experience • Show best performance in in my benchmarks • ZFS • Snapshots with no penalties

  5. The Tortus and the Hare • Waterfalls • Seven Falls • Niagra • The case study: • Shared hosting environment • Hundreds of thousands of users • Users with almost full autonomy • MySql 4.0, 4.1 and 5.0

  6. Comparison Breakdown

  7. MySql Instances Focus

  8. Systems Focus

  9. Number of Systems

  10. Datacenter Space

  11. Performance • Memory Allocations • Optimized SQL • Normalize till it hurts denormalize till it works • Innodb vs MyISAM • Transactions and concurrent inserts • Timing and location of script and backup execution • Recoverability • Point in time

  12. Q & A • Questions

More Related