[ciapug] Best Practice

[Dave J. Hala Jr.]

Ok... So...I've got this client intake system. Its written in PHP and it
uses a mysql back end.  The information that is stored is demographic
data on individuals and households.

I have 9 agencies that use it. Each runs agency has their own website
and database. (they are all identical)  What I would like to do is mine
data across all 9 agencies.  At the moment, its kinda a pain to connect,
and query each individual database and then combine all the information.

For political reasons, I can't have all the agencies use one database.
What I was considering is having a single "Master Database" that any
inserts or updates done any of the 9 individuals db's would be written
to. For example site1 does an update on the site1 db and then it does an
update on the master db.

This method is kinda like the mysql replication. I was initially looking
for a way to replicate all the info from one db into the master but no
luck.  I was thinking about trying to get the query info from the mysql
*.bin files and using it to fill the a  "master db" ( not to be confused
with the replication master)


Anyone have any thoughts? Ideas?


:) Dave

-- 

Open Source Information Systems (OSIS)
Dave J. Hala Jr. <dave@osis.us>
641.485.1606