Thanks guys, I think I'm OK with what I want to do.
Just to clarify, not expencting any response, my main database holds all my service's transaction records. The other databases are ones that my customers have as workflow managers. The updates would be specific to each customer and not 'global'. Thanks for the tips. George > -----Original Message----- > From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED] > Sent: 13 December 2003 8:54 am > To: ''George Pitcher ' '; ''[EMAIL PROTECTED] ' ' > Subject: RE: [PHP-WIN] querying more than one db from a php page? > > > Another thought - came to me just after I posted below: > > If you decides to execute the same update at several > databases from a php page, make sure that you actually > did update all databases! Because you might like to > rollback the update on all database if you fail with > one for them, especially if you was not able to update > the main site. > > However it is up to the design process to decide > how much inconsistency that might be allowed > betwen the databases. > > -----Original Message----- > From: Svensson, B.A.T. (HKG) > To: 'George Pitcher '; '[EMAIL PROTECTED] ' > Sent: 2003-12-13 09:47 > Subject: RE: [PHP-WIN] querying more than one db from a php page? > > You might run into the classical update problem if you > allows update in different databases and then wants to > syncronize the databases with each other. To prevent > update anomalies like this you need a lock mechanism > between the databases. Check your RDBMD documentation > on this. > > However if you only do updates on the main site and then > propagate the update to the "sub" sites, you might like > the RDBMS to handle this by it self, if so you should > check if replication between databases can solve your > problem. > > If you do updates from the main site only and propagate > them to the sub sites then I do think that you should not > run into any particular problem since the aporach is > straight forward. > > > -----Original Message----- > From: George Pitcher > To: [EMAIL PROTECTED] > Sent: 2003-12-12 17:19 > Subject: [PHP-WIN] querying more than one db from a php page? > > Hi, > > I am developing my main site to run on php/mysql (currently > lasso/filemaker). > > I am also developing some individual sites to be hosted on the same > server > as my main one and I'd like to be able to update those smaller site > databases when activity happens on the main site. > > I'm still a couple of months away from tackling that part but can anyone > predict trouble ahead, and if so, any remedies? > > MTIA > > George in Oxford/Edinburgh > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
