hi keith...

i recognize you can't do multiple masters to a single slave with mysql's
replication.

but you can setup separate mysql slave dbs that are independent, and that yo
can then iteratively walk through each slave/master, one at a time, and then
do the sync/update for each one... this essentially gets you the
slave/master replication for each server, replicated to the slave db on the
system. the result is a bunch of different slave dbs, instead of a single
db...

however, that didn't get me my answer to my question...

so, how can you do a "replicate-do-db" from within the mysql cmd???

in fact, even if i only had a single master, but multiple dbs, i'd still
like to know this, given that i might not want to use the my.cnf file...

thanks


-----Original Message-----
From: B. Keith Murphy [mailto:bmurphy@paragon-cs.com]
Sent: Tuesday, November 27, 2007 6:31 AM
To: bruce; 'mysql list'
Subject: Re: mysql replication....


bruce wrote:
> hi...
>
> a quick question that i haven't found an answer to.
>
> i can use "replicate-do-db=foo" in a my.cnf file for replication, to
> replicate the master foo db on the slave. but this requires that i
use/have
> a my.cnf set on the slave.
>
> is there a way to dynamically set this attribute/parameter within mysql on
> the fly. i thought it would be possible via "change master to" but didn't
> find the cmd when looking through the mysql information.
>
> basically, i'm going to have multiple databases, on multiple systems, that
> i'm going to be replicating to a single system. so, for each master
server,
> i'd like to be able to set the databases that i'm going to replicate...
>
> thanks
>
>
>
Can't do that currently in MySQL. It is called multi-master
replication. You can do multi-slave replication which replicates from
one master to multiple slaves, but not the other way around.

Keith