LinuxQuestions.org
Did you know LQ has a Linux Hardware Compatibility List?
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices

Reply
 
Search this Thread
Old 11-06-2009, 12:34 AM   #1
Thor_2.0
Senior Member
 
Registered: Nov 2007
Location: Somewhere on my hard drive...
Distribution: Manjaro
Posts: 2,210
Blog Entries: 23

Rep: Reputation: 279Reputation: 279Reputation: 279
Question MySQL - Confederated tables -How?


Hi,

My project uses mySQL, of course. There are several databases in the system, each has a members table that is identical to the ones in the others. Members are checked as active of non-active (money). Now, opposed to editing every members table in every database, I'd like to adopt the following approach: house the members table in a separate database, edit that and have the update "seep" through to the databases, a likley-like the "other" db server where you'd link tables between databases. I heard the term "confederated" tables.

Any ideas where to get info, some howto and some examples?

Thanks!!

Thor
 
Old 11-06-2009, 01:30 AM   #2
wfh
Member
 
Registered: Sep 2009
Location: Northern California
Distribution: Ubuntu Debian CentOS RHEL Suse
Posts: 164

Rep: Reputation: 44
Would you *NEED* to have updates "seep through" to other tables?

Authentication, authorization and account capabilities are really something you can pull from the user database. You want, perhaps, a hash of "capabilities" which can be used when parsing requests by the user for services....does the hash match the requirement for access to useful functionality.

Is that what you're looking for? If so, you only need a query to update the users' access limits and a query to retrieve the authorization and compare it to the current request for service.
 
Old 11-06-2009, 02:02 AM   #3
Thor_2.0
Senior Member
 
Registered: Nov 2007
Location: Somewhere on my hard drive...
Distribution: Manjaro
Posts: 2,210
Blog Entries: 23

Original Poster
Rep: Reputation: 279Reputation: 279Reputation: 279
Hi,

Thanks for the reply...the members, though, are not related to the database users. They'd be members of an archery club. Points collected in competitions and so would be kept in that table.

The MySQL user would be the site itself, the PHP logs in via a password.

So, getting the userdata is not what I'm after. Sorry...

Thor

Last edited by Thor_2.0; 11-06-2009 at 02:02 AM. Reason: Typos, soooo many typos...
 
  


Reply

Tags
links, replication, tables


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting 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


Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql query two tables please Help Mike1569 Linux - Server 2 07-09-2009 12:31 AM
mysql reinstallation distorted by previous tables in /var/mysql mad4linux Linux - Software 0 10-04-2005 01:39 PM
MySQL tables from 4.0 to 3.0 michaelbhahn Linux - Software 0 08-31-2004 10:23 AM
mysql tables with a - pk21 Linux - Software 7 05-23-2003 06:27 AM
mysql tables noord28 Linux - Newbie 0 02-20-2003 02:56 AM


All times are GMT -5. The time now is 05:23 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration