---
title: "#157: A Comparison of Advanced, Modern Cloud Databases"
publication: "DB Weekly"
issue: 157
published_at: "2017-06-02"
canonical_url: "https://dbweekly.com/issues/157"
---

Database Weekly 157   

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

[Database Weekly](http://dbweekly.com) Issue 157 — June 2, 2017     

[A Comparison of Advanced, Modern Cloud Databases](https://brandur.org/cloud-databases?utm_source=dbweekly&utm_medium=email) — A non-exhaustive primer of modern cloud database solutions like Aurora, Cosmos, and Spanner. Brandur Leachopinion [View Counting at Reddit with Cassandra and Redis](https://redditblog.com/2017/05/24/view-counting-at-reddit/?utm_source=dbweekly&utm_medium=email) — Reddit is so popular that even counting the number of views posts get provides an interesting technical challenge, as explained here. Upvotedstory [Monitoring Databases: A Product Comparison](https://www.percona.com/blog/2017/03/16/monitoring-databases-a-product-comparison/?utm_source=DBTA&utm_medium=Newsletter&utm_campaign=Percona_Blog) — Percona’s Manjot Singh reviews five of the top database monitoring solutions on the market. Get his breakdown in [this blog.](https://www.percona.com/blog/2017/03/16/monitoring-databases-a-product-comparison/?utm_source=DBTA&utm_medium=Newsletter&utm_campaign=Percona_Blog) SelectStarsponsored [![\](https://copm.s3.amazonaws.com/8e1dcac9.png)](https://www.percona.com/blog/2017/03/16/monitoring-databases-a-product-comparison/?utm_source=DBTA&utm_medium=Newsletter&utm_campaign=Percona_Blog) [Amazon RDS Now Supports Stopping and Starting of DB Instances](https://aws.amazon.com/about-aws/whats-new/2017/06/amazon-rds-supports-stopping-and-starting-of-database-instances/?utm_source=dbweekly&utm_medium=email) — Makes things easier and more affordable in development and test situations. Amazon Web Servicesnews [On Retiring Support for the Query Cache in MySQL 8.0](http://mysqlserverteam.com/mysql-8-0-retiring-support-for-the-query-cache/?utm_source=dbweekly&utm_medium=email) Morgan Tockernews Tutorials and Stories [How to Build a Non-Volatile Memory DBMS](https://www.cs.cmu.edu/~jarulraj/pages/sigmod_2017_tutorial.html?utm_source=dbweekly&utm_medium=email) — Slides, a paper, and a video on building a new DBMS given the changes to hardware landscape due to non-volatile memory. Joy Arulrajtutorial [How Pandora Uses Kafka](https://www.datanami.com/2017/05/31/pandora-uses-kafka/?utm_source=dbweekly&utm_medium=email) — Kafka and related technologies have proven ‘critical to Pandora’s success’ in serving their 80 million active users. Alex Woodiestory [How to Find Redundant Indexes in SQL](https://blog.jooq.org/2017/06/01/how-to-find-redundant-indexes-in-sql/?utm_source=dbweekly&utm_medium=email) JOOQtutorial [When to Use Bind Values, and When to Use Inline Values in SQL](https://blog.jooq.org/2017/05/30/when-to-use-bind-values-and-when-to-use-inline-values-in-sql/?utm_source=dbweekly&utm_medium=email) JOOQtutorial [Writing a Firebase Clone with Postgres and Node.js (Part 1)](https://medium.com/@patrickackerman/writing-a-firebase-clone-with-postgresql-and-node-js-part-i-d0bf1d8f0ea8?utm_source=dbweekly&utm_medium=email) Patrick Ackermantutorial [Getting Started with MySQL High Availability](https://dzone.com/articles/getting-started-with-mysql-high-availability?utm_source=dbweekly&utm_medium=email) Veer Abheek Singh Manhastutorial [Hybrid Data Encryption by Example using MySQL Enterprise Edition](http://mysqlserverteam.com/hybrid-data-encryption-by-example-using-mysql-enterprise-edition/?utm_source=dbweekly&utm_medium=email) Mike Franktutorial [Postgres 10's New Features with Examples [PDF\]](http://h50146.www5.hpe.com/products/software/oe/linux/mainstream/support/lcc/pdf/PostgreSQL_10_New_Features_en_20170522-1.pdf?utm_source=dbweekly&utm_medium=email) Noriyoshi Shinodatutorial [Breaking the WiredTiger Logjam: The Write-Ahead Log](https://engineering.mongodb.com/post/breaking-the-wiredtiger-logjam-the-write-ahead-log-1-2?jmp=cpress&utm_campaign=WW_CP_newsletter_sponsorship_FY17Q2&utm_content=sponsored&utm_medium=display&utm_source=dbweekly0601) — Learn how the WiredTiger write-ahead log orchestrates many threads writing to a single buffer without locking. MongoDBsponsored [Migration From MySQL to TiDB to Handle Tens of Millions Rows of Data Per Day](https://pingcap.github.io/blog/2017/05/22/Comparison-between-MySQL-and-TiDB-with-tens-of-millions-of-data-per-day/?utm_source=dbweekly&utm_medium=email) TiDB Blogstory [What to Expect When You’re Expecting Data: 4 Valuable Lessons Learned](https://dzone.com/articles/what-to-expect-when-youre-expecting-data-4-valuabl?utm_source=dbweekly&utm_medium=email) — Lessons include knowing the importance of driver selection, that query indexing is critical to smooth operations, and that DBaaS is valuable for startups. Steve Pescatoreopinion [5 Reasons to Create a Continuous Delivery Database](https://dzone.com/articles/5-reasons-to-create-the-continuous-delivery-databa?utm_source=dbweekly&utm_medium=email) Robert Reevesopinion Tools and Code [AgensGraph: A Multi-Model Graph Database](http://www.agensgraph.com/?utm_source=dbweekly&utm_medium=email) — A multi-model graph database, built on top of Postgres, for modern complex data environments which supports relational and graph data models at the same time. Bitnine Global, Inc.​ tools [$20 Free Credit on a new account.](https://welcome.linode.com/db-weekly/?utm_source=cooperpress&utm_medium=email&utm_term=db&utm_campaign=db-weekly-sponsored) — Linux cloud hosting starting at 1GB of RAM for $5/mo. Use promo code DB20 for $20 credit linodesponsored [Apache Zeppelin: A Web-Based Notebook for Interactive Data Analytics](https://zeppelin.apache.org/?utm_source=dbweekly&utm_medium=email) Apache Software Foundationtools [PGObserver: A Postgres Monitoring Tool](http://zalando.github.io/PGObserver/?utm_source=dbweekly&utm_medium=email) — An open source tool to help you monitor a Postgres database and get insights on stored procedures, IO stats, index usage, and more. Zalandotools    

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