I have one table t1 on database d1 of the server s1 and now another table t2 is in d2 of the server s2.Now i want some data of the table t1 and its related data from t2 table as resultant data.how can i make it possible?
FEDERATED Storage Engine in MySQL 5.0.related document i have seen any other option...what can i do to get data across two different server?
There are two solutions to your problem:
1). MySQL based using Federated Engine (as mentioned by you). You can go through this Blog post on Federated Engine
2). (As you are using PHP) Fetching data from one server, then either looping through the data and firing relevant queries to another server, or firing single aggregated query to another server based on the data fetched from first server.
Hope it will help you...