RE: MySQL - Replication (Master/Slave) Question

2007-11-15 Thread Mike Johnson
From: Dan Rogart [mailto:[EMAIL PROTECTED] > On 11/14/07 4:01 PM, "Mike Johnson" > <[EMAIL PROTECTED]> wrote: > > > Correction to a couple of replies I've seen -- a slave > > server can have more than one master, but not to the same > > database. That is, Slave reads Database1 and Database3

RE: MySQL - Replication (Master/Slave) Question

2007-11-14 Thread bruce
-Original Message- From: Dan Rogart [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 14, 2007 1:07 PM To: Mike Johnson; Baron Schwartz; bruce Cc: mysql list Subject: Re: MySQL - Replication (Master/Slave) Question On 11/14/07 4:01 PM, "Mike Johnson" <[EMAIL PROTECTED]>

RE: MySQL - Replication (Master/Slave) Question

2007-11-14 Thread bruce
ible, can I get/see a sample my.cnf file illustrating how this can be handled thanks -Original Message- From: Dan Rogart [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 14, 2007 1:07 PM To: Mike Johnson; Baron Schwartz; bruce Cc: mysql list Subject: Re: MySQL - Replication (Master

Re: MySQL - Replication (Master/Slave) Question

2007-11-14 Thread Dan Rogart
On 11/14/07 4:01 PM, "Mike Johnson" <[EMAIL PROTECTED]> wrote: > Correction to a couple of replies I've seen -- a slave server can have > more than one master, but not to the same database. That is, Slave reads > Database1 and Database3 from Master1 and also reads Database2 from > Master2. > >

RE: MySQL - Replication (Master/Slave) Question

2007-11-14 Thread Mike Johnson
Correction to a couple of replies I've seen -- a slave server can have more than one master, but not to the same database. That is, Slave reads Database1 and Database3 from Master1 and also reads Database2 from Master2. You may actually be able to get down to the table level, but I'd have to check

Re: MySQL - Replication (Master/Slave) Question

2007-11-14 Thread Michael Dykman
On Nov 14, 2007 3:40 PM, bruce <[EMAIL PROTECTED]> wrote: > Hi... > > I have a number of servers that I want to treat as Master Servers or the > purpose of Replication.. > > I'd like to have each of the Master, have the Slave DB on the same machine. > Ie, a Slave server, might have 10 different Sla

Re: MySQL - Replication (Master/Slave) Question

2007-11-14 Thread Baron Schwartz
bruce wrote: Hi... I have a number of servers that I want to treat as Master Servers or the purpose of Replication.. I'd like to have each of the Master, have the Slave DB on the same machine. Ie, a Slave server, might have 10 different Slave Databases/config files, with each of the SlaveDB tie