MySQL Forums
Forum List  »  Federated Storage Engine

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

Hi,

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.

Thanks,
Daniele

Options: ReplyQuote


Subject
Views
Written By
Posted
Federated tables on replicated database
6185
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.