Page 1 of 1

Shared exp between servers

Posted: Sun Aug 27, 2006 5:06 pm
by wheeple
I was curious if it's possible to share experience over multiple servers at once.. I would imagine you could do this with MySQL but the problem I'm having is only one server is allowed to write, so the changes on one server will reset. (I suppose I should have thought of this, woops)

So is there any way to share the exp over multiple servers?


Posted: Sun Aug 27, 2006 5:13 pm
by YamiKaitou
Don't think so. Cause when one server saves to the database, it overwrites any data there. So, when the other server writes to the database, it would overwrite the data the other server just put in.


Posted: Sun Aug 27, 2006 5:36 pm
by hyper
I'm sure there is a way.

Posted: Mon Aug 28, 2006 4:43 am
by wheeple
YamiKaitou, yes.. but theres only one person with the same SteamID in each server.. so it shouldn't overwrite each other.. or am I mistaken?

Posted: Mon Aug 28, 2006 12:58 pm
by ferret
Theoretically possible. Just have both use the same MySQL table. You are correct, there can never be a case where someone with the same STEAMID is on more than one server.

I don't see any reason it wouldn't work.

Posted: Mon Aug 28, 2006 8:42 pm
by wheeple
Yea, but it won't write properly on one server.. it just resets it to the previous value. (The one that opens the MySQL connection first)

Any ideas?

Posted: Tue Aug 29, 2006 5:29 am
by Krazy
*Moved to the correct forum topic*

Posted: Tue Aug 29, 2006 7:22 am
by Geesu
Use MySQL, it works perfect.. I've had 6 different servers using the same DB... and Krazy has 2 (maybe 3) right now