MySQL Forums
Forum List  »  Federated Storage Engine

LOAD SHARING USING FEDERATED ENGINE
Posted by: NITESH SINHA
Date: February 14, 2007 08:24AM

I have two servers, suppose s1 and s2.
In s1 all my tables are stored except one that is stored in s2.
I want to procedure, which retrieves data from tables of both server and after processing inserting into table of s2.
what i have done, one federated table same replica of that is in s2 created by giving the path of s2.
i just want to know, if i m using federated table or selecting or inserting in federated table, where load applied, on s1 or s2 because the reason for dividing the sever into s1 and s2 is to share the load between severs.

OR is there any more option to work with two severs simultaneously.

Options: ReplyQuote


Subject
Views
Written By
Posted
LOAD SHARING USING FEDERATED ENGINE
4702
February 14, 2007 08:24AM


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.