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 … Continue reading Configuring Master-Slave Replication With PostgreSQL

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 … 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 … Continue reading Ordered Sets and Logs in Cassandra vs SQL