Grouping data from multiple databases
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
Subject
Views
Written By
Posted
Grouping data from multiple databases
7721
January 16, 2008 04:59AM
4408
February 28, 2008 02:21AM
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.