MySQL Replication - Two Way
I need to replicate 2 tables from dbA to to dbB and 2 *separate* Tables from dbB to dbA . i am happy that tables can be replicated without replicating the whole database using specific table commands
But is the reversing Master and slave thing possible?
I have read through various posts and looked into replication but it appears to be one way from slave to Master.
is then possible to set the same slave to master and replicate tables again
The replication needs to be done every hour both ways
I am kind of stumped !
Thanks
Paul
