When working with clients on database migration, there are a range of options we help them assess and evaluate. These include: Bare Metal Solution (BMS) PostgreSQL On Cloud SQL On GCE (Google Compute Engine) Cloud Spanner Some organizations choose BMS…
Read More >In these challenging and ever-changing times, most organizations would welcome the opportunity to reduce overhead, drive innovation and become more agile. While all these benefits are possible with a move to the cloud, many organizations are overwhelmed at the thought…
Read More >When I first heard of Postgres partial indexes, I knew immediately that this would have solved a problem I had in MySQL about a decade ago. That problem didn’t go unsolved, but it certainly wasn’t as easy as I’ll demonstrate…
Read More >There were some security patches released this month for Postgres, to put further restrictions on pathways that malicious users could use to leverage the search_path to insert malicious code. What is the search path? What is search_path? Postgres has a…
Read More >Covering indexes in Postgres came up in our weekly tech call because of a query optimization review one of the teams has in progress. It seemed like some covering indexes weren’t working. I’ve been reading a book called Curious Moon,…
Read More >There are at least four ways to back up a Postgres database: SQL dump, filesystem snapshots, continuous archiving, and third-party tools. For each, notes on the recovery point objective (or RPO, which is a measure of how up-to-date your application…
Read More >I recently did an upgrade of 200+ nodes of Cassandra across multiple environments sitting behind multiple applications using the cstar tool. We chose the cstar tool because, out of all automation options, it has topology awareness specifically to Cassandra. Here…
Read More >Spark Overview Spark was created in 2009 as a response to difficulties with map-reduce in Hadoop, particularly in supporting machine learning and other interactive data analysis. Spark simplifies the processing and analysis of data, reducing the number of steps and…
Read More >This weekend, I gave an orientation to Docker for a developer friend of mine who works in an enterprise environment and was preparing to take on new development projects using Docker. I have given several Docker 101 workshops, but it’s…
Read More >Overview of Cassandra As previously mentioned in my notes on lightweight transactions, Cassandra does not support ACID transactions. Cassandra was built to support a brisk ingest of writes while being distributed for availability. Follow the link to my previous post…
Read More >