Mysql – Accessing databases from different domains on same server

lampMySQLPHP

I have a LAMP server – on there I have multiple domains. Each domain has its own user, db's, public_htmls/, etc.

I need to access Domain A's database from a web app on Domain B in php.

Currently I just use localhost as my host for all DB connections in my web apps – but now I need to access a DB under a different domain so that obviously won't work.

Not sure if there is server (apache/php/dns) configuration required which would make this question better suited for server fault.

Any ideas?

Best Answer

If you only have one server, then localhost is still your local server. You only have one MySQL server for all your domains.

You simply need to specify a different database when you connect - you may still use localhost as the server.

Related Solutions

Mysql – Load-balance two MySQL dbs from one PHP page

One really simple way: You could just use a random number to select between two connection strings, something like the following (this is pseudo-code, I don't speak PHP):

  $ran = gen_random();    // assuming range from 0..1
  if (ran < 0.5) then 
     $con = database1; 
  else 
     $con = database2;

Real load balancing would be possible as well of course, you would have to check to load of your DB servers and select the one with the lower load.

Centos – Very large number open connections from web to DB server

Though this is getting a bit stackoverflow'y, here goes:

Probably because you don't close your connections in the code. If so, I would recommend you switch to mysql_pconnect(), or just add mysql_close() to the end of all requested php-pages

If all the connections to the mysql server is in state: TIME_WAIT, try lowering the wait_timeout variable in your mysqld configuration. Check out the MySQL documentation for more info

UPDATE: As ChristopherEvans pointed out, you can connect directly to the mysql socket instead of using IP endpoints, to avoid running out of unused ports on the local interface

Best Answer

Related Solutions

Mysql – Load-balance two MySQL dbs from one PHP page

Centos – Very large number open connections from web to DB server

Related Topic