[support] FW: Multisite help

[Cary Gordon]

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 at 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 at drupal.org [mailto:support-bounces at drupal.org] *On
> Behalf Of *Cary Gordon
> *Sent:* Wednesday, July 17, 2013 1:06 AM
> *To:* support at 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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20130717/0f8383bd/attachment.html