DB Weekly Issue 148: March 31, 2017

AgensGraph: A Transactional Graph Database based on Postgres — An open source, multi-model database which supports both relational and graph-based data models, even supporting both SQL and openCypher within the same query.

Streaming Databases in Realtime with MySQL, Debezium, and Kafka — The story of how a payment platform uses Debezium and Kafka Connect to stream MySQL databases into Kafka for use elsewhere.

Elasticsearch 5.3.0 Released — New features include cross-cluster searches, a new unified higlighter, field collapsing, and a keystore to store secure settings.

Linode is the SPEEDIEST SSD host for your DB - simple, reliable & powerful. — MySQL? MariaDB? PostgreSQL? Whatever DB you use, run it on a Linode, the most scalable, reliable and fastest servers in the cloud. Use promo code DB20 for a 20ドル credit and get started!

Debezium: Stream Changes From Your Databases — An open source tool that captures row level changes in MySQL, MongoDB or Postgres databases so your apps can see and react to those changes.

Faster SQL Through Choosing Natural Keys Over Surrogate Keys — It’s surrogate keys versus natural keys. Which one should you be using? Is the answer really that obvious? It might not be.

Pachyderm: A Containerized Data Lake — An open source, distributed data processing framework built on containers. Version 1.4 has just been released.

Investors Bullish on MapD, a GPU-Based Database Startup

Bringing Big Data and HPC Together

SQL on Distributed GPUs Now Available on the AWS Marketplace

Creating an AWS VPC and Secured Compose MongoDB with Terraform — In this article, Yamil shows how to create secure connections to MongoDB using Terraform and Amazon VPC.

Analysing Petabytes of Websites — ..using Amazon Elastic MapReduce and Spark.

Making Spark and Kafka Data Pipelines Manageable with Tuning

How to Speed Up Your MySQL with Replication to an In-Memory Database

An Introduction to Running Microsoft SQL Server on Linux

Storing and Using the IMDB Data in a Graph Database

Analyzing A Year of Songs Played on the Radio with SQL, Spark, Spotify, and Databricks

Breaking Out From MySQL's Character-Set Hell

How to Fix Lagging MySQL Replication — "Replication lag is a frequent issue with loaded MySQL clusters."

A Key Expired In Redis, You Won't Believe What Happened Next — An investigation into how Redis deals with key expiration.

6 Crucial Redis Monitoring Metrics You Need To Watch

SQL's 'IN' Predicate: With 'IN' List or With Array? Which is Faster?

PostgreSQL vs. MySQL and What to Pick As Your Next Analytical Database

AudioSet: A Dataset for Audio Event Research — 2 million 10 second YouTube excerpts labelled with 527 categories.

Move Data Between MySQL and CrateDB with Shinkansen — Crate is an open source, distributed SQL database that combines SQL and search.

hops-tensorflow: Easily Distributed TensorFlow on Hadoop