I am trying to setup a domain and a sub-domain using two separate hosts for a Math tutoring website. I have chosen to use Drupal 6 for this task--for now at least.
The first site, www.example.com , is hosted on an entry-level, shared Godaddy server that barely has enough resources to calculate the area of a triangle so I want to limit its load as much as I can. This site will be devoted to handling all public traffic and user logins that will transfer the user to the second sub-domain site using SSO. (Is key redirect with SSL certificate aka "poor-man's SSO" even worth looking at?)
The second site, www.math.example.com , will be hosted on a dedicated Dell Poweredge 1750 with 8GB RAM running Ubuntu 11 in my basement. This site will contain the UI for any user that logs in through the main site plus all of the math related content.
I want to be able to share user tables but I also want separate databases for content. Since my Godaddy hosting has marginal resources, I would like to host the shared user db and the drupal content db for the public pages there. The server in my basement will use the shared Godaddy db for users but have its own db running locally for content. Is this even possible to have a Drupal site use two databases in different physical locations?
The first site (Godaddy) is up and is currently running with a single database with home_ prefix and has external access enabled. The second site (in my basement) is setup and ready to run install.php once the db's are setup properly.
All of the articles I have found seem to have a shared codebase which means both sites are running on a single host I assume? I may be searching for the wrong thing... is this scenario I've described even called a "multi-site"?
So far, the article below seems to be the most similar to what I'm trying to do, but it still uses a shared codebase. Thank you for any help or suggestions!
If I posted this in the wrong forum, I apologize in advance!
Comments
No expert
I'm not expert on the matter, but you might be able to write some sort of script to sql rsync the user table on the two seperate sites, but yet have the rest separate.
However, since one site is hosted on GoDaddy, you may have to find a "poor mans" work around to have the script work.
What would be good would be to have a whole separate authentication system like LDAP. Then you could set up both servers to authenticate against LDAP instead of Drupal, using the LDAP Module
Cheers
- Craig Vanderlinden @cvanderlinden
Thanks for the advice, I
Thanks for the advice, I think I may have found my solution