MySQL Forums
Forum List  »  Federated Storage Engine

Federated tables on replicated database
Posted by: Daniele Ivasse
Date: October 25, 2011 01:29PM


I have 3 databases: A, B, C. On database B there are some federated tables associated with tables of database A. This works fine.

Database C is a replication of database B. But when I execute a select in a federated table on database C it brings empty result. I created on database A, 2 users with the same login and password, first with host = database B and second with host = database C. And for both I grant select privilege.

Am I missing something?
If anyone could help me, I'll be grateful.


Options: ReplyQuote

Written By
Federated tables on replicated database
October 25, 2011 01:29PM

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.