Update/Clarification:
It's apparent that you need a master->slaveDB, and that I can have multiple
slaveDBs on the slave server. But can I setup all the slaveDBs on a single
machine.
Thanks
hi...
in very basic terms/pics...
i have :
masterServer1
masterDB1
my.cnf
masterServer2
masterDB2
my.cnf
.
.
.
masterServerN
masterDBN
my.cnf
this gets me N masterServers, each with it's own my.cnf file, as well as
it's own masterDB.
I'd like to be able to have the master servers have a slave. Under normal
situations (per docs i've seen) the slave would be on a machine, with a
slaveDB that matches the masterDB in terms of TBLs, and it's own my.conf to
handle the interface between the slave/master.
In my situation, I'd like to be able to simply have all the slave DBs, and
my.conf information on the same box. Given that I can easily have multiple
DBs on a mySQL app, my question appears to come down to how to handle the
my.cnf information. I don't see how I can handle multiple my.cnf files that
are separate, so is there a way to have all the information for the various
slave DBs in the same my.cnf file.
Or would I essentially have to have multiple instances of mySQL running, and
use a different my.cnf for each instance, which would be a pain!!
Or am I tilting at windmills here....
If this is at all possible, 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/Slave) Question
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.
>
> You may actually be able to get down to the table level, but I'd have to
> check on that. Not likely, though.
>
> As for how to set it all up, don't ask me. I just enjoy the results.
> :)
>
> (apologies if you get a dupe, Baron -- I accidentally hit reply, not
> reply-to-all)
I would be very interested in hearing more about how you set this up,
because as far as I know it's impossible for a slave to have more than one
master at any given time.
Are you using some kind of time based rotation that changes the master info
on the slave periodically or something?
-Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
