List:General Discussion« Previous MessageNext Message »
From:Rob Wultsch Date:October 13 2008 7:40pm
Subject:Re: replication question -different db name on slave server
View as plain text  
On Mon, Oct 13, 2008 at 11:43 AM, AM Corona <amcorona@stripped> 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

Thread
replication question -different db name on slave serverAM Corona13 Oct
  • Re: replication question -different db name on slave serverRob Wultsch13 Oct
  • Re: replication question -different db name on slave serverDan Nelson13 Oct