Jump to content

SQL Host Hardware Upgrades


Telephone

Recommended Posts

  • City Council
1 minute ago, Doc_Scorpion said:

Just out of curiosity, do you recall the cap in the 2019 time frame?  When I finally came back in Aug/Sept of that year, three red dots on Excelsior were pretty common.  IIRC, a combination of natural erosion of the playerbase and upgrading the hardware brought an end to that.  I don't recall seeing heavy loads after mid/late 2020 or so.

 

The red dots have nothing to do with the cap.

 

The red dots are hardcoded to appear once there are more than 1,100 players concurrent on the shard. That applies regardless of what the cap or queue threshold is set to. As far as I can tell that's always been the case and has never changed. Yellow dots appear above 250.

  • Thanks 3
Link to comment
Share on other sites

  • City Council
28 minutes ago, wjrasmussen said:

Things have been feeling more databasey today.

 

The impending upgrade must have the old server shaking in its rack, we haven't migrated to the new host just yet 🙂

 

  • Haha 1

Cipher

City Council

 

If you need help, please submit a support request here or use /petition in-game.

 

Got time to spare? Want to see Homecoming thrive? Consider volunteering as a Game Master!

Link to comment
Share on other sites

1 hour ago, BurtHutt said:

I don't have facts but will throw common sense at you (which is not common, clearly). If Live had 1500 players per shard and had 12 shards or so, they wouldn't survive. The sub fee from 1500 people per shard would not come close to covering their costs etc.

 

The HC capacity is far different than Live.

Stop and re-read what you wrote.  No one is even close to saying that live had 1500 players per shard.  You're confusing numbers of players online simultaneously with total number of paying customers.

  • Like 4

Originally on Infinity.  I have Ironblade on every shard.  -  My only AE arc:  The Origin of Mark IV  (ID 48002)

Link to the story of Toggle Man, since I keep having to track down my original post.

Link to comment
Share on other sites

As a sysadmin quite fluent in the horrors of database administration, you have my sympathies.

 

Especially if it's Interbase.  Good Gawd Awmighty, you'd have my prayers.

  • Haha 1
  • Thumbs Up 2

 Everlasting's Actionette 

Also Wolfhound, Starwave, Blue Gale, Relativity Rabbit, and many more!

Link to comment
Share on other sites

If watching the IT Crowd taught me anything, it's that this could be fixed by simply turning it off and on again. 

  • Haha 6
  • Pizza (Pineapple) 1

Sky-Hawke: Rad/WP Brute

Alts galore. So...soooo many alts.

Originally Pinnacle Server, then Indomitable and now Excelsior

Link to comment
Share on other sites

Call me an old IT guy, but powersets, story arcs and new zones are nice, but infrastructure and stability is sexy as hell.  

  • Like 1
  • Thumbs Up 3
  • Pizza (Pepperoni) 1
  • Pizza (Pineapple) 2

 

 


"She who lives by the cybernetic monstrosity powered by living coral, all too often dies by the cybernetic monstrosity powered by living coral."  -Doc Buzzsaw


Pineapple 🍍 Pizza 🍕 is my thumbs up. 

Link to comment
Share on other sites

I clearly remember there being multiple instances of Atlas park on busy nights shortly after launch on Live.
2 instances were pretty common, and I feel like I remember a few times it even went as high as 4.
(but they may have had smaller thresholds early on, or I'm misremembering)

So Homecoming, as it is now, seems pretty inline with what I remember from my time playing early CoH in terms of population.

I definitely remember Rubberbanding was a HUGE problem, comparable with Asheron's Call's rubberbanding.
So all of these problems feel like nostalgia to me, lol.

spacer.png  Peacebringer Wispur 

Link to comment
Share on other sites

On 1/24/2024 at 1:37 PM, Number Six said:

The red dots have nothing to do with the cap.

What about the three seashells.

  • Haha 4

Girls of Nukem High - Excelsior - Tempus Fabulous, Flattery, Jennifer Chilly, Betty Beatdown, Two Gun Trixie

Babes of War - Excelsior - Di Di Guns, Runeslinger, Munitions Mistress, Tideway, Hard Melody, Blue Aria

 

Several alts and of course my original from live on Freedom, OG High Beam (someone else has her non OG name)

Link to comment
Share on other sites

On 1/24/2024 at 7:00 PM, starro said:

Call me an old IT guy, but powersets, story arcs and new zones are nice, but infrastructure and stability is sexy as hell.  

I know right.  I may have to set aside some carnival time with myself.

  • Haha 1

Girls of Nukem High - Excelsior - Tempus Fabulous, Flattery, Jennifer Chilly, Betty Beatdown, Two Gun Trixie

Babes of War - Excelsior - Di Di Guns, Runeslinger, Munitions Mistress, Tideway, Hard Melody, Blue Aria

 

Several alts and of course my original from live on Freedom, OG High Beam (someone else has her non OG name)

Link to comment
Share on other sites

Well, considering you're hitting all three of the hardware "gotchas" (sufficient CPU (speed and total processing power), memory and solid state drives, here's hoping this upgrade will fix (or at least ameliorate) the issue.

And yes, I'm preaching to the choir.  But look at how much memory gets held onto (Properties/Memory - Minimum Server Memory) before clearing the DB.

If you're set to default 0 MB, this can cause slowdowns as the system tries to dump memory and can actually cause processes to hang.
Worse, with zero, it can sometimes cause the service to choke itself out (memory starvation),

Try 256/512/1024.

I've run into this on several clients and have gotten beneficial results.

If this doesn't appear to be your case, feel free to file my suggestion in the bit bucket.
 

If you want to be godlike, pick anything.

If you want to be GOD, pick a TANK!

Link to comment
Share on other sites

It's in progress! Here's to more stability! (Gotta have it somewhere in life, amiright?)

  • Like 1

Sky-Hawke: Rad/WP Brute

Alts galore. So...soooo many alts.

Originally Pinnacle Server, then Indomitable and now Excelsior

Link to comment
Share on other sites

2 minutes ago, BlackHorde22 said:

What's the largest factor to memory / data need?

Could it be the Architect with soooooo many created maps taking up all the memory and space?

AE maps are small, even the very long ones. My very long story with nothing but custom critters and villain groups totals out at 357kb for the whole file.

  • Thumbs Up 1

Lockely's AE Tales:

H: The Rook's Gambit (Arc ID 49351), P: Best Left Buried (WIP)

Link to comment
Share on other sites

I understand that this requires a shutdown of the system used for those two shards, but why does it shut down ALL the shards? Two of the shards are on one machine, the other two NA shards are on another, and then the EU shard is on a separate machine in (IRRC) Germany. Shouldn't you just be able to shut down one machine, upgrade/replace it, then run a reset to make sure it is connected properly and running?

Link to comment
Share on other sites

On 1/24/2024 at 10:07 AM, Doc_Scorpion said:


Yeah, me too.  I've seen nothing on Excelsior that even remotely resembles what I regularly saw on Freedumb back in the day in terms of players and activity.  Not in invasions, not in GM hunts, not in the LFG channel, not anywhere.

The OP is correct that compared to the rest of the market CoX was a small population, niche game.  But I'm not buying the claim that Homecoming even approaches anything resembling the numbers back in the OG days.

The game is also quite different today, with SO many people doing nothing but power-levelling, farming or doing post-50 content... the servers have always seemed sparse (until recently) compared to back in the day. I can't remember the last time I saw or was able to participate in 2-4 man teams just running around doing missions when that used to be the order of the day.

  • Like 1
Link to comment
Share on other sites

On 1/30/2024 at 12:03 PM, Hyperstrike said:

Well, considering you're hitting all three of the hardware "gotchas" (sufficient CPU (speed and total processing power), memory and solid state drives, here's hoping this upgrade will fix (or at least ameliorate) the issue.
 

 

Gotta listen to a man who'll use 'ameliorate' in casual conversation. 🙂

  • Haha 1
Link to comment
Share on other sites

11 minutes ago, Jordisk said:

I understand that this requires a shutdown of the system used for those two shards, but why does it shut down ALL the shards? Two of the shards are on one machine, the other two NA shards are on another, and then the EU shard is on a separate machine in (IRRC) Germany. Shouldn't you just be able to shut down one machine, upgrade/replace it, then run a reset to make sure it is connected properly and running?

 

Because it's not just the two shards for one thing.  They're also performing weekly maintenance on the other three shards.

Link to comment
Share on other sites

  • City Council
16 minutes ago, Jordisk said:

I understand that this requires a shutdown of the system used for those two shards, but why does it shut down ALL the shards? Two of the shards are on one machine, the other two NA shards are on another, and then the EU shard is on a separate machine in (IRRC) Germany. Shouldn't you just be able to shut down one machine, upgrade/replace it, then run a reset to make sure it is connected properly and running?

 

Global services like the auction house, chat server, etc. work by the service itself connecting to each shard, and if one of the shards are down it tries to reconnect every few seconds. But it does this synchronously, freezing the entire process, and causes lag on the other shards if they are waiting for a reply from the service.

 

Also accountserver is not the most well written piece of software and instead tends to get really crashy if shards are down.

  • Like 2
  • Thanks 3
  • Thumbs Up 1
Link to comment
Share on other sites

can someone explain this to me like i am a five year old? 😄

  • Haha 1

"I'm not crazy, my reality is just different than yours" the Cheshire Cat

"Ce n'est rien de mourir; c'est affreux de ne pas vivre"

(It's nothing to die, it's terrible not to live) Jean Valjean

"وطن المرء ليس مكان ولادته و لكنه المكان الذي تنتهي فيه كل محاولاته للهروب”

(Home is not where you were born, home is where all your attempts to escape cease.) Naguib Mahfouz

Link to comment
Share on other sites

  • City Council
29 minutes ago, BlackHorde22 said:

What's the largest factor to memory / data need?

Could it be the Architect with soooooo many created maps taking up all the memory and space?

 

No, on SQL it's simply having more buffer cache. It's about getting as much of the character database in-memory as possible to minimize I/O wait, which gets amplified in high load scenarios when the game's dbserver has a large amount of database transactions pending.

 

AE missions are on a completely different VM and don't even go into SQL.

  • Haha 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...