--- title: "Migrating to AWS Aurora with zero downtime" publication: "DB Weekly" issue: 259 published_at: "2019-06-21" canonical_url: "https://dbweekly.com/issues/259" --- This week's database news #259 — June 21, 2019 [Read on the Web](https://dbweekly.com/issues/259) Database Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/ueqppzrncljvnkuxrgwu.jpg)](https://security.googleblog.com/2019/06/helping-organizations-do-more-without-collecting-more-data.html) [Google Releases 'Private Join and Compute' to Improve the Multi-Party Computation Experience](https://security.googleblog.com/2019/06/helping-organizations-do-more-without-collecting-more-data.html) — If two users each have a collection of data, _Private Join and Compute_ provides a way for them to privately compute the sum of associated values for records in common _without_ compromising any of the data. Google [How We Migrated Our Database to Amazon Aurora with Zero Downtime](https://www.revenuecat.com/2019/06/19/aurora-migration-zero-downtime) — The CTO of a SaaS company shares the story of migrating from Amazon RDS to Aurora (Amazon’s higher performance database system that can present itself as Postgres or MySQL compatible). Avoiding downtime was the key and they managed to pull it off. Miguel Carranza (RevenueCat) [An Opinionated Guide for Writing Clean, Maintainable SQL](https://github.com/mattm/sql-style-guide) — Also called _Matt Mazur’s SQL Style Guide_, this is a potentially useful source of strong opinions and best practices on laying out SQL. _(Is it just me who prefers the look of SQL in ALL CAPS though..?)_ Matt Mazur [![\](https://copm.s3.amazonaws.com/75d56081.png)](https://studio3t.com/knowledge-base/articles/import-sql-database-to-mongodb/?utm_source=cooper&utm_medium=newsletter&utm_campaign=june13) [Studio 3T Makes SQL Migration to MongoDB, Powerfully Simple](https://studio3t.com/knowledge-base/articles/import-sql-database-to-mongodb/?utm_source=cooper&utm_medium=newsletter&utm_campaign=june13) — Now you can import an entire SQL database to MongoDB using Studio 3T and its new SQL Migration feature. Studio 3T sponsor [People You May Know: How LinkedIn Can Make Fast Social Recommendations based on Massive Data](https://www.infoq.com/presentations/recommendation-massive-data/) — LinkedIn has a [‘People You May Know’ system](https://engineering.linkedin.com/teams/data/projects/pymk) for connecting people together. This talk digs into the practicalities of how it works at the data level. InfoQ [How Fast Can A Single Instance of Redis Be?](https://docs.keydb.dev/blog/2019/06/17/blog-post/) — The developers of KeyDB, a multi-threaded fork of the Redis data structure store, attempt to demonstrate the performance gains their approach to scaling can deliver. EQ Alpha [Timescale Unveils Timescale Cloud: A Managed Time-Series Database Service](https://blog.timescale.com/timescale-cloud-first-fully-managed-time-series-database-service-runs-on-aws-gcp-azure/) — [TimescaleDB](https://github.com/timescale/timescaledb) is an open source Postgres extension for working with time-series data at scale that’s now also part of the first managed multi-cloud time-series database system. Jeff Sposetti and Ajay Kulkarni [BigCache 2.0: An Efficient Cache for Gigabytes of Data](https://github.com/allegro/bigcache) — A concurrent, evicting in-memory cache built in Go. There’s an HTTP server package available too if you want to make it available as a service. Allegro Tech **IN BRIEF:** - MapR, whose future has recently been in doubt, says it's [close to a deal to sell the company.](https://www.datanami.com/2019/06/18/mapr-says-its-close-to-deal-to-sell-company/) - Fancy a quick look back at the [pre-computer databases](https://hackaday.com/2019/06/18/before-computers-notched-card-databases/) stored on notched cards? - Who doesn't love a big promise? HP is [guaranteeing _100% reliability_](https://www.datanami.com/2019/06/18/hpe-guarantees-100-uptime-with-primera-storage/) on its new high-end storage arrays. 💻 Jobs [Wanted: Curious Developers with ❤️](https://www.keyvalues.com/carbon-five) — Stagnating? Check C5 out: New projects, tech, and challenges perfectly paired with kind and brilliant people in SF, LA, NYC, CHA. Carbon Five [Land a New Dev Job on Vettery](https://www.vettery.com/tech?utm_source=newsletter&utm_medium=cooper-dbweekly&utm_term=tech&utm_content=grouped&utm_campaign=ad-88878) — Vettery specializes in tech roles and is completely free for job seekers. Vettery 📒 Tutorials and Stories [Rethinking the Database Materialized View as an Index](https://blog.timescale.com/rethinking-the-database-materialized-view-as-an-index/) — By utilizing the properties of time-series data, can we make the maintenance of materialized views efficient enough so they act like indexes? Matvey Arye [A Minimalist Guide to Lossless Compression](https://tech.marksblogg.com/minimalist-guide-compression.html) — A brief history of lossless compression followed by a brief look at its use in a Hadoop scenario. Mark Litwintschik [Spin Up a GoCD Continuous Delivery Server in Less Than 5 Minutes](https://www.gocd.org/test-drive-gocd.html?utm_campaign=gocd_test_drive&utm_medium=email&utm_source=cooperpress_db&utm_content=go_website&utm_term=) — Use new GoCD test drive to see how to solve your CI/CD challenges with our first class pipelines, visualizations, and more. GoCD sponsor [Linear Interpolation with SQL](https://bytefish.de/blog/postgresql_interpolation/) — A practical look at what you can do if you have a chronological data set with missing values. How can you find gaps and then how can you attempt to fill those gaps? Philipp Wagner [OLTP vs OLAP: What's The Difference Between Them?](https://www.imaginarycloud.com/blog/oltp-vs-olap/) — If you’ve ever been confused by these terms, this article keeps it simple. Tiago Franco ▶[Bringing Scalable Real-Time Analytics to the Enterprise](https://www.oreilly.com/ideas/bringing-scalable-real-time-analytics-to-the-enterprise) — A 35 minute podcast interview with two guys from [Rockset](https://rockset.com/), a company working on low latency big data analytics. O'Reilly Data Show MongoDB user? 🍃 Check out [our MongoDB newsletter](https://mongodb.email/). A **[Cooperpress](https://cooperpress.com/)** publication. [Change your email address](https://dbweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://dbweekly.com/leave/*|UID|*) © Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom