Setup MAIN database with 2 clients - orientating question - Databases forum at WebmasterWorld

Forum Moderators: open

Message Too Old, No Replies

Setup MAIN database with 2 clients - orientating question

jasperli

7:03 pm on Jan 10, 2013 (gmt 0)

Hello,

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.

Jasper

Demaestro

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.

jasperli

9:04 pm on Jan 10, 2013 (gmt 0)

Hi,

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?

Jasper

jasperli

9:11 pm on Jan 10, 2013 (gmt 0)

Is this the way?:
[docs.joomla.org...]

jasperli

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?