Everything MySQL

A great place to be!

All Blog Posts Tagged 'MySQL' (2)

MySQL HA Presentation from Oracle's MySQL Sunday

MySQL Sunday at Oracle's Open world was a huge success given that it was MySQL's first year at the conference. I had a lot of fun and even a little excitement when a shirt caught fire during my presentation.



Just added a video to the site for MySQL High Availability. Check it out here if you missed it at MySQL Sunday, also, you can get the slides in PDF format… Continue

Added by Chris on September 28, 2010 at 2:00pm — No Comments

Basics of MySQL failover (using replication)

For easy MySQL failover, replication is a great solution. This post will cover the basics of performing a failover in case your master dies.

First, setup one-way replication (or two-way, but don't plan to use both servers for writes at the same time). Next, you'll want to direct all activity, or at least the writes, to the master. If the master dies, there are two major concerns:

  1. Redirecting the clients to the slave. There are several ways to handle this, such as…
Continue

Added by Sarah Sproehnle on October 21, 2009 at 8:50am — 2 Comments

RSS

© 2024   Created by Chris.   Powered by

Badges  |  Report an Issue  |  Terms of Service