MySQL Forums
Forum List  »  Replication

Replication problem in 5.6
Posted by: Iakovos Raptis
Date: December 09, 2015 07:38AM

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

Options: ReplyQuote


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.