December 23rd, 2013

By 

 

“Cassandra was simply the best storage solution for the majority of our data.”

-Paul Sudol, Co-Founder and CTO at Agentis Energy

David Leimbrock

Paul Sudol CTO at Agentis Energy


 
 
 

Today’s Apache Cassandra use case features Paul Sudol with Agentis Energy. To start off, what does Agentis Energy do and what is your role there?

Agentis Energy analyzes energy data for commercial and industrial buildings and businesses. We provide meaningful comparisons for businesses and recommendations about energy saving measures that can be taken at a specific business.  As CTO at Agentis, I am responsible for the long-term development of new technologies.

How are you using Apache Cassandra?

Currently, we’re at 1.2 in our production environment. We use both MySQL and Cassandra. Relational data is easy and convenient to store in MySQL and we use Cassandra to store time-series energy usage data.

What was the motivation for using Cassandra and what other technologies was it evaluated against?

Like most development teams, we began using MySQL. However, we soon realized that as our business grew, we would be getting many billions of records. We needed to make sure this data was backed-up and available to access as quickly as possible.

We started to explore what a MySQL cluster that could handle all that data would look like. At the same time, we researched other possible data store options. We looked at HBase, Dynamo, Mongo and Cassandra. Cassandra was simply the best storage solution for the majority of our data.

Can you share some insight on what your deployment looks like?  

We use two data centers. One datacenter is a major cloud-based provider, which allows us to expand easily both in terms of data storage and processing capability. We are currently storing greater than15 billion records.

What advice do you have for those just getting started with Cassandra?

Jump in! Set up a test environment and experiment. Set up multiple nodes and just test. The community is one of the best parts of Cassandra, so make sure to use all the resources available.

What’s your experience with the Apache Cassandra community?

Very positive. I’ve always been able to find information that I’ve been looking for (once I know what I’m looking for).