I've already read the discussion about D5 Shared database but didn't find a resumed classification for D6
Knowing which tables to share can be hard to figure out, so I would like some help on this.
The scenario:
- Intranet services developed by different individual which shouldn't interfere each other (so each developer has one D6 sandbox for each service which shouldn't interfere with others)
- Global user/roles/permission settings
- Modules/Themes can (probably will) differ from service to service
- Centralized search would be desirable, but not a requirement since content types (and thus nid sequences) will differ
- Shared translation (not multilingual) since the intranet won't be in english
So, this is the config I've chosen until now (please advise me)
<?php
$shared_prefix = 'shared_';
$db_prefix = array(
'default' => 'subsite_prefix_', //differ for each subsite
'access' => $shared_prefix, // users
'authmap' => $shared_prefix, // users
'profile_fields' => $shared_prefix, // users
'profile_values' => $shared_prefix, // users
'sessions' => $shared_prefix, // users
'users' => $shared_prefix, // users
'filter_formats' => $shared_prefix, // user-roles
'filters' => $shared_prefix, // user-roles
'permission' => $shared_prefix, // user-roles
'role' => $shared_prefix, // user-roles
'users_roles' => $shared_prefix, // user-roles
'locales_source' => $shared_prefix, // translation
'locales_target' => $shared_prefix, // translation
);
?>
Comments
"- Intranet services
"- Intranet services developed by different individual which shouldn't interfere each other (so each developer has one D6 sandbox for each service which shouldn't interfere with others)" -- I would think that maybe then you shouldn't share the users_roles table because then you'll be forcing roles to be the same throughout each site. Same w/ permissions. Permissions changed in one site will be changed in all which may not be the best if someone make's a rouge site or one w/ even miniscule differences.
I'm sharing authmap, profile_fields, profile_values, users, tinymce_settings, and tinymce_role
"Plaguing the world with Drupal; One Plone, Moodle, Wordpress, Joomla user at a time since 2005." ~ btopro
http://elearning.psu.edu/
http://elearning.psu.edu/projects/
http://elearning.psu.edu/drupalineducation/
Ex Uno Plures
http://elmsln.org/
http://btopro.com/
http://drupal.psu.edu/