120 likes | 252 Views
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
E N D
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 • Type of disk and setup • Backups • LVM, mysqldump, parallel, rdiff, innodb hot backup • The key is to Benchmark • Sysbench • Supersmack • Home grown
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
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
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
Q & A • Questions