Past Meetup

MySQL High Availability Solutions - an overview

This Meetup is past

160 people went

Location image of event venue

Details

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 (http://www.lenzg.net/) / twitter (http://twitter.com/lenzgr)) 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 (http://aws.amazon.com/)
http://photos3.meetupstatic.com/photos/sponsor/2/6/f/b/iab120x90_129979.jpeg (http://aws.amazon.com/)
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 (http://www.percona.com/events/percona-live-san-francisco-2011/)
http://photos1.meetupstatic.com/photos/sponsor/7/a/c/0/iab120x90_31424.jpeg (http://www.percona.com/events/percona-live-san-francisco-2011/)
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 (http://www.gamespot.com/)
http://photos4.meetupstatic.com/photos/sponsor/6/c/a/iab120x90_1738.jpeg (http://www.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
http://photos1.meetupstatic.com/photos/sponsor/7/1/2/iab120x90_1810.jpeg (http://oreilly.com/)
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.

See all Meetups from #SFMySQL Meetup