Re: Using Replication in mySQL version 5

2008-11-20 Thread Jed Reynolds
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

Re: Using Replication in mySQL version 5

2008-11-19 Thread Jim Lyons
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

RE: Using Replication in mySQL version 5

2008-11-19 Thread Mary Bahrami
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

Re: Using Replication in mySQL version 5

2008-11-19 Thread Roman Eberle
>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

Using Replication in mySQL version 5

2008-11-17 Thread Tompkins Neil
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