tag:blogger.com,1999:blog-4967533318309432575.post9009878038480795582..comments2023-07-27T08:20:32.742-07:00Comments on Scram Web - An EVE Online Blog: Architecture of the EVE ClusterAnonymoushttp://www.blogger.com/profile/12266160412251006850noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-4967533318309432575.post-16987283498754600432010-09-05T18:11:32.579-07:002010-09-05T18:11:32.579-07:00I'm late finding this article and reading it, ...I'm late finding this article and reading it, but better late than never. Besides, it should have at least one comment.<br /><br />Your opinion about SQL Server as ideal for Eve caught my eye. I admit my opinion has been tainted by comments about SQL Server on the forums and in other blogs/forums not specific to Eve. There seems to be a lot of negative opinions about SQL Server, and I was ready to believe them. My experiences with Vista made it easy to believe MS could impair their DB product equally badly.<br /><br />I'm a server and network geek, so this stuff is a magnet to me also. I'd love to know more details about their node allocation algorithms and design constraints/decisions. I've done a bit of work with load balancing in a web server environment, but Eve goes so far beyond that. <br /><br />On load balancing, I was encouraged to read the recent dev blog about Character Nodes. It was interesting to read about creating a character node to the mix of existing nodes. It shows a broad thinking about the lag problem - not just code problems like those in the module lag dev blog, but also a back to basics look at the work to be done and how it's allocated to nodes.<br /><br />The Gamasutra article also reinforces how the single-shard environment of Eve is so win.Anonymousnoreply@blogger.com