MySQL Forums
Forum List  »  Replication

Replication - Two identical database in slave
Posted by: Mohammad Rizwan
Date: October 11, 2011 01:59AM

Hello All,

I want to achieve same server replication in such a way that, there will be two databases replicating one database on same server

Here is my configuration in my.ini

server-id=1

log-bin

report-host=master-is-slave-host
log-bin=localhost-binlog
relay-log=localhost-relaylog

replicate-same-server-id=1

binlog-do-db=test
replicate-rewrite-db=test->myslave

**#replicate-rewrite-db=test->myslave2 does not work**

replicate-do-table=myslave.tblslave

**#replicate-do-table=myslave2.tblslave does not work**
the above code works fine for replication from db test to myslave on same server

I also want to achieve replication from db test to myslave2 as well on same server along with myslave

Basically it will be one master db and two slave db replicating the same master db

Regards,
Rizwan

Regards,
Rizwan

Options: ReplyQuote


Subject
Views
Written By
Posted
Replication - Two identical database in slave
2047
October 11, 2011 01:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.