Database and Website in different servers

[argrafic]

Hello all.

So far, of all the websites I've developed both the website and the database are in the same server.

But I just finished a website but the client has 2 different servers, one where the website will live and another one where the database is stored.

What's the configuration or how do I make the connection to the other server? Is it just writing instead of localhost in the $host part of the DB connection I write the address?

Thanks!!

[planetsim]

Pretty much, you will also need to make sure depending on the database type that the user for that database is allowed to make remote connections. A better idea in my opinion would be to still have the database on the same server and have a script which syncs the remote database.

[SFDonovan]

Check your config.php file

These are common scripts that contain all your settings.

$dbhost = "192.168.1.1";
$dbuname = "xxxxx*";
$dbpass = "xxxxxxx";
$dbname = "whatever";

If the db and webserver are on the same machine then $dbhost would have been localhost, but since they are not then you place the IP of your database server.

Using phpMyAdmin edit your privileges for your db user for the "whatever" database and input the same IP for host.

You will see a performance hit when your site and db are not on the same server, but the lag is not too bad, of course this depends on several network factors.

HTH

[argrafic]

thanks.

i still don't know (they are checking it for me) if both servers are in the same network, but they gave me the ip: 10.9.2.xxx.

if both servers are in the same network, will it work with that address?

if not, i suppose i need the particular ip for that server, right?

[SFDonovan]

argrafic wrote:

thanks.

i still don't know (they are checking it for me) if both servers are in the same network, but they gave me the ip: 10.9.2.xxx.

if both servers are in the same network, will it work with that address?

if not, i suppose i need the particular ip for that server, right?

You need the IP for the database server.

You would place that here -->

$dbhost = "192.168.1.1";

[argrafic]

i get the error:

Warning: mysql_pconnect() [function.mysql-pconnect]: Can't connect to MySQL server on '10.9.2.100' (10065) in C:\Inetpub\vhosts\apatrimonial.com.mx\httpdocs\pruebas\Connections\AP.php on line 9

Fatal error: Can't connect to MySQL server on '10.9.2.100' (10065) in C:\Inetpub\vhosts\apatrimonial.com.mx\httpdocs\pruebas\Connections\AP.php on line 9

connection issues or permission issues?