Everything MySQL

A great place to be!

All Blog Posts Tagged 'failover' (1)

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

Monthly Archives

2011

2010

2009

RSS

© 2024   Created by Chris.   Powered by

Badges  |  Report an Issue  |  Terms of Service