Mysql scaling
Download
1 / 12

MySql Scaling - PowerPoint PPT Presentation


  • 111 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' MySql Scaling' - mira-long


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Mysql scaling

MySql Scaling

Presenters:

Chris Schneider

And Kevin Knapp


Intro
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
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
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
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
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


ad