The SF MySQL Meetup Group

Ronald Bradford talks about Successful MySQL Scalability

September 16, 2010 · 6:30 PM
CBS Interactive

Ronald Bradford has two decades of enterprise RDBMS industry experience with MySQL (10 years), Oracle (8 years) and Ingres (7 years) technologies. He provides independent advisory and consulting services, solving essential business continuity needs that address availability, scalability, and resilience. He is the 2009 MySQL Community member of the year. In 2010 he was recognized as an Oracle ACE Director and was co-author of the book Expert PHP and MySQL. You can find his presentations and writings at http://ronaldbradford... and on Twitter at @RonaldBradford and @MySQLExpert.

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 environment to provide a suitable architecture and application design to support these essential needs.

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 pre-emptive analysis
* Identifying when MySQL is not your bottleneck

Agenda:
6:30 - 7:00 -- Doors open/general socializing & food provided by Percona
7:00 - 7:15 -- Intro/announcements
7:15 - 8:00(ish) -- Main presentation by Ronald Bradford
8:00 - 9:00 -- Main presentation Q&A
9:00 - 10:00 -- General discussion/Q&A/networking/etc.
10:00ish -- post-event socializing... aka beers someplace nearby

Join or login to comment.

A former member

Slides can be found on Ronald's blog (vie SlideShare): http://ronaldbradford.com/blog/...

0 · September 27, 2010
Erin O'Neill

It was so great to have one of the MySQL guru's who doesn't even live in the bay area come talk to us about scalability! Such a treat. He was a good speaker, funny & made the night fly by.

0 · September 21, 2010
Henry Khachatryan

Thank you for this great presentation!

Just wanted to drop a quick note we (a vc-funded startup that is seeing great growth) are looking for some great LAMP developers in our SoMA offices.

If you're interested, drop me a line at [masked]

0 · September 17, 2010
mark

good

0 · September 17, 2010
Patrick R

Good overview of getting the foundation right for scalability. First Things First.

0 · September 17, 2010
Jon Todd

While not as detail oriented, it was very insightful and helpful for informing overall architecture decisions

0 · September 17, 2010
jd

Great presentations and stories Ronald!

My startup company is hiring a Sr. MySQL DBA for their Operations Team. We are online subscription billing Company, with an excellent pedigree that just completed our second consecutive $1B quarter in total billables.

If you are interested in learning more, ping me at
[masked]

We are located in Redwood Shores.

0 · September 16, 2010
A former member

Hey folks - I mentioned in the announcements that my company is hiring, so here's a little more information:

Mixpanel (http://mixpanel.com) is a real-time analytics company based in SF. We code mostly in python and js, and use mysql and mongodb heavily. We have funding and we're making money.

We are primarily looking for good python hackers, ops people, and badass db engineers.

http://mixpanel.com/jobs

Thanks!
Tim Trefren
[masked]

0 · September 16, 2010
Mike Tougeron

The recorded video can be found at: http://www.ustream.tv/recorded/...

0 · September 16, 2010