“No Bugs” Bunny
OLTP Optimization 102: DYI Heterogeneous Replication. Part I (Basics)
October 24, 2017 by • “No Bugs” Bunny
Quote:
there are still several Big Fat Reasons™ to use DIY replicas
Another Quote:
With the Replication Messages described above, it is ok to apply Replication Messages to Slave DB which is newer than exactly necessary.
Filed under: Book: D&D of MOGs1st beta of Vol. VII-IXOn.ProgrammingOptimizations
Read moreOLTP DB Optimizations 102 – Group Commits
October 17, 2017 by • “No Bugs” Bunny
Quote:
if we can commit several transactions at the same time – RDBMS needs to fsync() our DB logs to physical disks only once
Another Quote:
if going our preferred way of single-writing-DB connection – make sure NOT to use RDBMS-level Group Commit
Filed under: Book: D&D of MOGs1st beta of Vol. VII-IXOn.ProgrammingOptimizations
Read moreOLTP DB Optimizations 102 –100% Coherent App-Level Cache for Single-writing-DB-connection
October 10, 2017 by • “No Bugs” Bunny
Quote:
with our app-level cache, we’re guaranteed to get exactly the same results as if we’d be querying the underlying database.
Another Quote:
why settle for invalidation when we can modify cache accordingly, saving on the extra DB request when we’re dealing with the same USER again?
Filed under: Book: D&D of MOGs1st beta of Vol. VII-IXOn.ProgrammingOptimizations
Read more





