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