homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Gold Sponsor 2015!
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

Setup MAIN database with 2 clients - orientating question

Msg#: 4535097 posted 7:03 pm on Jan 10, 2013 (gmt 0)


Thank you in advance for pointing me in the right direction. I appreciate it.

I have 2 Joomla websites and both of the websites are holding alomost the same data. The end users can change their own data keeping their content up-to-date.

Now i don't want to manually check and replace the updated content on the other website. So i think i have to go for some kind of "master database" where both websites getting their data from. But it is also important that updates are transferred to the other database etc.

Are there some kind of "normal" approaches for questions of these? I can , for example, think of some XML scripts with cronjobs hosted on both websites to keep the main database up-to-date but i am wondering how big websites are arranging this.




WebmasterWorld Senior Member demaestro us a WebmasterWorld Top Contributor of All Time 10+ Year Member

Msg#: 4535097 posted 8:55 pm on Jan 10, 2013 (gmt 0)

I think the best way to do this is to run both sites off 1 Joomla instal

You would have to spend some time aligning the data but once that is done then no more work is really needed.

The best way to do this is with 2 templates.

SiteA URL invokes templateA
SiteB URL invokes templateB

You can logically split the content using categories.

All content belonging to SiteA is in the SiteA category

All content belonging to SiteB is in the SiteB category

Assuming you are in a Joomla 1.7 or higher than you can split the permissions by giving the admin of siteA access to anything with the siteA category but if the admins can access all content then you don't have to do that.

I have a couple sites working this way and it is pretty seamless.


Msg#: 4535097 posted 9:04 pm on Jan 10, 2013 (gmt 0)


Thank you for your answer. All websites are J2.5
I have thought about multiple templates as well.
Did you manage to use different toplevel domains for these websites as well?



Msg#: 4535097 posted 9:11 pm on Jan 10, 2013 (gmt 0)

Is this the way?:


Msg#: 4535097 posted 9:27 pm on Jan 10, 2013 (gmt 0)

Some more ideas?.

I have components installed like:
- kunena
- jomsocial
- k2
some with a fixed frontend and others with (for example kunena) multiple public forums but they should also be seperated by toplevel domains. Do you have experiences to share these with permissions as well?

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved