addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1linklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonprintShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

MySQL High Availability Solutions - an overview

The MySQL Server open source relational database system (RDBMS) is widely used as the storage backend for dynamic web sites and applications. In many areas it has become a mission-critical component of the software stack, where downtime is not an option. There are many ways to ensure the availability of a MySQL Server and how to provide redundancy and fault-tolerance.

In this talk, Lenz Grimmer (blog / twitter) will give an overview about some best practices and commonly used HA solutions and technologies for MySQL. The talk will cover the commonly used Open Source components and tools, primarily focusing on Linux.

The session will start with a brief introduction to High Availability (HA), the terminology and general concepts involved. Afterwards, several MySQL HA solutions and technologies will be introduced and explained, e.g. MySQL replication (and possible topologies), block device replication (DRBD), Shared storage/SAN, Linux-Heartbeat/Pacemaker, MySQL Cluster, MySQL Proxy and other clustering solutions.


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 Lenz Grimmer
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

Event Sponsors:



About Amazon Web Services

Since early 2006, Amazon Web Services (AWS) has provided companies of all sizes with an infrastructure web services platform in the cloud. With AWS you can requisition compute power, storage, and other services–gaining access to a suite of elastic IT infrastructure services as your business demands them. With AWS you have the flexibility to choose whichever development platform or programming model makes the most sense for the problems you’re trying to solve. You pay only for what you use, with no up-front expenses or long-term commitments, making AWS the most cost-effective way to deliver your application to your customers and clients. And, with AWS, you can take advantage of Amazon.com’s global computing infrastructure that is the backbone of Amazon.com’s multi-billion retail business and transactional enterprise whose scalable, reliable, and secure distributed computing infrastructure has been honed for over a decade.


About Percona Live

Presented by Percona, Live is a one day conference on February 16th, 2011 that takes a look at the new options that are available beyond MySQL 5.1. MySQL 5.5 has now officially been released as stable; Percona Server offers a range of performance and diagnostic enhancements, and MariaDB is adding more features with the help of the community. How will these new releases benefit you, and what does the upgrade process look like?


About GameSpot.com

Nobody knows games and gamers like GameSpot. Our love of games combined with our experience, innovation, and commitment makes GameSpot the standard for all things gaming. For 15 years, we've been 100-percent focused on games. We understand that today's gamers play for many different reasons, and we're able to engage this growing number of diverse gamers no matter why they hit play.


About O'Reilly

O'Reilly Media spreads the knowledge of innovators through its books, online services, magazines, research, and conferences. Since 1978, O'Reilly has been a chronicler and catalyst of leading-edge development, homing in on the technology trends that really matter and galvanizing their adoption by amplifying "faint signals" from the alpha geeks who are creating the future. An active participant in the technology community, the company has a long history of advocacy, meme-making, and evangelism.

Join or login to comment.

  • A former member
    A former member

    Good overview, covered lot of topics

    January 27, 2011

  • A former member
    A former member

    it's always an inspiration to see a vibrant well run meetup!

    January 27, 2011

  • A former member
    A former member

    Extremely basic

    January 27, 2011

  • Dave S.

    Lenz Grimmer did a fantastic job on MySQL Availability.

    January 27, 2011

  • A former member
    A former member

    Interesting and Very well presented !

    January 26, 2011

  • Tom T.

    Lenz Grimmer of Oracle made an interesting and thorough presentation about the issue of keeping a MySQL database up and running during various hardware malfunction scenarios.

    January 26, 2011

  • A former member
    A former member

    if any one would like to talk with me about the IOUG MySQL council, OSCON, or the OurSQL podcast you can find me on twitter - @sarahnovotny

    January 26, 2011

  • Robert H.

    Great talk! If you want to find out about Tungsten Replicator, check out our Thursday webinar at 10am pst--sign up at www.continuent.com. Thank again Lenz!

    January 26, 2011

  • FelhoBacsi

    Thank you very much!

    January 26, 2011

  • A former member
    A former member

    January 26, 2011

  • FelhoBacsi

    What is the URL of the kindle game?

    January 26, 2011

Our Sponsors

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy