---
title: "This week's database news, issue 139"
publication: "DB Weekly"
issue: 139
published_at: "2017-01-27"
canonical_url: "https://dbweekly.com/issues/139"
---

Database Weekly 139   . 

This week's database news -[Read this on the Web](http://dbweekly.com/issues/139) 

[Database Weekly](http://dbweekly.com) Issue 139 — January 27, 2017     

Featured [Learn Redis The Hard Way (in Production)](http://tech.trivago.com/2017/01/25/learn-redis-the-hard-way-in-production/?utm_source=dbweekly&utm_medium=email) — How a popular hotel comparison site uses Redis heavily in production, including where things didn’t work as expected. Trivagotutorial [Scuba: Diving into Data at Facebook [PDF\]](https://research.fb.com/wp-content/uploads/2016/11/scuba-diving-into-data-at-facebook.pdf?utm_source=dbweekly&utm_medium=email) — A paper describing a commonly used system at Facebook for doing live, real-time analysis on terabytes of data. Related [Hacker News discussion.](https://news.ycombinator.com/item?id=13463016) Facebook [Peloton: The Self-Driving Database Management System](http://pelotondb.io/?utm_source=dbweekly&utm_medium=email) — An in-memory, DRAM/NVM optimized, relational database management system designed with autonomous operation and optimization in mind. Carnegie Mellon University Database Grouptools [[eBook\] The Essential Guide to Queuing Theory](https://www.vividcortex.com/resources/queueing-theory?utm_campaign=DB%20Weekly&utm_source=ppc) — 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. VividCortexsponsored [![\](https://copm.s3.amazonaws.com/f389aae0.png)](https://www.vividcortex.com/resources/queueing-theory?utm_campaign=DB%20Weekly&utm_source=ppc) [JanusGraph: An Open-Source, Distributed Graph Database](https://github.com/JanusGraph/janusgraph?utm_source=dbweekly&utm_medium=email) — 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. JanusGraphtools [The Probability of Data Loss in Large Clusters](http://martin.kleppmann.com/2017/01/26/data-loss-in-large-clusters.html?utm_source=dbweekly&utm_medium=email) — 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 Kleppmannstory [1.1 Billion Taxi Rides on kdb+/q & 4 Xeon Phi CPUs](http://tech.marksblogg.com/billion-nyc-taxi-kdb.html?utm_source=dbweekly&utm_medium=email) — 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 Litwintschiktutorial [The Internals of PostgreSQL](http://www.interdb.jp/pg/index.html?utm_source=dbweekly&utm_medium=email) — Suzuki Hironobu covers the internals of PostgreSQL for database administrators and system developers in this helpful translation of [his 2012 Japanese-language book](https://www.amazon.com/Posutogure-esukyueru-zenkino-baiburu-posutoguresukyueru/dp/4774153923). Suzuki Hironobustory [GryadkaJS: A Paxos-Based Replicated Key/Value Layer On Top of Redis](https://github.com/gryadka/GryadkaJS?utm_source=dbweekly&utm_medium=email) — Gryadka is a minimalistic Paxos-based master-master replicated consistent key/value layer on top of multiple instances of Redis. Denis Rystsovtools [MySQL and Snap Packaging](http://mysqlrelease.com/2017/01/give-me-a-mysql-and-make-it-snappy/?utm_source=dbweekly&utm_medium=email) — A look at using ‘[snaps](http://snapcraft.io/)’ (a new way of packaging apps for distribution on Linux) to distribute MySQL. Yngve Svendsen In brief [JanusGraph Picks Up Where TitanDB Left Off](https://www.datanami.com/2017/01/13/janusgraph-picks-titandb-left-off/?utm_source=dbweekly&utm_medium=email) — JanusGraph is a new Linux Foundation project formed to continue development of the TitanDB graph database. Alex Woodienews [InfluxDB 1.2 Released](https://www.influxdata.com/influxdb-1-2-released-with-subqueries-and-50-better-write-performance-on-larger-hardware/?utm_source=dbweekly&utm_medium=email) — ..with subqueries and 50% better write throughput on larger hardware. Paul Dixnews [PostgreSQL Compatibility for Amazon Aurora Now Available (in Preview)](https://twitter.com/i/web/status/824036572269940736?utm_source=dbweekly&utm_medium=email) Amazon Web Servicesnews [Put your DB into overdrive on Linode’s SSD servers.](https://welcome.linode.com/db-weekly/?utm_source=cooperpress&utm_medium=email&utm_term=db&utm_campaign=db-weekly-sponsored) — Whatever your preferred DB, get better performance by loading it on Linode. Use promo code `DB20` for $20 credit. linodesponsored [Execute Millions of SQL Statements in Milliseconds in the Browser with WebAssembly and Web Workers](https://hackernoon.com/execute-millions-of-sql-statements-in-milliseconds-in-the-browser-with-webassembly-and-web-workers-3e0b25c3f1a6?utm_source=dbweekly&utm_medium=email#.wrx1wugzd) Mike Parsonstutorial [Providing Least Privileged Data Access in MongoDB](https://www.mongodb.com/blog/post/providing-least-privileged-data-access-in-mongodb?utm_source=dbweekly&utm_medium=email) — Read-only views (ROV) are a similar concept to table views found in relational databases. MongoDBtutorial [Secure MongoDB and Protect Yourself from the Ransom Hack](http://severalnines.com/blog/secure-mongodb-and-protect-yourself-ransom-hack?utm_source=dbweekly&utm_medium=email) — Advice on how to protect yourself from MongoDB ransomware. Severalninestutorial [Achieving 100,000,000 Database Inserts Per Second using Accumulo and D4M [PDF\]](http://www.ieee-hpec.org/2014/CD/index_htm_files/FinalPapers/31.pdf?utm_source=dbweekly&utm_medium=email) Kepner, Arcand, et al.​ story [Running Production PostgreSQL Systems on ARM Architecture](http://www.cybertec.at/running-production-postgresql-systems-on-arm-architecture/?utm_source=dbweekly&utm_medium=email) — A whitepaper exploring if PostgreSQL on ARM is a viable option for your next project. Kaarel Moppelopinion [Designing the UFC Moneyball using multiple databases](https://www.compose.com/articles/design-the-ufc-moneyball/) — Gigi Sayfan from VRVIU shows us how analytics for sports can be done using Cassandra/Scylla, MySQL, and Redis. Composestory sponsored [A Curated Guide to the Best Tools and Resources for Data Visualization](http://dataviz.tools/?utm_source=dbweekly&utm_medium=email) dataviz.​toolstools [HikariCP: A Solid High-performance JDBC Connection Pool](https://github.com/brettwooldridge/HikariCP/wiki/About-Pool-Sizing?utm_source=dbweekly&utm_medium=email) — Can support 10,000 simultaneous users. Brett Wooldridgecode [Drizzle: Fast and Adaptable Stream Processing at Scale [PDF\]](http://shivaram.org/drafts/drizzle.pdf?utm_source=dbweekly&utm_medium=email) Venkataraman, Panda, et al.​    

Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/139) [See our archives](http://dbweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK