MySite on shared tables
Hi
I'm thinking about the possibility to use mysite with multi site installation.
For example, let's say we have several shared tables:
'users' => 'shared.',
'sessions' => 'shared.',
'role' => 'shared.',
'authmap' => 'shared.',
'sequences' => 'shared.',
'profile_fields' => 'shared.',
'profile_values' => 'shared.',
'users_roles' => 'shared.',
we have two sites site.com - for english users and site.ru for russian users. Both sites have shared tables in shared. database and each site has own database for the rest tables. This should be working well.
But let's say I want to create separate site - site.info with profiles from both sites using my site. I see a problems here because mysite is using blocks and nodes, but since each site will have a separate blocks and nodes tables - it won't works.
Let me know what you are you thinking about? thanks.
Correct
You are correct. It will not work.
You could, instead, use Domain Access to separate content. That module integrates with MySite just fine.
You could also run the content from the two other sites into the .info site using FeedAPI -- or just use the normal Feed support supplied by MySite.
That last idea is the easiest. Don't allow users to track nodes or terms. Just let them track feeds.
--
http://ken.therickards.com/
Thanks! For now I end up
Thanks!
For now I end up with common database for both domains. I will only separate variables, comments, views*, blocks tables. This way it will allow me to use mysite for displaying profiles from both sites.
Main trick here is localizer use.
I'll be using it to separate content via translations & views based on hostname. So russian site will have only russian nodes & views with russian content and so on.