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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
