1 / 12

MySql Scaling

MySql Scaling. Presenters: Chris Schneider And Kevin Knapp. Intro. Consolidation methodologies Local vs Shared Local storage, NFS, iSCSI, Fiber File systems EXT3, XFS, VXFS and ZFS Sun hardware Innodb Performance Sharding. Local vs. SAN. Considerations Partitioning

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