MySQL Forums
Forum List  »  Federated Storage Engine

Grouping data from multiple databases
Posted by: Patrick Burke
Date: January 16, 2008 04:59AM

We would like to (symbolically) group tables from different databases using a symlink or a Federated Storage Engine to be the central focal point for applications. Basically a view for tables from multiple databases.

I have used symbolic links to point at a location where several databases are located and MySQL has recognized the databases in the location.
Such as ln -s /dr1/databases/mysqldata /path/to/datadir
Then withing the /path/to/datadir
have individual directories/databases:
/path/to/datadir/customers
/path/to/datadir/vendors
/path/to/datadir/accounting

What I would like to do is go one level deeper and maybe link some tables from accounting and some from customers such as a view. I was wondering if you can do this with symlinking or a Federated engine.

Any advice is appreciated.

Thanks,

Patrick

Options: ReplyQuote


Subject
Views
Written By
Posted
Grouping data from multiple databases
7721
January 16, 2008 04:59AM


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.