As of today AWS RDS for PostgreSQL1 does not offer cross-region replication. Short of switching to one of the RDS offerings that do support it, there is a few options to consider.
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
While I have long moved on from PostgreSQL, I continue to follow its development. I am glad to see Citus grow from a small startup with growing pains into an important part of Microsoft.
On May 10 Salesforce experienced a day long outage and lost four hours of customer data. As of May 14, Salesforce is still in degraded state. There is a number of lessons we can learn from this.
NoSQL databases scale by adding more commodity servers. With more commodity servers come increased costs and complexities. Some NoSQL systems are better at this than others and need less.
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
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
Here is a wednesday funny for you: Two developers decide to take a class to improve their skills. One takes a day-long class on “Building scalable web applications with MongoDB.” The other one takes a class on “Basket Weaving.” Next day they compare their notes. One of them is an expert basket weaver, the other … Continue reading Two developers choose to take a class
After using Cassandra for 3 years since version 0.8.5, I thought I’d put together a blurb on lessons learned. Here it goes! Use Cases What works Anything that involves high speed collection of data for analysis in the background or via batch. For example: Logging and data collection Web servers Mobile devices Internet of things … Continue reading Cassandra: Lessons Learned