Author: Valerie Parham-Thompson

Migrating Oracle Workloads to Google Cloud – PostgreSQL on Cloud SQL or GCE

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 >

Migrating Oracle Workloads to Google Cloud – BMS

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 >

Postgres partial indexes on email address domains

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 >

Postgres Security Patches Related to the Search Path

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 >

Postgres Covering Indexes and the Visibility Map

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 >

PostgreSQL Backups

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 >

Upgrading a Large Cassandra Cluster with cstar

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 + Cassandra Best Practices

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 >

Docker Orientation

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 >

Handling a Cassandra transactional workload

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 >
Page 1 of 3123