Re: [PHP-DB] Remote DB Connection: Pros and Cons?

Thank you all for the responses. I think we're going to try replicating the databases with Slony. Wish me luck! Tony On 10/11/07 6:23 PM, "Chris" <[EMAIL PROTECTED]> wrote: > Tony Grimes wrote: >> Splitting the tables probably wouldn't work. Most of the tables are used by >> both sites and the

RE: [PHP-DB] Remote DB Connection: Pros and Cons?

> Have any of you tried running a PHP website using a remote database > connection? Yes. If you mean the web server is on 1 box and the database server is on a 2nd box. > We currently have an in-house PHP website driven by a PostgreSQL database > that is HEAVILY administered within the office

RE: [PHP-DB] Remote DB Connection: Pros and Cons?

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 D

Re: [PHP-DB] Remote DB Connection: Pros and Cons?

Tony Grimes wrote: 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

Re: [PHP-DB] Remote DB Connection: Pros and Cons?

Hi You would be better off with the database server and php on the same server - both sites. You will find there is significant lag if there is a poor connection between the web and database server, but if you are just accessing web pages and updating data, even with large pages there is not much

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 wou

Re: [PHP-DB] Remote DB Connection: Pros and Cons?

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 connec