Issue 157 — June 2, 2017
A Comparison of Advanced, Modern Cloud Databases
— A non-exhaustive primer of modern cloud database solutions like Aurora, Cosmos, and Spanner.
View Counting at Reddit with Cassandra and Redis
— Reddit is so popular that even counting the number of views posts get provides an interesting technical challenge, as explained here.
Monitoring Databases: A Product Comparison
— Percona’s Manjot Singh reviews five of the top database monitoring solutions on the market. Get his breakdown in
Amazon RDS Now Supports Stopping and Starting of DB Instances
— Makes things easier and more affordable in development and test situations.
Amazon Web Services
On Retiring Support for the Query Cache in MySQL 8.0
Tutorials and Stories
How to Build a Non-Volatile Memory DBMS
— Slides, a paper, and a video on building a new DBMS given the changes to hardware landscape due to non-volatile memory.
How Pandora Uses Kafka
— Kafka and related technologies have proven ‘critical to Pandora’s success’ in serving their 80 million active users.
How to Find Redundant Indexes in SQL
When to Use Bind Values, and When to Use Inline Values in SQL
Writing a Firebase Clone with Postgres and Node.js (Part 1)
Getting Started with MySQL High Availability
Veer Abheek Singh Manhas
Hybrid Data Encryption by Example using MySQL Enterprise Edition
Postgres 10's New Features with Examples [PDF]
Breaking the WiredTiger Logjam: The Write-Ahead Log
— Learn how the WiredTiger write-ahead log orchestrates many threads writing to a single buffer without locking.
Migration From MySQL to TiDB to Handle Tens of Millions Rows of Data Per Day
What to Expect When You’re Expecting Data: 4 Valuable Lessons Learned
— Lessons include knowing the importance of driver selection, that query indexing is critical to smooth operations, and that DBaaS is valuable for startups.
5 Reasons to Create a Continuous Delivery Database
Tools and Code
AgensGraph: A Multi-Model Graph Database
— 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
$20 Free Credit on a new account.
— Linux cloud hosting starting at 1GB of RAM for $5/mo. Use promo code DB20 for $20 credit
Apache Zeppelin: A Web-Based Notebook for Interactive Data Analytics
Apache Software Foundation
PGObserver: A Postgres Monitoring Tool
— An open source tool to help you monitor a Postgres database and get insights on stored procedures, IO stats, index usage, and more.