I am developing a suite of sites that will share almost identical information. The Themes will be different on each as well as content information (Company name, 800# and so on.) This is for Travel Reservations sites. Example: I will be setting up categories for lodging and would want all hotels available on all sites but the ability to "turn off" some depending on the site.

My question is - Which core tables should be shared or not shared to accomplish this?

Stuart Goff

Comments

stuartgoff’s picture

stuartgoff commented

Does any one she any problem w/ the following? I will set up a db for shared elements and a db for each site (in this case pat)

$db_url = array(
	'shared'	=> 'mysql://username:password@localhost/databasename',
	'pat'		=> 'mysql://username:password@localhost/databasename2',
);

$db_prefix = array(
	'default'   => 'pat.',
	'authmap'	=> 'shared.',
	'blocks'	=> 'shared.',
	'book'	=> 'shared.',
	'boxes'	=> 'shared.',
	'files'	=> 'shared.',
	'file_revisions'	=> 'shared.',
	'filters'	=> 'shared.',
	'filter_formats'	=> 'shared.',
	'forum'	=> 'shared.',
	'menu'	=> 'shared.',
	'node'	=> 'shared.',
	'node_access'	=> 'shared.',
	'node_comment_statistics'	=> 'shared.',
	'node_counter'	=> 'shared.',
	'node_revisions'	=> 'shared.',
	'poll'	=> 'shared.',
	'poll_choices'	=> 'shared.',
	'poll_votes'	=> 'shared.',
	'profile_fields'	=> 'shared.',
	'profile_values'	=> 'shared.',
	'role'	=> 'shared.',
	'sequences'	=> 'shared.',
	'sessions'	=> 'shared.',
	'term_data'	=> 'shared.',
	'term_hierarchy'	=> 'shared.',
	'term_node'	=> 'shared.',
	'term_relation'	=> 'shared.',
	'term_synonym'	=> 'shared.',
	'url_alias'	=> 'shared.',
	'users'	=> 'shared.',
	'users_roles'	=> 'shared.',
	'vocabulary'	=> 'shared.',
	'vocabulary_node_types'	=> 'shared.',
);
magico’s picture

magico commented
Status: Active » Fixed

Closing support requests older than 1 month.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)