Tricks and Tradeoffs of Deploying MySQL Clusters in the Cloud

Thorsten von Eicken (RightScale, Inc)
Average rating: ****.
(4.67, 3 ratings)

Launching MySQL databases in the cloud makes many DBA’s dreams come true, but it can also also challenge basic assumptions, such as the durability of disk storage. Setting up MySQL in the cloud requires rethinking, which can result in a more complex set-up on day one, but the reward is more flexibility. This session will explore lessons learned at RightScale in deploying thousands of production MySQL databases on the cloud for real customers and will help attendees understand why the flexibility of running databases in the cloud is worth more than the loss of control over the hardware.

For example, attendees can learn about the special characteristics of Amazon EC2 and how to set-up MySQL with replication and continuous backups to S3. We will examine configurations used by a number of startups on EC2. Also, Amazon has recently launched the Elastic Block Store (EBS), providing a virtually infinite SAN storage array in the sky. This has changed the way MySQL can be deployed and managed dramatically. Deploying MySQL in the cloud is now far more flexible than using traditional hosting. It is far easier to set up replicas for special purposes, to run slave databases in other datacenters for availability purposes, or to move the database to larger machines as the load increases. In the talk, we can explain how to set up MySQL using EBS and all the little tradeoffs and tricks it takes, such as how to move a database to a larger machine with minimal downtime and how to set-up mysql redundantly to allow failover to a different datacenter.

RightScale is the leader in cloud computing management and has already launched thousands of MySQL clusters in the cloud. The MySQL management automation provided on the RightScale dashboard enables push-button management of a master/slave MySQL deployment, from deploying the initial master and slave, promoting a slave to master after a failure, to setting up a new slave. This level of automation enables new ways of using servers to simplify the overall database management. Cloning the entire multi-server MySQL deployment to set up a staging or scalability test system turns into only minutes of work. Adding a slave to run some one-off reports or to perform consistency checks is similarly easy, and when the job is done, it takes only a click to make it go away again. In many ways this is a DBA’s heaven, but only as long as the tasks are automated!

Photo of Thorsten von Eicken

Thorsten von Eicken

RightScale, Inc

Thorsten von Eicken is founder and CTO of RightScale, Inc. Before joining RightScale, Thorsten was Chief Architect at Expertcity.com and Citrix Online, makers of GoToMyPC, GoToMeeting, GoToWebinar, and GoToAssist. He was responsible for the overall architecture of these online services and also managed the 24/7 datacenter operations which allowed him to acquire deep knowledge in deploying and running secure scalable online services. Thorsten received his Ph.D. from UC Berkeley and was a professor of computer science at Cornell University.

Comments on this page are now closed.

Comments

Picture of Sheeri K. Cabral
Sheeri K. Cabral
07/30/2009 9:13am PDT

Watch the full video on YouTube (much easier) at www.youtube.com/watch?v=9Qc...

Picture of Sheeri K. Cabral
Sheeri K. Cabral
07/06/2009 4:34pm PDT

People have reported that the “play” link loads for 15-20 minutes before actually streaming the content; however, the download link works just fine. I apologize for any inconvenience.

Picture of Sheeri K. Cabral
Sheeri K. Cabral
06/25/2009 7:34am PDT

Play the video directly in your browser at technocation.org/node/744/play or download it at technocation.org/node/744/d...

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com

Download the MySQL Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.