Making a multiplayer town building game

Development Programming & Scripting
1

hello everybody.
I’m trying to make a game where you can build a town, mining, gathering, upgrading your town, with a map view where you can see the other people’s towns’ and contact with them.

I made a dedicated server, where i think there isn’t a problem. But i made 3 map in the game (login map, town map, map map) so i have to run 3 server at the same time. (and i think they can’t communicate with each other)
Every player data (like login data, town-, resources-, etc data) i store on one sql database and i access these data with varest plugin.

I think i don’t do this well. So my question is that would be, are you have better idea then use 3 dedicated server, and where can i access and store players own data in the game, because using an online database i think isn’t a best idea. ( every second inquiry the database 1000 times… impossible.)

Thank you for the help. (and sorry for my bad english)

2

i think i can use sublevels instead of the worlds. if the client open the level then the others won’t see it. change the actor for the sublevel and everything done.

but how can i store and access every player data on the server?

i tried out with structs, but that’s not only on the server but also on every client and i cannot get data from the server’s structs.