Software Architecture

AUGUST 24, 2017

Source: [link] Cassandra has tunable consistency which means that not only on the database level, you can tune the immediate and eventual consistency of your data per query/operation by setting the read CL (consistency level) and write CL. Comments and thoughts welcome.

Tuning 100

Tuning Software Architecture Database C++ 100

Software Architecture

AUGUST 24, 2017

Consistency The topic and concept of consistency is very important when you work with a distributed database like Cassandra. When you’re working with a database which runs on only one server, consistency is a non-issue. Read CL controls how many replica nodes must send their most recent copy of partition to the coordinator.

Software Architecture 100

Software Architecture Database Tuning Servers 100

SQL Performance

JULY 8, 2021

I spend a large amount of time translating software requirements into schema and queries. Every time we interact with software that displays a table, we can expect the columns to be sortable like this: Sort-By-Colunn is a great pattern when all the data can fit in the browser. The basic unit of SQL tuning is the query.

Design 92

Design Software Architecture Database Servers 92

O'Reilly Software

APRIL 4, 2018

Google was among the pioneers that created “web scale” architectures to analyze the massive data sets that resulted from “crawling” the web that gave birth to Apache Hadoop, MapReduce, and NoSQL databases. The data shape will dictate capacity planning, tuning of the backbone, and scalability analysis for individual components.

Architecture 80

Architecture Scalability Google Operating System 80

Adrian Cockcroft

MARCH 21, 2020

You need an “abtest” database service. In a small system this may be a table in a central relational database, but it’s best setup as a NoSQL data source using something like Amazon DynamoDB or Apache Cassandra, with a caching client library or at large scale a microservice data access layer.

Testing 52

Testing Tuning Database Cache 52