Replication problem in 5.6
Hello !
I have two instances of mysql in a machine.
A slave (replicated) DB on port 3307 and a master DB in port 3306.
The master DB have tables with data records from a data logger and tables with data that are transmitted through a federated DB that "looks" in the slave DB on port 3307.
Master DB / port 3306 <- Federate DB / port 3306 <- Slave DB / port 3307
The Master DB is replicated to another Machine. On this replication the only tables that sync are those that have data records from the data logger. The others tables don't sync. The error I get is that the federate table doesn't exist. For a reason I don't understand slave db needs the federate schema to do the replication.
For example:
Master DB
test.table1 (Innodb engine) <- Data logger
test.table2 (Innodb engine) <- Federate_DB.table2 (federate engine)
Slave DB
test.table1 (Innodb engine) -> OK
test.table2 (Innodb engine) -> error Federate_DB.table2 doesn't exist
The same scenario works with in version 5.6
Event scheduler is disabled on slave that has the problem
Any help appreciated
Thank you in advane
Subject
Views
Written By
Posted
Replication problem in 5.6
1204
December 09, 2015 07:38AM
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.