×
Blue Eagle (1.5.0) for K5.1 is released (20 Jul 2018)

Please update the Kunena Blue Eagle to 1.5.0 if you use Kunena 5.1.
We made several bug fixes and improvements. Also Blue Eagle has now all the features from Crypsis.
Download: www.kunena.org/download/templates/category/blue-eagle-5

Question Two Sites using One Database?

More
2 years 2 months ago - 2 years 2 months ago #1 by Burly Nerd
The way this particular Joomla! site is set up, the database server is on a different server at the same host. I am considering setting up a second Joomla! site, at the same host, but pointing to the same MySQL database.

The idea is that both Joomla! sites will have the full set of Forums available, but each of them will send visitors to a different forum, when they first arrive. I don't want visitors to have to register twice.

They are both sites about the same community, but one site is focused on government issues, while the other is focused on entertainment and food. All of the Kunena settings will be kept identical on each site.

As an alternative, I am considering setting up the forums on their own, single site, and sending visitors to that, from the other two sites. I will simply have to set up an intuitive way for them to return to their original site, if I do that.

Do you see any major problems with doing this? I plan to start building this tomorrow, so I would appreciate any forewarnings that may prevent me from wasting my time.

Thanks in advance, for any constructive comments.

BN
Last edit: 2 years 2 months ago by Burly Nerd.

Please Log in or Create an account to join the conversation.

More
2 years 2 months ago #2 by sozzled

Burly Nerd wrote: Do you see any major problems with doing this?

Your idea should theoretically work however there is the potential if two sets of SQL transactions hit the database at exactly the same time, that some database updates might be transacted out of sequence and, because MySQL is not an transactional database, there's no roll-back facility. But, theoretically, it should work.

I remember—a few years ago—running a couple of sites that shared the same database and I didn't encounter any errors.
The following user(s) said Thank You: Burly Nerd

Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to add attachements.
  • Not Allowed: to edit your message.
Time to create page: 0.071 seconds