Hey. I'm currently working on Multi-server game and I would like to create centralised registrations. Something like this. I have 5 servers users register They want to join one server, so they click joIn and it will "register" him with same acc details to one server user can do same thing to every server (they can join) I am asking, how should I do that? Just create DB table `users_global` and then have same tables for different servers just with different prefixes and then move user from users_global to s1_users ? Or could you suggest me better "style" of joining users to another servers with centralised DB (users) ?
I am asking how to "move" or "re-register" that user on certaily server (same DB with different prefix)
By "server" do you mean a web server? App server? Data server? Why are you wanting 5 instances of the game? To avoid concurrency issues, hold the user details in a central DB and just note which servers they are "registered" with on it rather than copying anything across anywhere.
server = game server. Each dedicated server can handle 3 servers for example. Why 5 instances of game? 1. each server can have different mods/speed 2. each server has limited number of users 3. Is it better to save 500 000 battle notifications rather than 100 000? no
How about you just have a single database server. If all of the servers are on a single network, you can have 5 servers set up to specifically handle the game, and a dedicated server to handle the data. A very easy solution to implement, and yet quite effective.