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

Database Weekly 148   . 

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

[Database Weekly](http://dbweekly.com) Issue 148 — March 31, 2017     

Featured [AgensGraph: A Transactional Graph Database based on Postgres](https://github.com/bitnine-oss/agensgraph?utm_source=dbweekly&utm_medium=email) — 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. bitnine [Streaming Databases in Realtime with MySQL, Debezium, and Kafka](https://wecode.wepay.com/posts/streaming-databases-in-realtime-with-mysql-debezium-kafka?utm_source=dbweekly&utm_medium=email) — The story of how a payment platform uses Debezium and Kafka Connect to stream MySQL databases into Kafka for use elsewhere. Chris Riccoministory [Elasticsearch 5.3.0 Released](https://www.elastic.co/blog/elasticsearch-5-3-0-released?utm_source=dbweekly&utm_medium=email) — New features include cross-cluster searches, a new unified higlighter, field collapsing, and a keystore to store secure settings. Elasticnews [Linode is the SPEEDIEST SSD host for your DB - simple, reliable & powerful.](https://welcome.linode.com/db-weekly/?utm_source=cooperpress&utm_medium=email&utm_term=db&utm_campaign=db-weekly-primary) — 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! linodesponsored [![\](https://copm.s3.amazonaws.com/c740311a.png)](https://welcome.linode.com/db-weekly/?utm_source=cooperpress&utm_medium=email&utm_term=db&utm_campaign=db-weekly-primary) [Debezium: Stream Changes From Your Databases](http://debezium.io/?utm_source=dbweekly&utm_medium=email) — 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. Red Hat [Faster SQL Through Choosing Natural Keys Over Surrogate Keys](https://dzone.com/articles/faster-sql-through-occasionally-choosing-natural-k?utm_source=dbweekly&utm_medium=email) — It’s surrogate keys versus natural keys. Which one should you be using? Is the answer really that obvious? It might not be. Lukas Edertutorial [Pachyderm: A Containerized Data Lake](http://pachyderm.io/?utm_source=dbweekly&utm_medium=email) — An open source, distributed data processing framework built on containers. [Version 1.4](https://medium.com/pachyderm-data/pachyderm-1-4-performance-boosts-simplified-data-partitioning-deployment-flexibility-and-more-c483e4942a6d) has just been released. Pachyderm, Inc.​ news In brief [Investors Bullish on MapD, a GPU-Based Database Startup](https://www.datanami.com/2017/03/29/investors-bullish-gpu-based-database-startup/?utm_source=dbweekly&utm_medium=email) Datanaminews [Bringing Big Data and HPC Together](https://www.datanami.com/2017/03/30/bringing-big-data-hpc-together/?utm_source=dbweekly&utm_medium=email) Datanaminews [SQL on Distributed GPUs Now Available on the AWS Marketplace](https://blog.blazingdb.com/sql-on-distributed-gpus-now-available-on-aws-marketplace-c2b80fe012aa?utm_source=dbweekly&utm_medium=email) BlazingDBnews [Creating an AWS VPC and Secured Compose MongoDB with Terraform](https://compose.com/articles/creating-an-aws-vpc-and-secured-compose-mongodb-with-terraform/?utm_source=cooper&utm_medium=newsletter&utm_content=db) — In this article, Yamil shows how to create secure connections to MongoDB using Terraform and Amazon VPC. Composetutorial sponsored [Analysing Petabytes of Websites](http://tech.marksblogg.com/petabytes-of-website-data-spark-emr.html?utm_source=dbweekly&utm_medium=email) — ..using Amazon Elastic MapReduce and Spark. Mark Litwintschiktutorial [Making Spark and Kafka Data Pipelines Manageable with Tuning](https://svds.com/making-spark-kafka-data-pipelines-manageable-tuning/?utm_source=dbweekly&utm_medium=email) Larry Murdocktutorial [How to Speed Up Your MySQL with Replication to an In-Memory Database](http://highscalability.com/blog/2017/3/29/how-to-speed-up-your-mysql-with-replication-to-in-memory-dat.html?utm_source=dbweekly&utm_medium=email) High Scalabilitytutorial [An Introduction to Running Microsoft SQL Server on Linux](http://www.vertabelo.com/blog/technical-articles/running-microsoft-sql-server-on-linux?utm_source=dbweekly&utm_medium=email) Vertabelotutorial [Storing and Using the IMDB Data in a Graph Database](http://bitnine.net/blog-graph-database/imdb-data-graph-database/?utm_source=dbweekly&utm_medium=email) Bitninetutorial [Analyzing A Year of Songs Played on the Radio with SQL, Spark, Spotify, and Databricks](https://medium.com/@polomarcus/analyze-one-year-of-radio-station-songs-aired-with-sql-spark-spotify-and-databricks-835fcf73df6?utm_source=dbweekly&utm_medium=email) Paul Leclercqtutorial [Breaking Out From MySQL's Character-Set Hell](https://medium.com/@manish_demblani/breaking-out-from-the-mysql-character-set-hell-24c6a306e1e5?utm_source=dbweekly&utm_medium=email) Manish Demblanitutorial [How to Fix Lagging MySQL Replication](https://thoughts.t37.net/fixing-a-very-lagging-mysql-replication-db6eb5a6e15d?utm_source=dbweekly&utm_medium=email) — _“Replication lag is a frequent issue with loaded MySQL clusters.”_ Fred de Villamilstory [A Key Expired In Redis, You Won't Believe What Happened Next](http://engineering.grab.com/a-key-expired-in-redis-you-wont-believe-what-happened-next?utm_source=dbweekly&utm_medium=email) — An investigation into how Redis deals with key expiration. Grab Engineeringstory [6 Crucial Redis Monitoring Metrics You Need To Watch](https://scalegrid.io/blog/6-crucial-redis-monitoring-metrics/?utm_source=dbweekly&utm_medium=email) ScaleGridopinion [SQL's 'IN' Predicate: With 'IN' List or With Array? Which is Faster?](https://blog.jooq.org/2017/03/30/sql-in-predicate-with-in-list-or-with-array-which-is-faster/?utm_source=dbweekly&utm_medium=email) JavaOOQopinion [PostgreSQL vs. MySQL and What to Pick As Your Next Analytical Database](http://www.silota.com/docs/getting-started/postgres-vs-mysql-database-analytics.html?utm_source=dbweekly&utm_medium=email) Ganesh Swamiopinion [AudioSet: A Dataset for Audio Event Research](https://research.googleblog.com/2017/03/announcing-audioset-dataset-for-audio.html?utm_source=dbweekly&utm_medium=email) — 2 million 10 second YouTube excerpts labelled with 527 categories. Googletools [Move Data Between MySQL and CrateDB with Shinkansen](https://crate.io/a/move-data-mysql-cratedb-shinkansen/?utm_source=dbweekly&utm_medium=email) — Crate is an [open source](https://github.com/crate/crate), distributed SQL database that combines SQL and search. Cratetools [hops-tensorflow: Easily Distributed TensorFlow on Hadoop](https://github.com/hopshadoop/hops-tensorflow?utm_source=dbweekly&utm_medium=email) Hops Hadoopcode    

Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/148) [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