Jump to content


Photo

Sharing membership across multiple servers


  • Please log in to reply
No replies to this topic

#1 peebrain

peebrain
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 24 October 2005 - 07:59 AM

I'm developing code for multiple servers, but I need the servers to share the same membership list. I have a table that stores things like username, email, password, etc..., but what is the best way to keep both servers updated on the data?

I was thinking having the data originate from server1, then once a day server2 would perform a cron job that would update all the information from server1, and insert/update the necessary rows on the cached data on server2. Get what I'm saying?

Is there an easier way? I was thinking of performing this cron job through a PHP script, but is there a way to have the MySQL databases talk to each other?

Thanks for your help.

~Sean




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users