Personal Opinion Request Vote If You Agree!

Post Reply

Would you Like 3 databases Yes Or NO

yes
9
53%
no
8
47%
 
Total votes: 17

WiiStream

Personal Opinion Request Vote If You Agree!

Post by WiiStream » Wed Feb 13, 2013 3:50 pm

I personaly would like to see the core get three database connection.
Why well for one database we could connect to the accounts, and the account system, this would be good if we have our website off server host. And also for users to register on site and as they do they also register for the game..

Database one Login or Connect Server Option.
Database two Characters Server Option.
Database three World Server Options.

It would also be nice to have in the snv or svn in the sql folder the three databases
Example sql/login
Example sql/char
Example sql/world
This would have all the files needed for the server. but as you update it would be nice to have extra information
Example sql/login/updates/
Example sql/char/updates/
Example sql/world/updates/

It's just my opinion and it would be really nice if you agree vote.

User avatar
atom0s
Developer
Posts: 537
Joined: Thu Oct 25, 2012 9:52 am

Re: Personal Opinion Request Vote If You Agree!

Post by atom0s » Wed Feb 13, 2013 7:46 pm

If this happens, I'd suggest making it an option to do this as I'd rather not have to maintain 3 databases when all my servers are on the same machine. Easier having them all in a single db imo.

PrBlahBlahtson
Developer
Posts: 539
Joined: Sun Jul 22, 2012 12:17 am

Re: Personal Opinion Request Vote If You Agree!

Post by PrBlahBlahtson » Thu Feb 14, 2013 2:09 am

I still don't fully understand what's being asked for here, or if there's a purpose to it beyond "well it would be more convenient to me." Lobby-server handles the incoming logins and character selection, and then hands you off to map-server so you can wander around the world.

As for updates, that would become a substantial burden to keep maintained just because some people don't understand ALTER TABLE syntax. Hell, http://lmgtfy.com/?q=MySQL+add+column+to+table Not everyone updates their server everyday, so we'd have to maintain an archive and variety of upgrade scripts on the SVN.

User avatar
atom0s
Developer
Posts: 537
Joined: Thu Oct 25, 2012 9:52 am

Re: Personal Opinion Request Vote If You Agree!

Post by atom0s » Thu Feb 14, 2013 2:22 am

The only thing I see being useful for this is if you actually cluster your servers, but I doubt anyone is running a private server with that much traffic that requires this or anything close to it. The db itself is fairly small as it is, so there isn't much point to split it into separate parts.

Post Reply