Tompkins Neil wrote:
Hi
We are looking to upgrade our version of mySQL to the latest version of
mySQL 5. One of the main features we are going to think about using is
replication for our website data. Basically we have 2 websites located in
the UK and US which share similar information, and we
Date: Mon, 17 Nov 2008 10:16:16 +
From: Tompkins Neil [EMAIL PROTECTED]
Subject: Using Replication in mySQL version 5
We are looking to upgrade our version of mySQL to the latest version of
mySQL 5. One of the main features we are going to think about using is
replication for our website
You'll want an alert to page you when the replication slaves stop for an
error; look for Matthew Montgomery's script; we added paging and an
'autofix' step to correct a limited number of duplicate key errors (and
email when it does so); I page for other errors. We've had M-M 5.0
replication and
You will probably want to set read_only = 1 in the my.cnf on the slave so
only super users can change tables. If you do partial replication, you must
be sure your developers do not cross-reference schemas where one is
replicated and the other is not. You will either get a replication error