By jantichy on
I'd like to run Drupal on multiple domains (multisite), but I want to use only one Drupal instance, it means only one database and only one db prefix. My idea is to have all my content together in one database and somewhere in configuration only set something like "this node is root of this domain and that node is root of that domain". Is it possible?
Or do I have to have separate database/db prefix for each domain?
Comments
1 database 584 tables share 5 subdomains and 3 domains
All is running well in http://consen.info
where 1 database D4.7 with 584 tables are sharing 5 subdomains and 3 domains websites
in a VPS
One domain http://MeshUp.org has this setting.php
$db_prefix = array(
'default' => 'MESHUP_',
'gmap_user' => '',
'users' => '',
'location' => '',
'users_roles' => '',
'sessions' => '',
'role' => '',
'authmap' => '',
'sequences' => '',
'profile_fields' => '',
'profile_values' => '',
'tinymce_role' => '',
'tinymce_settings' => '',
'event' => '',
'permission' => '',
'sn_subscriptions' => '',
'sn_snid_tid' => '',
'term_node' => '',
'term_data' => '',
'term_hierarchy' => '',
We think that we can optimize the sharing tables for common modules, but at the moment it is working enough well
The Intranet (secretariat, office) dont share the permission (only admin and members have rights to access)
Backups and dbmaintenance are easy and brief
Let me know if there is better solutions or different approach
I need the same prefix
But i suppose that you are using different default db predix for each domain. In your example,
$db_prefix = array('default' => 'MESHUP_') for MeshUp.org. But for my purposes I need ONLY ONE prefix used by all domains and all tables in one only database.
Does this thread help?
http://drupal.org/node/14697
Solved - new module available
A brand new module solved my problem -- http://drupal.org/node/104335