XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. General XOOPS.org forums / 
  3. XOOPS.org Members Lounge 
  4.  / Sharing a table across multiple sites
Register
1
dheltzel
Sharing a table across multiple sites

  • 2004/2/9 23:51

  • dheltzel

  • Not too shy to talk

  • Posts: 164

  • Since: 2003/1/8 1


I plan to install multiple, related XOOPS sites into a single DB. I'd like to be able to share certain tables (for Agenda-X and the Links module) to make the data available to all the sites. Here are the options I've considered:

- Removing the database prefix from all the code would work, but is a lot of effort and and would have to be re-done with every new release.
- Views. MySQL doesn't (yet) support views.
- The MySQL replication seems like overkill, but I never tried it.
- Writing a cron script to sync the seems like my best option, but I was wondering if anyone else has any ideas.

Dennis
2
Mithrandir
Re: Sharing a table across multiple sites

There is a way (not tested myself, but the reports have been positive) to work on several XOOPS sites off of one single database. Try searching for "multi-sites" in news and forum.
3
dheltzel
Re: Sharing a table across multiple sites

  • 2004/2/10 18:56

  • dheltzel

  • Not too shy to talk

  • Posts: 164

  • Since: 2003/1/8 1


Yes, I've been following that topic and have most of it worked out. I just started playing with another option, to use a Linux/UNIX hard link of the MySQL files that comprise a table on disk. So far, results have been promising, but I'm still a little nervious about performing such trickery on a database server. It's also not an easy fix that someone else could perform through the web interface.

It would be more elegant to do this through XOOPS, because what I did has no visibility to the webmasters, but ya gotta do what ya gotta do

Dennis
4
Herko
Re: Sharing a table across multiple sites

  • 2004/2/10 20:42

  • Herko

  • XOOPS is my life!

  • Posts: 4238

  • Since: 2002/2/4 1


Ackbarr is working on this right now.

Herko
5
dheltzel
Re: Sharing a table across multiple sites

  • 2004/2/10 21:08

  • dheltzel

  • Not too shy to talk

  • Posts: 164

  • Since: 2003/1/8 1


Very good. If he is interested in database-literate tester, I'm available.

Dennis

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

368 user(s) are online (249 user(s) are browsing Support Forums)

Members: 0

Guests: 368

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits