[support] Multisite on same database

[Shyamala]

The tables you want to share depends on what is the kind of information that 
you want to share between the sites.  Is the content shared? Is the user 
database and session shared?  Is the theme shared?
Sequence table stores the unique ids created in user, menu, vocabulary,... 
tables.

        name  id
            users_uid 5
            menu_mid 57
            vocabulary_vid 1
            term_data_tid 2
            node_nid 11
            node_revisions_vid 11
            files_fid 4

Shyamala


----- Original Message ----- 
From: "Xavier Bestel" <xavier.bestel at free.fr>
To: <support at drupal.org>
Sent: Thursday, January 10, 2008 3:55 PM
Subject: Re: [support] Multisite on same database


Hi,

ok, now I understand better how it works.
However, I don't really know which tables will need to be separated.
What's the purpose of {sessions} and {sequences} ?
Is there a place where I can quickly lear about them, in order to know
which ones to unshare ?

For now, I have unshared {menu}, {panels_info} and {panels_area}, and I
have special variables for site_name, site_slogan, theme and front_*.

Thanks,
Xav

On Wed, 2008-01-09 at 23:19 -0200, Alessandro Feijó wrote:
> I think with Views & Taxonomy its possible, maybe you will wanna use 
> Panels
> module too
>
> You'll have a lot of config to do, several days, but when done, will be 
> nice
> :)
>
> Are you intimate with settings.php? You can chose with tables will be
> generic or to each site.  Look at $db_prefix.
>
> i.e.
>
> $db_prefix = array(
>     'sessions' => 'siteA_',
>     'sequences' => 'siteA_',
>     'menu' => 'siteA_',
>     'url_alias' => 'siteA_',
> );
>
> based on what you wrote, at least those 4 tables you will need to have one
> for each site.
>
>
> Feijó
>
>
> ----- Original Message ----- 
> From: "Xavier Bestel" <xavier.bestel at free.fr>
> To: <support at drupal.org>
> Sent: Wednesday, January 09, 2008 6:13 PM
> Subject: [support] Multisite on same database
>
>
> > Hi,
> >
> > I'd like to have a particular setup:
> > - 3 sites called A.com, B.com and C.com
> > - all running the same drupal 5 install, with the same nodes
> > - all 3 with a different theme
> > - all 3 with a different organisation (different primary links,
> > frontpage, etc.)
> > - a mean to "assign" nodes to one or the other site.
> >
> > I was thinking, maybe using taxonomy and have A.com have all the nodes,
> > then B.com have only the node tagged "B-nodes" and C.com the sites
> > tagged "C-nodes".
> >
> > Is something like that possible ?
> >
> > Thanks,
> > Xav
> >
> >
> > -- 
> > [ Drupal support list | http://lists.drupal.org/ ]
> >
>


-- 
[ Drupal support list | http://lists.drupal.org/ ] 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 308 bytes
Desc: not available
Url : http://lists.drupal.org/pipermail/support/attachments/20080111/f3512f95/attachment.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 451 bytes
Desc: not available
Url : http://lists.drupal.org/pipermail/support/attachments/20080111/f3512f95/attachment-0001.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 311 bytes
Desc: not available
Url : http://lists.drupal.org/pipermail/support/attachments/20080111/f3512f95/attachment-0002.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 277 bytes
Desc: not available
Url : http://lists.drupal.org/pipermail/support/attachments/20080111/f3512f95/attachment-0003.png