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