Menu

IT Hare on Soft.ware

Tap to confirm selection

Subscribe:

Your mileage may vary. Batteries not included

Development & Deployment of Multiplayer Online Games, page 2/15 :


OLTP Database Optimization 102 – DIY Heterogeneous Replication (Part II)

Quote:
“The point of Super-Replica is that it is a replica Slave DB which is larger than original Master DB”
Another Quote:
“this “don’t write some HISTORICAL data to Master DB” approach can easily allow to reduce the load on the Master OLTP DB by a factor of 2x-3x”

OLTP Optimization 102: DYI Heterogeneous Replication. Part I (Basics)

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.”

OLTP DB Optimizations 102 – Group Commits

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”

OLTP DB Optimizations 102 –100% Coherent App-Level Cache for Single-writing-DB-connection

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?”

Outline for Chapter on Bot Fighting and Anti Reverse Engineering

[[This is Outline of Chapter 29 from “beta” Volume VIII of the upcoming book "Development&Deployment of Multiplayer Online Games", which is currently being beta-tested. Beta-testing is intended to improve the quality of the book, and provides free e-copy of the "release" book to those who help with improving; for further details see "Book Beta Testing". All the content published during Beta Testing, is subject to change before the book is published. To navigate through the "1st beta" of the book, you may want to use Development&Deployment of MOG: Table of Contents.]] As I am speaking on CPPCON2017 on Friday, I…