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 ones

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

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

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

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

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

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?

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

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

[PHP-DB] Remote DB Connection

Hi people, I have 2 servers , i need to connect to 1 remote mysql server ,i am using the normal : @mysql_connect ('ipaddres-server2', 'DBName', 'DBPwd') ; Is their anything else I need to consider to connect ? , Thank you -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] Remote DB Connection

Hello Omelin, Wednesday, December 3, 2003, 6:05:52 PM, you wrote: OM @mysql_connect ('ipaddres-server2', 'DBName', 'DBPwd') ; OM Is their anything else I need to consider to connect ? , The server must allow it :) other than that, not really. -- Best regards, Richard