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
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
tellin
M-M 5.0
replication and M-S 5.1 replication configs running okay for a while
-Original Message-
From: Tompkins Neil [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2008 2:16 AM
To: [MySQL]
Subject: Using Replication in mySQL version 5
Hi
We are looking to upgrade our versi
>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 abou
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 are going to be using
r