If you're in trouble and cannot find an answer to a question which goes beyond Stack Overflow...

If you have a not-so-usual solution for your problems but need to justify it to your boss...

If you like to think on your own rather than blindly follow "common wisdom" and "profound truth"...

...then 'No Bugs' Hare on Soft.ware might be the right place for you.

Your mileage may vary. Batteries not included

Assorted Rants Tagged ‘Server’, page 5:

Choosing RDMBS for OLTP DB

posted November 14, 2016 by "No Bugs" Hare

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.”
	[→]

posted November 7, 2016 by "No Bugs" Hare

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”
	[→]

posted October 31, 2016 by "No Bugs" Hare

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.”
	[→]

posted October 24, 2016 by "No Bugs" Hare

Quote:	“in real world, after deployment, most of the changes in DB structure are about widening columns and adding the new ones”
Another Quote:	“For documents and BLOBs, NoSQL is a natural habitat”
	[→]

posted October 17, 2016 by "No Bugs" Hare

Quote:	“The worst case of inconsistency happens when row X in database A is modified (by a Client connected to datacenter A), and the same row X in database B is independently modified too (by a Client connected to datacenter B).”
Another Quote:	“One way to avoid reports affecting operational DB, is via creating a read-only replica of our main operational DB – and running our reports off that replica.”
	[→]

posted October 11, 2016 by "No Bugs" Hare

Quote:	“for larger-scale MOGs, functionality-wise it is common to have 4 different types of databases: transactional processing (OLTP) DBs, real-time reporting DBs, archive DBs, and analytical DBs (OLAP)”
Another Quote:	“both MVCC-based and Lock-based DBMS issue locks (and therefore, both can cause all kinds of trouble such as deadlocks etc.); however, the difference lies with the number of locks issued by them.”
	[→]

posted September 6, 2016 by "No Bugs" Hare

Quote:	“for the purposes of the MOG network communications, I usually suggest using Euler angles to represent rotations/orientations”
Another Quote:	“One thing which persistently haunts 3D developers, is polygon count.”
	[→]