Topic: SG V will be going flatfile, see link... Post edited (Read 5063 times)

Dizzy · « **on:** October 04, 2005, 11:23:16 am »

http://www.dynaverse.net/forum/index.php/topic,163360955.msg1122633715.html#msg1122633715

SG V was using an SQL Database. The server was crashing because this db method we were using doesnt work right.

We plan to restart using a flatfile db Wed. for testing and launch the new server this Friday night. For those of you who do not know the difference, the Sql db we were using was starting to crash and add errors to the db. Flatfile DB doesnt do that. Sorry, but SQL isnt ready for prime time. We all thought we had most of it worked out, but clearly there are issues. I hope you all agree that it was worth it, in time SQL will get us where we want to be. But for now, flatfile db is where its at.

I believe most players, 90% of you will agree that you'd trade all the cool things SQL can offer for a stable server. So, lets take a look at the differences:

SQL vs Flatfile:

OoB: SQL - We are able to have true OoB on SQL. Flatfile its all house rules and CnC.
Webyards: SQL - SQL has all the ships you want all the time. Flatfile is luck of the draw, what you see in the shipyard is what u get.
Stability: Flatfile - we reached a point where flatfile hardly crashes. SQL... well you just saw how well that works.
Map DV Edits: SQL - Allows admin to easily edit the db on the fly changing planets/bases/ and DV's. Much harder to do on flatfile.
Time: Flatfile - Adjusting time in flatfile is easy and allows us to 'run the clock up or down' to get to what era or year we want.

Charcater pp edits, webmaps, and most of the other stuff are equal. All in all, I'd prefer to stick with flatfile. And thats what we will do.
[/list]

So what changes are in store for SG? Well, a maximum of 20 DV's for all hexes for one. We will do away with the 30 DV's we had, which were few. The rest of the RM designed map will be the same, tho.

Webyards, gone. The shipyards will run at 5-6 minute intervals, so finding a ship wont be that hard. The server will start in 2265 and run a day a game year ending on 2286-7 3 weeks from Fri to the following Sun so game year progression will be brisk.

DV editing: The map dv edits for PvP kills will not happen every 7 days. Instead, we will use the same points system allowing each side to use them in order to 'simulate' the capture of an enemy VC. PvP kill DV Points will be added up and the difference will be used by the winning side to see if they have enough to stretch their DV's far enough into enemy space to 'score' a VC. Exact details later. The map wont change, but the VC will be awarded should that side have enough to capture the planet given the defense of the current DV's there.

Adding/reomoving Bases/planets: We will see how hard it is on flatfile, but it is possible. So during testing, this feature will be decided on.

Battle Reporting: No auto web battle reports. Instead, Bonk will attempt a DE style web based report system where u login, type your race, name and ship, the enemy players race, name and ship u killed, the points it was worth and mb the stardate. Then it will sort it for me by points, race, side, players, etc. A neat handy tool to look up all a players stats and kills and totals and so forth.[/list]

So, we wont lose too much going to flatfile, but to say we will have a stable server that doesnt crash once an hour or two is enough.

Diz

FPF-DieHard · « **Reply #1 on:** October 04, 2005, 11:25:56 am »

There is gooing news, we finally got that SQL test we were looking for

PS: Can we restart in 2263? I am a sadist

Dizzy · « **Reply #2 on:** October 04, 2005, 11:31:30 am »

Well we want to end at the end of 2286. So if we start Fri. and run 3 weeks ending on sunday, thats 22.5 days. Using a day for a game year we have 22.5 days, er game years and that ends us on 2287.5. But figure in a little downtime and we end up where we want.

2263... is... sadistic. I think 2265 is more popular. Why dont u make a poll

762_XC · « **Reply #3 on:** October 04, 2005, 11:32:37 am »

Can we save the map at least?

FPF-DieHard · « **Reply #4 on:** October 04, 2005, 11:33:06 am »

Quote from: Dizzy on October 04, 2005, 11:31:30 am

Why dont u make a poll

NO!!!!!!!!!!!!!!!!!!

Hexx · « **Reply #5 on:** October 04, 2005, 11:38:16 am »

Quote from: 762_XC on October 04, 2005, 11:32:37 am

Can we save the map at least?

And our prestige (hey 30k is alot for me..)

Dizzy · « **Reply #6 on:** October 04, 2005, 11:40:32 am »

Quote from: 762_XC on October 04, 2005, 11:32:37 am

Can we save the map at least?

As in the changes the RM's made at the start of this campaign? Yes I think so. But if you are reffering to the current map status, I dont see why. If you look at the hex ownership, the coalition are winning by less than 30 DV's. Sure, I'll give you 3 10 DV or 6 5 DV hexes. Its only fair.

762_XC · « **Reply #7 on:** October 04, 2005, 11:43:32 am »

"Why" is so people who were on at 3am flipping hexes don't feel like it was for nothing.

FPF-DieHard · « **Reply #8 on:** October 04, 2005, 11:45:07 am »

Quote from: 762_XC on October 04, 2005, 11:43:32 am

"Why" is so people who were on at 3am flipping hexes don't feel like it was for nothing.

Somebody needs a job <Snicker>

Dizzy · « **Reply #9 on:** October 04, 2005, 11:47:32 am »

Quote from: Hexx on October 04, 2005, 11:38:16 am

Quote from: 762_XC on October 04, 2005, 11:32:37 am
Can we save the map at least?

And our prestige (hey 30k is alot for me..)

Mb give enough pp to allow all players to but a decent cruiser. I think it also fair for those that had enough cash to buy a DN, 30k and a BC at 15k to award them that much. But with flatfile, it isnt an easy edit. So mb have just two sign in times, and you will have to be there for it. Mb have a one time account creation at 15k pp. And then do a general sign in at the default pp.

Its a bit of trouble to do that... especially to organize it so that players are there for it when it happens, but lets not burden the admins and playerbase for something so trivial in the grand scheme of a 3 week server. I earned some 19k myself, it wasnt easy, and sure I'd like a 15k start too, but its not a deal breaker for me cuz I actually had fun getting there. The variety of missions are pretty cool.

So I will try, hows that sound?

762_XC · « **Reply #10 on:** October 04, 2005, 11:50:07 am »

All we can ask.

Dizzy · « **Reply #11 on:** October 04, 2005, 11:51:39 am »

Quote from: 762_XC on October 04, 2005, 11:43:32 am

"Why" is so people who were on at 3am flipping hexes don't feel like it was for nothing.

Dont act like I'm brushing it off like your effort was for nothing. Read my post. I actually took the time to get on the webmap and look at it and determined your efforts were worth 30 DV's. And that I'd be happy to give them to you.

Let's not start nitpicking, tool. If you knew all the problems and time Bonk and I put in so you could get that 30 DV advantage, you'd also know your 30 DV asdvantage would be turned into a 30 DV disadvantage had we both been on the server instead.

Dizzy · « **Reply #12 on:** October 04, 2005, 11:54:07 am »

As of now, the SG V SQL Server is a fun server. For now, my efforts will be on shiplist pruning and preperations for a flatfile test launch for tomorrow and a live start Friday.

762_XC · « **Reply #13 on:** October 04, 2005, 11:56:01 am »

I'm not nitpicking, I'm trying to be sensitive to the peeps who might not burn off if they think their effort counted for something.

Just do your best. +1 for trying.

FA Frey XC · « **Reply #14 on:** October 04, 2005, 12:45:30 pm »

Okay well, I'm going to take this opportunity to do something I've needed to do for a while.

If the server isn't going "live" again until Friday, then look for an announcement tonight.

Regards,

KBFLordKrueg · « **Reply #15 on:** October 04, 2005, 01:03:44 pm »

I came home 2 hours early to have more time to play... $:-\$

Dizzy · « **Reply #16 on:** October 04, 2005, 01:14:53 pm »

Quote from: KBFLordKrueg on October 04, 2005, 01:03:44 pm

I came home 2 hours early to have more time to play... $:-\$

Ahahaha! That sux.

Hey, the server is still up... and there are some Alliance guys on to kill! Why dont u run some alien encounter missions... mb give us feedback on other stuff?

SideSwipe9th · « **Reply #17 on:** October 04, 2005, 01:26:10 pm »

question, what server method did attack of the kitties use? if it was the sql one how comes it didnt crash as much, did somethin get changed between now an then?

Dizzy · « **Reply #18 on:** October 04, 2005, 01:31:04 pm »

AOTK2 was flatfile. SG V was SQL. On Fri, SG V will relaunch with flatfile.

KBFLordKrueg · « **Reply #19 on:** October 04, 2005, 02:01:15 pm »

Quote from: Dizzy on October 04, 2005, 01:14:53 pm

Quote from: KBFLordKrueg on October 04, 2005, 01:03:44 pm
I came home 2 hours early to have more time to play... $:-\$

Ahahaha! That sux.

Hey, the server is still up... and there are some Alliance guys on to kill! Why dont u run some alien encounter missions... mb give us feedback on other stuff?

Logged on..Soreeyes was logging to do laundry...
boring...
Will the SQL one stay up for a few to give us something to do?
It'd be nice, but not a big deal if not.

Dizzy · « **Reply #20 on:** October 04, 2005, 02:07:11 pm »

It should be up now. If its not let me know. I'll reboot it when it goes down if Im around till we launch the test server tomorrow.

FPF-Tobin Dax · « **Reply #21 on:** October 04, 2005, 02:30:30 pm »

Quote from: 762_XC on October 04, 2005, 11:43:32 am

"Why" is so people who were on at 3am flipping hexes don't feel like it was for nothing.

and what about the half dozen who spent the morning for the alliance before this posting flipping it back?

KAT Chuut-Ritt · « **Reply #22 on:** October 04, 2005, 02:39:41 pm »

Quote from: Dizzy on October 04, 2005, 11:23:16 am

DV editing: The map dv edits for PvP kills will not happen every 7 days. Instead, we will use the same points system allowing each side to use them in order to 'simulate' the capture of an enemy VC. PvP kill DV Points will be added up and the difference will be used by the winning side to see if they have enough to stretch their DV's far enough into enemy space to 'score' a VC. Exact details later. The map wont change, but the VC will be awarded should that side have enough to capture the planet given the defense of the current DV's there.

This seems silly to me, you could actually lose a planet that no enemy came within several hexes of on the actual map under this system. I suggest rethinking this one a bit.

762_XC · « **Reply #23 on:** October 04, 2005, 02:45:10 pm »

Quote from: FPF-TobinDax on October 04, 2005, 02:30:30 pm

Quote from: 762_XC on October 04, 2005, 11:43:32 am
"Why" is so people who were on at 3am flipping hexes don't feel like it was for nothing.

and what about the half dozen who spent the morning for the alliance before this posting flipping it back?

Tobin, why are you trying to make this about A v C? I just asked if he could port the map.

Dizzy · « **Reply #24 on:** October 04, 2005, 02:58:10 pm »

Quote from: FPF-TobinDax on October 04, 2005, 02:30:30 pm

and what about the half dozen who spent the morning for the alliance before this posting flipping it back?

I made this post after i cked that. 30 DV's is all they get. The fighting was pretty even on both sides.

SideSwipe9th · « **Reply #25 on:** October 04, 2005, 03:04:07 pm »

one more question

will there be a new installer needed on relaunch, or will the current one be fine?

Dizzy · « **Reply #26 on:** October 04, 2005, 03:10:49 pm »

There will be a new shiplist because I deleted some unwanted ships, but most everything else most likely will stay the same.

FPF-DieHard · « **Reply #27 on:** October 04, 2005, 03:32:34 pm »

Quote from: Dizzy on October 04, 2005, 03:10:49 pm

There will be a new shiplist because I deleted some unwanted ships, but most everything else most likely will stay the same.

This is not needed, just delete them server-side.

Dizzy · « **Reply #28 on:** October 04, 2005, 03:39:13 pm »

They will be identical. Client and serverside will match even tho it has worked in the past being different.

New shiplist D/L tomorrow.

FPF-DieHard · « **Reply #29 on:** October 04, 2005, 03:53:58 pm »

Quote from: Dizzy on October 04, 2005, 03:39:13 pm

They will be identical. Client and serverside will match even tho it has worked in the past being different.

New shiplist D/L tomorrow.

That is not needed, the Donors need to be removed from the Server-side anyway.

If you can avoid putting people through another download, you should.

Bonk · « **Reply #30 on:** October 04, 2005, 04:02:11 pm »

"put people through"? You'd think it was painful.

We have modified the donation structure to the SFB-OP model. It is no longer necessary to remove the donors serverside, in fact it is preferable not to. It is related to script ship creation methods. Tracey can explain it better, but trust me on this one. The result is less buggy missions and the ability to use EEK missions.

Also, bear in mind that it only takes ~40 seconds to download the installer again whille it takes me about 40 minutes to upload it. Worse, it takes over 2 hours to upload the zip files for those who refuse to use the entirely more efficient and reliable installer. (though this time it would only be the shiplist zip which would a much shorter upload)

Dfly · « **Reply #31 on:** October 04, 2005, 06:49:15 pm »

Please continue as you guys are, because it is all good, and if DieHard has an issue with a small download perhaps he does not need it, but the rest of us will use it

Dfly · « **Reply #32 on:** October 04, 2005, 06:52:14 pm »

Quote from: Hexx on October 04, 2005, 11:38:16 am

Quote from: 762_XC on October 04, 2005, 11:32:37 am
Can we save the map at least?

And our prestige (hey 30k is alot for me..)

Dont feel bad Hexx, I was flying a paid Dread and had another 15,000+ in the bank.

Bonk · « **Reply #33 on:** October 05, 2005, 08:38:58 am »

I am working on the flatfile setup this morning, so Dizzy and Tracey stay clear of the server till I let you know. (I'm locked out of my remote session right now - possibly because one of you is logged in?)

Dizzy · « **Reply #34 on:** October 05, 2005, 08:48:30 am »

Not me.

Bonk · « **Reply #35 on:** October 05, 2005, 08:49:57 am »

NM, I think the session was just bugged, I logged me off from another machine and can connect again...

FPF-SCM_TraceyG_XC · « **Reply #36 on:** October 05, 2005, 11:54:46 am »

Wasn't me... I logged in yesterday (middle of the night your time) to restart it, took a look at the process sentinel but didnt have any luck. I then posted that the server was back up. It stayed up for about 10 minutes, then crashed again. I logged back in again, serverkit was completely shutdown as if it had just closed. I restarted it, it ran for maybe an hour then crashed again, at which time I think Dizzy logged in and restarted it. Havent been logged in to it since.

Bonk · « **Reply #37 on:** October 05, 2005, 12:08:46 pm »

Thanks Tracey, I worked it out, it was just a bugged session. I reset it from another server.

Weird about the process sentinel eh?

FPF-SCM_TraceyG_XC · « **Reply #38 on:** October 05, 2005, 12:13:51 pm »

Quote from: Bonk on October 05, 2005, 12:08:46 pm

Thanks Tracey, I worked it out, it was just a bugged session. I reset it from another server.

Weird about the process sentinel eh?

Yes, very weird, wouldnt start the server at all. Check your PMs by the way

FPF-DieHard · « **Reply #39 on:** October 05, 2005, 12:22:47 pm »

How exactly doe the DB get dirty in SQl? From what I remembered, AI opbejcts didn't get stuck when I was screweing around with this stuff about a year ago.

I did turns AIs off though . . .

Bonk · « **Reply #40 on:** October 05, 2005, 12:38:35 pm »

Quote from: FPF-DieHard on October 05, 2005, 12:22:47 pm

How exactly doe the DB get dirty in SQl? From what I remembered, AI opbejcts didn't get stuck when I was screweing around with this stuff about a year ago.

I did turns AIs off though . . .

Once during this test, a hex was corrupted by the cartel ownership being set to 2323 instead of 23... that seemed to be where the problems started.

Otherwise it is exactly the same as the flatfile for "dirtying the db"; dead mission AI accumulates from bugged missions caused by bad connections and ALTs. The server AI are created and destroyed regularly (I have it set to create one per turn and destroy up to 10 per turn - which does work - it provides a mimimum of AI, with allowAItotakehexes set to zero of course.)

Dfly · « **Reply #41 on:** October 05, 2005, 06:14:57 pm »

could it be a cascaded effect due to a single hex being corrupted? I know of other issues with other programs I have worked with in the past(not like mySQL) that can cascade once something is corrupted.

Nemesis · « **Reply #42 on:** October 05, 2005, 06:46:51 pm »

Quote from: FPF-DieHard on October 04, 2005, 11:25:56 am

There is gooing news, we finally got that SQL test we were looking for

PS: Can we restart in 2263? I am a sadist

Sounds good to me but then again I'm a Klingon.

News:

Topic: SG V will be going flatfile, see link... Post edited (Read 5063 times) var addthis_config = {"data_track_clickback":true};

762_XC

762_XC

762_XC

762_XC

762_XC

Topic: SG V will be going flatfile, see link... Post edited (Read 5063 times)