multisite

Site1.com and Site2.com resides on the same server but each have their own databases. If I wanted to share the users table between these two sites for single sign on capability , can I just create a MySQL View of Site1.com's users table and store it Site2.com's users table ? I managed to create an update-able (non-drupal db, just for testing) View using :

create view users as select * from database1.users;

I haven't tried this yet in Drupal and I dont know what the implications will be. Is this possible?

Thanks!

We've set up a multi-site d7 "farm". New installations are going well, upgrades from d6 are rough.

http://d7.ls.net

Hi,
I have to choice how manage section of a large Newspaper Website.

I could choice to use only one DB to manage all but I will get 2 tables with large amount data (about nodes and search index) and great problems about queries optimizations for search index.

Let's create a wiki or documentation for "How to documentation for creating Drupal 7 multisite configuration".

I can help test and write the documentation. I may need some help setting mine up, too. So this would be beneficial for everyone.

Sorry if this is a silly question - I've just started using Drupal last year and this is my first major upgrade.

I've got all my sites in one multi-site setup.

A couple of them are very simple, and basically good to go.

Can I upgrade just one of two of them at a time?

e.g. Could I create a new dir for drupal 7 and copy the sites over into it one at a time? (To eventually migrate all of them as the modules I need become available?)

FYI:

http://lx1.co.nz
http://nzmagic.co.nz

vs

http://amdramreview.co.nz
http://skeptember.com

I'm a noob here and I've run into a problem setting up multisites as subdirectories. I think I have it all done correctly except for this one error when Drupal is trying to access each site's 'files' folder. This is the way the error appears when I look at 'File system' page under 'Site configuration':

warning: fopen(sites/mulfordfam.dlinkddns.com.parisumc/files/.htaccess): failed to open stream: Permission denied in /usr/share/drupal6/includes/file.inc on line 129.

My situation is:

I have a website example.com, i want to mirror this site completely except for the theme so that in apache i can direct mobile devices to m.example.com where they can use exactly the same site but with a mobile optimised theme.

I know there are numerous mobile modules out there but they suffer from caching limitations, ie, when a page is accessed from a computer, that same cached page is sent to any subsequent requests, including mobiles.

I know there are also domain/subdomain modules out there also but they are overweight for what i need.

Dear uberdrupals,

Hi,

I have set up a multisite installation on a VPS. The strange thing is that the email's working on the default site, but not in the subsites. Any Idea where to search/adjust?

I am wondering whether multisite provides the solution I am looking for.

Here is my dilemma.

I have a website which is fairly established (over 3 years old) and was built by developers before I got involved myself. Recently I discovered drupal which looks like it provides all of the answers to my prayers with regards to this site, however as the bulk of the site is already coded I was wondering whether multisite would be a good solution prior to a full site migration.