The same player on official and experimantal server?

[tak]

Hey everybody,
i have gotten a first taste of the experimental server some days ago, when the official server was down for a day (last weekend iirc). I expected both servers to use the same database, however, this was not the case.
I know, working in IT myself, that what i suggest now is a huge change in structure, nevertheless, i think it is the right thing to do.

Both servers need to use the same database.

Every player, and i mean every player i talked to, thinks that having the same character on both the official and experimental server would be an awesome thing to have. In case of downtimes, you could go on playing, train for XP, etc etc. The experimental server would finally see some use and decent testing, the load would be distributed more evenly, maybe even the lag issues would moderate a bit.
I'd love to see soemone from ngd comment on this (of course everyone else as well ).
IMO that would bring the game a step forward. Please share your thoughts on this. Thanks.

[Tyr]

First in the experimental server you get x10 xp gain. Also with some of the changes you have no idea how the structure of the database is modified. The experimental server is the first public test of new features and bug fixes it would be impossible to test if the databases were the same and could cause both servers to crash.

If you follow software devolvement best practices you need a development servers, test servers, and production servers. They are all independent systems and any change starts in the development systems first then is copied to the test systems and finally after QA has approved copied to the production system.

For the lag how are they going to find the root cause if the load is not focused on one server? The only way the lag is going to get fixed if we cause it to happen.

[niclam]

Hello,

I can't possibly explain it better than Tyr (Thank you Tyr, by the way).

Regards

[tak]

Originally Posted by Tyr

First in the experimental server you get x10 xp gain. Also with some of the changes you have no idea how the structure of the database is modified. The experimental server is the first public test of new features and bug fixes it would be impossible to test if the databases were the same and could cause both servers to crash.

If you follow software devolvement best practices you need a development servers, test servers, and production servers. They are all independent systems and any change starts in the development systems first then is copied to the test systems and finally after QA has approved copied to the production system.

For the lag how are they going to find the root cause if the load is not focused on one server? The only way the lag is going to get fixed if we cause it to happen.

Ok, i really didn't make clear what i want. I do not want ngd to use only one database. I want to be able to use my official character on the experimental server. I did not know about the x10 XP gain bonus (why is that implemented anyways?) but that is the only hurdle and that could likely be changed.
Something like a nightly cron job that dumps player data from one database to import in the other could do what i want. Developmental features would get some stress testing that way before making the transition to official. So i still think that having the same playerbase (the same database, yeah it was a crappy explanation of my intention) on both servers
would be beneficial to users and developers alike.

[Tyr]

The x10 xp gain is to help leveling so you can test any class at any level and not take forever leveling.

They do port the official data to the experimental server but how often they do that all depends on what is being worked on. I'm sure the structure of the database is changing all the time and putting in the effort to keep the data mappings is not practical. For the stress testing from time to time there is a server message to go to the experimental server granted it is in Spanish but it is not hard to guess what it means. The hard part is guessing what they need help testing. Then again most of the players speak Spanish so I understand why that is.

[tak]

The x10 XP mod could well be dropped, as you have explained it is a crutchthat would not be needed. There are at best a few ppl on the server, none of whom would take the pain to go through leveling with a character they won't really use, no matter the XP bonus.
I doubt that at this point in development there are any significant structural changes occurring to the database. I am also sure the official database is a subset of the development database, so just importing the values from official to dev should not be that big an issue. There would be a one time effort in writing a script that exports and imports data, afterwards that script would maybe need to be adjusted to include a new value here and there.

But those are implementation details, i do not want to argue about export scripts, only the guys from ngd know the table structure. I would even be willing to write that script if someone asked me to.

I see that at max there are a handful players on the dev server, a few more when the official is down. So the server is atm pretty much useless.
Once again: Having the official character on the dev server as well would be an incentive for ppl to go there from time to time, check out new features and write bug reports. There would be real load on the new features when Ra is down, not just like 60 ppl but 300. All sides win. So please, do not be irritated by my first ass-backwards attempt to explain what i want, i know what i am talking about. Take it at least into serious consideration. Thats all i ask for. Thanks for that and all (further) input.

[niclam]

Hi,

The idea of having the live database copied once in a while to the experimental server wouldn't be a bad one in other circumstances but:
- The experimental server will probably always be just one. The amount of live worlds will increase someday (fingers crossed).
- The experimental server is not just the pre-staging server but our sandbox our well. We usually do a lot of testing there, from quests to new features. While we do this, we tend to free ourselves of having to do support or being careful not to disturb the normal course of the game, this includes recalling all players into an area, spawning dangerous monsters at will, giving items away randomly at users, etc. So, sometimes the less users we have there, the better (don't think the amount of users we have now but in the future, where 30 could as well be 300).
- Our idea is that 'massive' tests on the experimental server are conducted on-demand, this means that we have to be there watching and recollecting statistics.
- Bug reports on the experimental servers are usually taken with a grain of salt because, honestly, there is stuff broken all the time.

That's just about it. And of course, replication is always a big issue when there is a lot of different systems interconnected, so adding one more replication part to worry about it's out of the question with our current budget and personnel (characters could broke if they are copied and we did some structural changes, so it wouldnt be as simple as doing a cron job with database replication).

Regards

[tak]

Hi niclam,
thanks for taking the time and explaining the inner workings a bit too bad i'll never see my warlock on the server but if its really the developers playground i can understand, i thought you maybe had another box somewhere off limits to the public.
As for having more live servers in the future i doubt that not a moment, i haven't played any game so much in ages, i even bought a new video card i didn't think i'd see another game i'd get so hooked on (the last was Q3, and that was a success wasn't it? )
I'd like to say thanks for making this great game available free of charge for beta testing, and especially say thank you for the linux client.
Keep up the good work, i look forward to seeing this game go gold. Thanks!

[niclam]

Well,

Having another server off limits was on our minds but due to budget constraints and that sometimes we really need the users help in testing new stuff, we decided against it.

Also, please keep in mind that the game will continue to be free even after gold (but will have premium content as well) and the Linux version will continue to exist.

And whenever we are on features at the time of launch (we might be missing a thing or two), it will be the beginning, not the end...

Regards

[Angelwinged_Devil]

Originally Posted by niclam

Also, please keep in mind that the game will continue to be free even after gold (but will have premium content as well) and the Linux version will continue to exist.

Regards

yay thanks , will it then be official ^^? I don't mind helping out a bit if it does, when I learn to code XD. For now, my studies are calling first