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
> Slave : dbname2 (but contains data from db2name1)
> A project manager is asking for this.. don't blame the guy asking :-)
> 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...