'Federated' Tag

• Federated Tables

  July 7, 2010

  Your searching for how to create a join across two databases on two different servers and it can’t be done directly.   select  d1.a, d2.b from db1@server1 join db2@server2 where db1.c = db2.c; does not work. You learn about federated databases.  The federated storage engine allows accesses data in tables of remote databases.  Now how do [...]

  posted in Tips & Tricks by mark