Posted by rockitdev on October 27, 2010 at 7:13pm
Creating a multisite environment with some shared tables.
I have the following configured to be shared: users, sessions, role, authmap.
I was considering adding the permission table to the mix, since all sites will be configured the same way from a roles perspective, it seems to make sense. My question is, is this a bad path to go down?

Comments
Most likely...
I would highly recommend against it. This will basically lock you into needing to have the same modules running on all sites indefinitely. A better option would be to share those few tables you mentioned and create a Feature via http://drupal.org/project/features that can be used to keep permissions in sync. There's a bit more leg-work in checking boxes but this will allow you to have additional modules activated in the future. Actually a lot of stuff can be standardized via Features now so you really don't need to share role either (though there isn't much harm in doing it).
I'd still make sure that the databases you setup have a users, sessions, role, and authmap table included in them. This is because while query code is supposed to be wrapped in {} for tables (which tells drupal to snag the referenced table in-case it's different like in shared tables) not everyone always remembers to do that. Having these tables still exist (just not be used) is a good fail-safe. Also what I like to do is have the users table per site only have my user 1 account in it. This way if you need to "lock a site down" but still work on it and access the info you can just edit the settings.php file to point to the normal users table instead of the shared one.
Ex Uno Plures
http://elmsln.org/
http://btopro.com/
http://drupal.psu.edu/
I'd still make sure that the
I woud say to go ahead and let this code fail so that the bug can be found and fixed.
The Boise Drupal Guy!
Interesting. had no idea
Interesting. had no idea features could capture perms. I'll see what I can do. I'm trying to eliminate as much redundancy as possible in my setup.
I have about 12 sites in the multisite environment. It's for a hospital, with similar departments/divisions to a university. Basically using multisite to divide up larger potions of the site so it's not too overwhelming for users of the cms.
Might want to look into
Might want to look into domain access if you're going to be sharing a lot of settings like that. I've setup both (multisite shared table and Domain Access) and there's a lot of configuration either way. Far less redundancy in D.A. but if you use Features, Drush, and/or Network Manager (http://drupal.org/project/network_manager) it's not so bad. Also might want to look into SSO (http://drupal.org/project/sso), makes networks of multisites much nicer to work with (especially as an admin :p).
Ex Uno Plures
http://elmsln.org/
http://btopro.com/
http://drupal.psu.edu/