On Mon, Oct 13, 2008 at 11:43 AM, AM Corona <[EMAIL PROTECTED]> wrote:
> In mysql 4, can one replicate a database to another server but have the DB > name on the slave server be different? > > Master : dbname1 > Slave: dbname1 > AND > Slave : dbname2 (but contains data from db2name1) > > A project manager is asking for this.. don't blame the guy asking :-) > > > Regards, > Martin Corona > If you don't need things to synched you could *not* run a sql thread on the slave, and then use sed/awk/whatever to filter the relay log files and then run the sql thread. In fact I bet there is some way for awk to sit between the relay logs and sql threads in real time... -- Rob Wultsch