Zelaron Gaming Forum  
Stats Arcade Portal Forum FAQ Community Calendar Today's Posts Search
Go Back   Zelaron Gaming Forum > Zelaron Gaming > General Gaming

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next

 
Post Database topology
Reply
Posted 2003-01-08, 02:05 PM
One issue that will develop is the usage of mySQL users and databases. My current thinking is as follows:

databases:
master site db-- contains user info, preferences, master for starting templates for new sites, site list, and such
board db--contains this discussion board
session db--if implemented, will be used in keeping track of users online, when last online, etc. Basicly non-critical info related to users and/or viewers
site db--one for each site. contains template/style info, user style preferences, news content, articles, screenshot db,etc.

There will be a master account with access to all related databases which administration code will use to set up sites and gather data.
There will be an account to handle user management, and such with access to the board and session dbs, master site db, and probably the site dbs.
There will be a board account with board db and session db access, and read-only access to parts of the master db.
There will be an account for each site with access to its own site db, session db, and read-only access to parts of the master db.

The intention of this setup is to minimize risk of one part of the network messing up another part.

This is in no way set in stone, and I would like advice.
Old
Profile PM WWW Search
WetWired read his obituary with confusionWetWired read his obituary with confusionWetWired read his obituary with confusionWetWired read his obituary with confusion
 
 
WetWired
 



 

Bookmarks

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 

Posting Rules [Forum Rules]
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -6. The time now is 06:09 PM.
'Synthesis 2' vBulletin 3.x styles and 'x79' derivative
by WetWired the Unbound and Chruser
Copyright ©2002-2008 zelaron.com
Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
This site is best seen with your eyes open.