Shared exp between servers

wheeple · Post by **wheeple** » Sun Aug 27, 2006 5:06 pm

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?

Thanks

Post by **YamiKaitou** » Sun Aug 27, 2006 5:13 pm

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.

hyper · Post by **hyper** » Sun Aug 27, 2006 5:36 pm

I'm sure there is a way.

wheeple · Post by **wheeple** » Mon Aug 28, 2006 4:43 am

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?

Post by **ferret** » Mon Aug 28, 2006 12:58 pm

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.

wheeple · Post by **wheeple** » Mon Aug 28, 2006 8:42 pm

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?

Post by **Krazy** » Tue Aug 29, 2006 5:29 am

*Moved to the correct forum topic*

Post by **Geesu** » Tue Aug 29, 2006 7:22 am

Use MySQL, it works perfect.. I've had 6 different servers using the same DB... and Krazy has 2 (maybe 3) right now