MySQL Forums
Forum List  »  Federated Storage Engine

new in federated engine
Posted by: charles candy
Date: December 06, 2011 06:27AM

I tried create federated link table between 2 mysql server , running on 2 virtualmachine

it work but I find it pointless cause I can't call stored procedure/function on the remote server.

I have a question. if I run a stored procedure in my local server in which using tables in remote server , what will happen?

my assumption is that the local server will retrieve all records in the remote table and process it in local server when the stored procedure execute .

is this going to happen ?

is there such things as federated database?

Options: ReplyQuote

Written By
new in federated engine
December 06, 2011 06:27AM

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.