I will be joining a great list of quality speakers including John Allspaw, Theo Schlossnagle, Rasmus Lerdorf and Tom Cook at Surge 2010 in Baltimore, Maryland on Thu 30 Sep, and Fri Oct 1st 2010. 
My presentation on “The most common MySQL scalability mistakes, and how to avoid them.” will include discussing various experiences observed in the field as a MySQL Consultant and MySQL Performance Tuning expert.
Abstract:
The most common mistakes are easy to avoid however many startups continue to fall prey, with the impact including large re-design costs, delays in new feature releases, lower staff productivity and less then ideal ROI. All growing and successful sites need to achieve higher Availability, seamless Scalability and proven Resilience. Know the right MySQL environments to provide a suitable architecture and application design to support these essential needs.
Overview:
Some details of the presentation would include:
- The different types of accessible data (e.g. R/W, R, none)
- What limits MySQL availability (e.g software upgrades, blocking statements, locking etc)
- The three components of scalability – Read Scalability/Write Scalability/Caching
- Design practices for increasing scalability and not physical resources
- Disaster is inevitable. Having a tested and functional failover strategy
- When other products are better (e.g. Static files, Session management via Key/Value store)
- What a lack of accurate monitoring causes
- What a lack of breakability testing causes
- What does “No Downtime” mean to your organization.
- Implementing a successful “failed whale” approach with preemptive analysis
- Identifying when MySQL is not your bottleneck
Would *LOVE* to have you come to the SF MySQL Meetup at CBSi (old CNET bldg) and give this talk! Don’t you come back to the mothership down in redwood city ever?
http://sfmysql.org
Ronald,
Do you have the slides up anywhere?
Apologies. I have the attention span of a gnat.
Would appreciate if you posted a comment here when you do have the slides. I always enjoy reading and keeping up to date. I promise with more detail than the blog post. I just go link hunting to add to my “Technical Presentations” folder.