Issue 139 — January 27, 2017
Featured
Learn Redis The Hard Way (in Production) — How a popular hotel comparison site uses Redis heavily in production, including where things didn’t work as expected.
Trivago tutorial
Scuba: Diving into Data at Facebook [PDF] — A paper describing a commonly used system at Facebook for doing live, real-time analysis on terabytes of data. Related Hacker News discussion.
Facebook
Peloton: The Self-Driving Database Management System — An in-memory, DRAM/NVM optimized, relational database management system designed with autonomous operation and optimization in mind.
Carnegie Mellon University Database Group tools
[eBook] The Essential Guide to Queuing Theory — Queueing theory rules everything around you - Whether you’re an entrepreneur, engineer, or manager, queueing theory is one of the best ways to boost performance. This 30-page ebook demystifies the subject without requiring pages full of equations.
VividCortex sponsored
JanusGraph: An Open-Source, Distributed Graph Database — A highly scalable transactional graph database optimized for storing and querying large graphs with billions of vertices and edges distributed across a multi-machine cluster.
JanusGraph tools
The Probability of Data Loss in Large Clusters — Many distributed storage systems (e.g. Cassandra, Riak, HDFS, MongoDB,) can use replication to make data durable, but how does this affect the odds of data loss?
Martin Kleppmann story
1.1 Billion Taxi Rides on kdb+/q & 4 Xeon Phi CPUs — Q is a programming language with a built-in, column-oriented, in-memory and on-disk database called kdb+ that includes and extends SQL. Here’s a practical look at using it.
Mark Litwintschik tutorial
The Internals of PostgreSQL — Suzuki Hironobu covers the internals of PostgreSQL for database administrators and system developers in this helpful translation of his 2012 Japanese-language book.
Suzuki Hironobu story
GryadkaJS: A Paxos-Based Replicated Key/Value Layer On Top of Redis — Gryadka is a minimalistic Paxos-based master-master replicated consistent key/value layer on top of multiple instances of Redis.
Denis Rystsov tools
MySQL and Snap Packaging — A look at using ‘snaps’ (a new way of packaging apps for distribution on Linux) to distribute MySQL.
Yngve Svendsen
In brief
JanusGraph Picks Up Where TitanDB Left Off — JanusGraph is a new Linux Foundation project formed to continue development of the TitanDB graph database.
Alex Woodie news
InfluxDB 1.2 Released — ..with subqueries and 50% better write throughput on larger hardware.
Paul Dix news
Amazon Web Services news
Put your DB into overdrive on Linode’s SSD servers. — Whatever your preferred DB, get better performance by loading it on Linode. Use promo code
DB20 for 20ドル credit. linode sponsored
Mike Parsons tutorial
Providing Least Privileged Data Access in MongoDB — Read-only views (ROV) are a similar concept to table views found in relational databases.
MongoDB tutorial
Secure MongoDB and Protect Yourself from the Ransom Hack — Advice on how to protect yourself from MongoDB ransomware.
Severalnines tutorial
Kepner, Arcand, et al. story
Running Production PostgreSQL Systems on ARM Architecture — A whitepaper exploring if PostgreSQL on ARM is a viable option for your next project.
Kaarel Moppel opinion
Designing the UFC Moneyball using multiple databases — Gigi Sayfan from VRVIU shows us how analytics for sports can be done using Cassandra/Scylla, MySQL, and Redis.
Compose story sponsored
dataviz.tools tools
HikariCP: A Solid High-performance JDBC Connection Pool — Can support 10,000 simultaneous users.
Brett Wooldridge code
Venkataraman, Panda, et al.