This post talks about snapshot restores in AWS and how does it impact the performance of a database — This post covers volume snapshots with AWS as an example, but the concepts are generic and can be applied anywhere. Persistent Storage of Database Instances A database instance like MySQL or PostgresSQL normally uses a storage volume on which the data directory is mounted.

Pipelining and multiplexing, both suffer from head-of-line blocking. But what is head-of-line blocking and how does it impact the… — Head-of-line blocking or HOL blocking is a generic term in computer science that refers to a performance-limiting phenomenon that occurs when a line of packets is held up by the first packet. …

This post is about an interesting discussion that came up recently. There was a problem faced to which DNS-aware persistent http… — This post is about an interesting discussion that came up recently. There was a problem faced to which DNS-aware persistent http connections seemed to be a probable solution. I can understand if you have never heard of such a concept before, probably because its not so common or probably it…

Databases and Indexing — Databases and Indexing All sorts of databases or datastores provide some or the other king of indexing for the data they hold. Indexes provide a way, given a value for the indexed field, to find the record or records with that field value. A primary index is a clustered index on the primary…

Latency from a general point of view is a time delay between the cause and the effect of some physical change in the system being observed. — Latency from a general point of view is a time delay between the cause and the effect of some physical change in the system being observed. Request rate, error rate and request duration or latencies ( RED) are some of the key metrics which are commonly monitored in any online…

Canaries were once regularly used in coal mining as an early warning system. Toxic gases such as carbon monoxide, methane or carbon… — Canaries were once regularly used in coal mining as an early warning system. Toxic gases such as carbon monoxide, methane or carbon dioxide in the mine would kill the bird before affecting the miners. Signs of distress from the bird indicated to the miners that conditions were unsafe.