On.System Architecture
System Architecture (and it’s subfield Software Architecture) is a discipline which is surprisingly poorly covered. In a sense, it is still more an art than a science, and usually requires somebody intimately familiar with practical systems, to tell what’s to do and what’s to avoid when building a system.
IT Hares have lots of experience in both Software Architecture and more general System Architecture, and are trying to share their knowledge (and more importantly, their feelings) about them.
Historical Data in Databases. Audit Tables. Event Sourcing
November 21, 2016 by • “No Bugs” Bunny
Quote:
99% of reporting requests and 99.9% of analytics is purely historical
Another Quote:
Information within the audit table should be sufficient to validate/justify current state
Filed under: Book: D&D of MOGs1st beta of Vol. IV-VIOn.System ArchitectureDesign decisions(Re)Actors
Read moreChoosing RDMBS for OLTP DB
November 14, 2016 by • “No Bugs” Bunny
Quote:
As the RDBMS keeps modifying its tables – the tables gradually degrade
Another Quote:
As we can see from the table above – choosing your RDBMS it is not as easy as it might seem.
Filed under: Book: D&D of MOGs1st beta of Vol. IV-VIOn.System ArchitectureDesign decisions
Read moreUltimate DB Heresy: Single Writing DB Connection. Part II. Gradual Scalability. All the way from no-scale to perfect-scale.
November 7, 2016 by • “No Bugs” Bunny
Quote:
And after this split of USERS table, the system has achieved perfectly linear scalability.
Another Quote:
Start with a simple single-write-connection DB, with reporting running off the same DB
Filed under: Book: D&D of MOGs1st beta of Vol. IV-VIOn.System ArchitectureDesign decisions(Re)Actors
Read moreUltimate DB Heresy: Single Modifying DB Connection. Part I. Performance (Part II. Scalability to follow)
October 31, 2016 by • “No Bugs” Bunny
Quote:
Dealing with transaction isolation is very far from being a picnic
Another Quote:
One of such real-world systems was consistently processing over 30M real-world write transactions/day over one single DB connection, supporting ~100K simultaneous players.
Filed under: Book: D&D of MOGs1st beta of Vol. IV-VIOn.System ArchitectureDesign decisions(Re)Actors
Read more
Six Impossible Things Before Breakfast Ltd. © 2026. All rights reserved.
