September 16, 2010 6:30 PM. 67 attended.

Ronald Bradford talks about Successful MySQL Scalability

CBS Interactive (map)

Selected By: erin

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

  • Mike Tougeron
    Mike Tougeron

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

    Posted September 16, 2010 at 9:37 PM
  • 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
    tim@mixpanel.com

    Posted September 16, 2010 at 9:48 PM
  • jd
    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
    jay.dack@gmail.com

    We are located in Redwood Shores.

    Posted September 16, 2010 at 10:24 PM
  • Henry Khachatryan
    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 hkhachatryan@me.com

    Posted September 17, 2010 at 1:19 PM
  • Chris Barmonde
    Chris Barmonde

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

    Posted September 27, 2010 at 3:21 PM
  • You must be a member to post a comment. Join or login.

67 attended
4.50 4.5010 (10 ratings)

Percona

Food, drinks, books and speakers.

Continuent

Logo, signs & swag.

IGN Entertainment

Time, money, swag, food, drinks & facilities

CBS Interactive

Food, beverages & facilities

O'Reilly User Group Program

The O'Reilly User Group Program provides the great books we get monthly.

MySQL

A great database for us all to use! :)

People in this
Meetup are also in:

Log in

Not registered with us yet?

Sign up

Meetup members, Log in

or
By clicking the "Sign up using Facebook" or "Sign up" buttons above, you agree to Meetup's Terms of Service