You can only do that in the my.cnf file. On Nov 27, 2007 9:50 AM, bruce <[EMAIL PROTECTED]> wrote: > 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] > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]