<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; ">I am looking at a project involving over a dozen sub-sites. The main site will have accumulated content (and I assume I'll use agg2 for that) and the sub-sites will have their own content, own admins, own bloggers, etc.<DIV><BR class="khtml-block-placeholder"></DIV><DIV>Ideally, people could register on one site and be registered for all sites. But they would have user roles only as appropriate for the site they're on. In other words, someone on Site A with blogging permissions is also registered on Sites B, C, D... but without blogging permissions. Same with admins.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>I am contemplating a multisite install with:</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>shared tables</DIV><DIV>- users</DIV><DIV>- profile</DIV><DIV>- ?</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>unique tables per site</DIV><DIV>- users_roles</DIV><DIV>- roles</DIV><DIV>...and everything else</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Questions: Am I looking for trouble going this way? Are there other tables I will need to share (e.g., sessions, cache)? Are there other pitfalls to this hybrid multisite approach I should watch out for?</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Can you suggest alternative approaches? (I'm looking at SXIP, but it seems to be overkill for what we're after. Anyone?)</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Any insights, experiences, warnings, anecdotes appreciated! Thanks!</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Laura</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><DIV> <SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Verdana; font-size: 11px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Verdana; font-size: 11px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Verdana; font-size: 11px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Verdana; font-size: 11px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Verdana; font-size: 11px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Verdana; font-size: 11px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><DIV><FONT class="Apple-style-span" color="#066CBD"><B style="color: rgb(6, 108, 189); font-weight: bold; "><BR class="khtml-block-placeholder"></B></FONT></DIV><DIV><FONT class="Apple-style-span" color="#066CBD"><B style="color: rgb(6, 108, 189); font-weight: bold; "><BR class="khtml-block-placeholder"></B></FONT></DIV><DIV><B style="font-weight: bold; "><SPAN class="Apple-style-span" style="font-weight: bold; "><SPAN class="Apple-style-span" style="font-weight: bold; "><SPAN class="Apple-style-span" style="font-weight: bold; "><FONT class="Apple-style-span" color="#066CBD"><SPAN class="Apple-style-span" style="color: rgb(6, 108, 189); font-weight: bold; "><SPAN class="Apple-style-span" style="color: rgb(6, 108, 189); font-weight: bold; "><SPAN class="Apple-style-span" style="color: rgb(6, 108, 189); font-weight: bold; ">Laura Scott</SPAN></SPAN></SPAN></FONT></SPAN></SPAN></SPAN></B></DIV><DIV><FONT class="Apple-style-span" color="#066CBD"><SPAN class="Apple-style-span" style="color: rgb(6, 108, 189); "><SPAN class="Apple-style-span" style="color: rgb(6, 108, 189); "><SPAN class="Apple-style-span" style="color: rgb(6, 108, 189); ">President</SPAN></SPAN></SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" color="#066CBD"><SPAN class="Apple-style-span" style="color: rgb(6, 108, 189); "><SPAN class="Apple-style-span" style="color: rgb(6, 108, 189); "><SPAN class="Apple-style-span" style="color: rgb(6, 108, 189); "><A href="mailto:laura@pingv.com">laura@pingv.com</A></SPAN></SPAN></SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" color="#066CBD"><BR class="khtml-block-placeholder"></FONT></DIV><DIV><FONT class="Apple-style-span" color="#066CBD"><SPAN class="Apple-style-span" style="color: rgb(6, 108, 189); "><SPAN class="Apple-style-span" style="color: rgb(6, 108, 189); "><SPAN class="Apple-style-span" style="color: rgb(6, 108, 189); ">pingVision, LLC</SPAN></SPAN></SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" color="#066CBD"><SPAN class="Apple-style-span" style="color: rgb(6, 108, 189); "><SPAN class="Apple-style-span" style="color: rgb(6, 108, 189); "><SPAN class="Apple-style-span" style="color: rgb(6, 108, 189); ">4450 Arapahoe Ave, Suite 100</SPAN></SPAN></SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" color="#066CBD"><SPAN class="Apple-style-span" style="color: rgb(6, 108, 189); "><SPAN class="Apple-style-span" style="color: rgb(6, 108, 189); "><SPAN class="Apple-style-span" style="color: rgb(6, 108, 189); ">Boulder, CO 80303</SPAN></SPAN></SPAN></FONT></DIV><DIV><A href="http://www.pingv.com"><FONT class="Apple-style-span" color="#066CBD"><SPAN class="Apple-style-span" style="color: rgb(6, 108, 189); -khtml-text-decorations-in-effect: underline; "><SPAN class="Apple-style-span" style="color: rgb(6, 108, 189); -khtml-text-decorations-in-effect: underline; "><SPAN class="Apple-style-span" style="color: rgb(6, 108, 189); -khtml-text-decorations-in-effect: underline; ">www.pingv.com</SPAN></SPAN></SPAN></FONT></A></DIV><DIV><FONT class="Apple-style-span" color="#066CBD"><SPAN class="Apple-style-span" style="color: rgb(6, 108, 189); "><SPAN class="Apple-style-span" style="color: rgb(6, 108, 189); "><SPAN class="Apple-style-span" style="color: rgb(6, 108, 189); ">303.415.2559</SPAN></SPAN></SPAN></FONT></DIV><BR class="Apple-interchange-newline"></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN> </DIV><BR></DIV></BODY></HTML>