By rosslaird on

I am running drupal happily on my personal website, where the drupal files and the database are on the same server. But I am working on a new project in which the website files will be on one server and the database will be on another, remote server with no connection to the first. I assume that this will not be a problem, and that all I have to do is correctly specify the full url to the database in the settings, But before I go ahead and give it a try, I just wanted to check that this will actually work and that there won't be other issues I haven't thought of.

Thanks in advance.

Ross

Comments

vm’s picture

vm commented

The question is more for the host i believe. Does the host allow remote accessing of a database from a script running on a seperate server?

voipfc’s picture

voipfc commented

Your best guess for $1million, you won't lose your shirt if your idea fails to work.

One more thing if the connection is over an insecure link, you had better run through SSL or a secure connection via ssh or some other such system.

dgorton’s picture

dgorton commented

Setting up Drupal to run with separate database and web servers is very common and very straightforward. The only difference is in the database connection string (e.g. for Drupal 4.7.x you need to put in the server info into '$db_url' under "Database settings" in your site's settings.php file).

But, you have to have some level of connectivity between the servers. I'm possibly just being fussy about grammar, but if this is really true, you're going to have a problem:

...the website files will be on one server and the database will be on another, remote server with no connection to the first...

The servers will need to be able to see each other. And, additionally (as VeryMisunderstood noted) the servers will need to be allowed to talk to each other. More specifically, sometimes database servers are configured to refuse connections from untrusted / remote locations.

As long as you're over those two hurdles, though, there's nothing at all special about separating the web and database layers into two separate servers.

Drew Gorton
Gorton Studios
Some of our Drupal Sites

rosslaird’s picture

rosslaird commented

Thanks for the helpful replies, everyone.
Yes, I should have been a bit more clear: by "no connection" I simply mean that the servers are in two different locations.
So, providing there are no extra access hurdles, it sounds like my plan should work.
Thanks again.

Ross