What about setting up replication between the servers? Make the the web a slave
of the office one and make it read only so avoid messing up the data.
bastien> Date: Thu, 11 Oct 2007 18:08:29 -0600> From: [EMAIL PROTECTED]> To:
php-db@lists.php.net> Subject: Re: [PHP-DB] Remote DB Connection: Pros and
Cons?> > Splitting the tables probably wouldn't work. Most of the tables are
used by> both sites and the ones that aren't are tied to the rest by foreign
keys.> > Most of the updates are done from the admin site, so we're toying with
the> idea of creating a read-only data warehouse for the website. The sync
would> be one way from main office db to the warehouse (say, every 10
minutes).> > Any updates the website does (like an event registration or
profile update)> would be done remotely to the office db. In this scheme the
website db would> be 10 minutes behind. We can live with that.> > Doing
everything by remote connection would be easier, but we're worried> about the
performance.> > Tony> > > On 10/11/07 6:01 PM, "Chris" <[EMAIL PROTECTED]>
wrote:> > > Tony Grimes wrote:> >> Have any of you tried running a PHP website
using a remote database> >> connection?> >> > >> We currently have an in-house
PHP website driven by a PostgreSQL database> >> that is HEAVILY administered
within the office with an administration sister> >> site (also PHP).> >> > >>
Problem: the office connection is having trouble keeping up with the website>
>> traffic. Our IT guys want to outsource the whole server to a co-location> >>
facility, but the administrators don't want the extra lag on the admin site.>
>> > >> Is it feasible to host the database and admin site in the office, but>
>> outsource the website and connect to the office database remotely? Is there>
>> any other way to do this?> > > > Do the website and admin area reference the
same database tables?> > > > If they don't, split the database up and keep the
website db on the> > website server and the other internally.> > > > If they
do, which one is the 'primary' set? ie which one gets updated?> > > > You could
use replication to keep them in sync (http://www.slony.info/> > for example).>
> -- > PHP Database Mailing List (http://www.php.net/)> To unsubscribe, visit:
http://www.php.net/unsub.php>
_________________________________________________________________
Are you ready for Windows Live Messenger Beta 8.5 ? Get the latest for free
today!
http://entertainment.sympatico.msn.ca/WindowsLiveMessenger
