EVE Online Dev Tracker

We’re planning a SQL only blog for a later date where we can share more info on the various configs we have going on.

The param sniffing stuff, have not gotten deep into that yet, but that’s basically where the db team is at now - sql 2022 testing and excitement - it’s got a ton of great features that’ll be useful not only to us dba’s but our data engineering team as well.

Probably never. This is a safeguard that all the all nodes involved have finished their work in moving you; this is the timeout when the other nodes can move ahead if there is no confirmation.

No.

Inserting more characters here since evidently a reply must be 5 characters or more.

Every time we have upgraded hardware or optimized software, then players have brought more pilots for the next fleet fight.

I wrote this with input from @CCP_DeNormalized and others.

There is only one VM in Tranquility proper, and that is a proxy for internal use only. Everything player-facing is running directly in top of hardware. We have tested using VMs for some of the smaller player-facing services and it worked fine run-time but we had issues starting the cluster since the nodes running on the VMs would lag behind the nodes running on hardware.

There are many VMs and pods running in the Tranquility Ecosystem, inside AWS. None of them existed at the time of Tranquility Tech III but have added since then, outside the simulation/game cluster.

My current negotiations with Ops have us at a new DB VM with 512GB of ram to start with. We’ll see how it goes from there

They don’t generally like it when I start a convo haha

We do have several virtual db’s in production though and always looking to migrate away from bare metal where it makes sense (one of the new vm’s is a remote AlwaysOn read-replica)

We have a few test servers running windows/sql 2022 - all running fine at the moment, but I do recall hearing some issues with a windows patch causing reboot loops

The game cluster runs an intra-cluster heartbeat for all the nodes and then there are other tools that monitor the machines themselves, the operating system, and the SQL Server.

I’m not sure I understand the question; but all the machines run Windows Server as their operating system.

Difficult to say without knowing more details. I just tested logging in and opening a non-Jita market and it opened in a subsecond and everything was very responsive as I clicked around. This could be client-side because it needs to process your orders to highlight them but could be something else. Does the client halt, does it spin up to 100% CPU, does it log while this is happening?

There are specific nodes that handle the mapping requests that are sent via https://community.eveonline.com/support/fleet-fight/ but those are (currently) running on the same type of hardware as the TQ Tech IV “rank-and-file” machines as those machines perform better than the dedicated hardware in TQ Tech III.

The benefit of sending in Fleet Fight Notifications is that the solarsystem will be i...

We looked at many options and these choices were the best ones. You will note from the database blog https://www.eveonline.com/news/view/a-history-of-eve-database-server-hardware that I linked in this devblog that we looked at AMD choices is great detail and tested them.

We have verifiable metrics that the DB upgrade has worked well. We are still gathering data on the performance of the new solarsystem simulation hardware, it has only been a month and half in the cluster; but so far, so good.

Re. the issues you describe: Chat is not hosted in the London datacenter at all; rather it is in AWS Ireland and the EVE Client connects directly to it. Same goes for Search, and then Contrac...

No and perhaps yes. The deprecated hardware of TQ Tech III is headed for our other datacenter, where test servers are hosted. Ultimately then some of the hardware that will be deprecated there (which is then TQ Tech II or older) might get auctioned off.

We have concluded the maintenance on the bug reporting system.

As mentioned in the original post, the web-based interface to view/submit bug reports will remain offline while we work towards improving this system.

I understood a few words in this.

You IT nerds are rubbing off on me.