Technically, it might be possible. Practically, it would be a major hassle, and explaining why would take more time than I can give this.
We are currently running a huge D6 multisite, table-sharing site that has 1,100 tables. It runs fine.
If you need to share users among a large number of sites, you should consider using bakery or perhaps an LDAP based solution.
If you are sharing content, look at feeds.
Thanks,
Cary
On Jul 17, 2013, at 1:58 PM, Roberovsky Kuz roberovsky@hotmail.com wrote:
Is there any way can I use different databases w/o using share database with prefix
The issue is that I have about 10 sites, and using the same database will be a database with hundreds and hundreds of tables
From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Cary Gordon Sent: Wednesday, July 17, 2013 3:02 PM To: support@drupal.org Subject: Re: [support] FW: Multisite help
Then site1 should look something like this:
$databases = array ( 'default' => array ( 'default' => array ( 'database' => 'mysites', 'username' => 'user_db', 'password' => 'password', 'host' => 'localhost', 'port' => '', 'driver' => 'mysql', 'prefix' => array( 'default' => 'site1_', 'users' => 'shared_', 'users_roles' => 'shared_', ), ), ), );
All of the sites would use the same (mysites) database. Each site would prefix all of the tables that it did >not< share with <somesiteid>_, and user a common prefix — I like shared_ — for the ones it did.
Obviously, each shared table needs to be individually enumerated, so that list can get pretty long in some scenarios. I have sites that share 150 tables.
The gotcha is that the table list changes when you add or update modules and content types, so you need to stage any changes and update the settings.php files before you make the changes in production.
Cary
On Tue, Jul 16, 2013 at 10:26 PM, Roberovsky Kuz roberovsky@hotmail.com wrote: I have couple websites running in Drupal 7.22
All websites share the same code, but each website has its own database, no sharing with prefix, I want to share common functionalities among sites, like users, content type and other
From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Cary Gordon Sent: Wednesday, July 17, 2013 1:06 AM To: support@drupal.org Subject: Re: [support] Multisite help
This doesn't really explain what your are trying to do or what your problem is.
Cary
On Jul 15, 2013, at 12:33 PM, Roberovsky Kuz roberovsky@hotmail.com wrote:
I need help sharing users with 2 sites
I have 2 sites sharing the same code, but each site has different database
Site 1
$databases = array ( 'default' => array ( 'default' => array ( 'database' => 'site1', 'username' => 'user_db', 'password' => 'password', 'host' => 'localhost', 'port' => '', 'driver' => 'mysql', 'prefix' => '', ), ), );
Site 2
$databases = array ( 'default' => array ( 'default' => array ( 'database' => 'site2', 'username' => 'user_db', 'password' => 'password', 'host' => 'localhost', 'port' => '', 'driver' => 'mysql', 'prefix' => '', ), ), );
Configuration to share tables between databases
$databases = array ( 'default' => array ( 'default' => array ( 'database' => 'site1', 'username' => 'user_db', 'password' => 'password', 'host' => 'localhost', 'port' => '', 'driver' => 'mysql', 'prefix' => array( 'default' => 'site1_', 'users' => 'site2_', ), ), ), ); -- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- Cary Gordon The Cherry Hill Company http://chillco.com -- [ Drupal support list | http://lists.drupal.org/ ]