Ten Questions to Consider Before Choosing Cassandra

  1. Do you know what your queries will look like ? In traditional SQL you design your data model to represent your business objects. Your queries can then evolve over time and can be ad-hoc. You can even create views, materialized or otherwise, to facilitate even more complex analytical queries. Cassandra does not offer the flexibility of traditional SQL. While your data model can … Continue reading Ten Questions to Consider Before Choosing Cassandra

Ordered Sets and Logs in Cassandra vs SQL

I’ve written before that Cassandra’s achilles’ heel is devops: Storage, redundancy and performance are expanded by adding more nodes. This can happen during normal business hours as long as consistency parameters are met. Same applies to node replacements. As the number of servers grows be prepared to hire a devops army or look for a managed solution. Datastax offering helps but still not enough. Even … Continue reading Ordered Sets and Logs in Cassandra vs SQL

Configuring Master-Slave Replication With PostgreSQL

Having configured PostgreSQL 9.3 master/slave replication from bits and pieces of documentation on the Internet, I feel like a post is in order documenting my experience for others. Installing PostgreSQL I am not going to get into too much detail here. Installation instructions are abundant and are slightly different by operating system. I am assuming you are already past this stage. Prepare Master Before we … Continue reading Configuring Master-Slave Replication With PostgreSQL