On Jul 27, 2009, at 9:31 AM, [email protected] wrote:
Hello all,
Our company is attempting to scan/analyze all of our product
software. Many locations throughout the world, some product teams
are reluctant to use our central Fossology server so they have setup
their own, So we have approximately 7 separate servers collecting
OSS info..... I'd like to aggregate all the various server data
into one database so that it can be viewed via the Fossology UI (or
other means)...... any ideas on how to do this?
Hello Thomas,
There are three things to keep track of:
1) UI (this step is unnecessary if you do 3. below)
the UI can handle a split repository, but not a split database. You
could change each UI plugin to query the multiple databases and
aggregate the results.
2) Split repository
If each repository could be nfs mounted to each other, then Hosts.conf
could specify them all. If any file in the DB can't be found in host/
repository 1, then it would look in host/repository 2, ...
3) Database (this is unnecessary if you do 1. above)
Each site could share the same (replicated, or synched) database.
The problem is how to combine the multiple databases without breaking
referential integrity. I've asked the postgresql list for some help
with this because it seems crazy that this hasn't already been
addressed.
Bob
_______________________________________________
fossology mailing list
[email protected]
http://fossology.org/mailman/listinfo/fossology
