Replication - Two identical database in slave
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
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.