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

Reply via email to