What is our primary use case?
My main use case for DataStax Enterprise involves supporting a bank, one of the leading banks in the North American region, which at one point had around 1800 plus Cassandra clusters, all of them quite large. They asked us to perform a version upgrade from a very old version of DataStax to a modern version, 6.X at that time, and we used ZDM and CDM as a zero downtime migration strategy for continuous data migration.
A particular challenge we faced with DataStax Enterprise in that bank project was that the previous version was experiencing performance issues due to the legacy systems being old. Many performance improvements and security vulnerability fixes were added in the latest version of DataStax Enterprise Cassandra. The team was experiencing slowness and performance problems, and during an audit, security issues were identified. Another driving factor for our migration was that the previous DataStax Enterprise version was out of support, which motivated the upgrade of those thousand plus database clusters.
The main challenge with the migration was the nature of the banking and insurance field, as their databases were quite active, limiting downtime to hardly 15 minutes a month. Achieving a complete zero downtime migration for those systems was not easy. However, after collaborating with DataStax engineers and utilizing their premier support, we achieved a near zero downtime migration strategy that met the client's downtime expectations. Despite some initial difficulties, the support from DataStax helped us overcome challenges with ZDM and CDM.
What is most valuable?
Some of the best features that DataStax Enterprise offers are performance improvements, as new features were added compared to the previous legacy system using version 5.X and the target we migrated to was 6.8. This migration helped stabilize performance issues and introduced new tracing facilities and optimizer level changes.
Although it has been some time since we delivered the bank project, the new tracing facilities and optimizer changes in DataStax Enterprise were very useful in identifying slowness in critical SQL statements. This helped us understand issues that were difficult to diagnose in earlier versions.
I am a fan of distributed systems, especially DataStax Cassandra, because of its distributed architecture and ability to scale horizontally while maintaining availability. I experienced this while working on a project for a telecom company. We had a testing scenario to achieve high IOPS requirements for a government bank in Sweden, where the database layer was replaced with DataStax Enterprise Cassandra due to its ability to handle write operations quickly, allowing us to deliver the project on time.
One of the big strengths of DataStax Enterprise for my organization is its multi-data center availability, which allows applications to operate across locations and tolerate infrastructure failures. With the correct replication factor defined for key spaces, even if nodes go down, all read and write operations go smoothly, supported by a strong backend team for immediate replacements.
The positive impact of DataStax Enterprise on my organization is reflected in specific outcomes, such as improved performance. Post-migration, certain critical queries were observed to be 20 percent faster than previous runtimes, significantly enhancing cost efficiency and reducing the impact of performance problems on critical workloads.
What needs improvement?
In terms of improvements for DataStax Enterprise, I would highlight a comparison with other NoSQL databases, particularly MongoDB, which can be easier initially for developers due to its flexible document model. DataStax Enterprise requires more discipline around data modeling but excels in predictable large-scale distributed workloads.
I believe DataStax Enterprise could be easier in areas such as operational complexity, especially for those coming from a traditional relational database background. There is a learning curve involving consistency levels, token ranges, and distributed system behaviors that could benefit from more automation and intelligent diagnostics.
For how long have I used the solution?
I have a total of six years of experience working with all different versions of DataStax Enterprise.
What do I think about the stability of the solution?
DataStax Enterprise is stable in my experience.
What do I think about the scalability of the solution?
The scalability of DataStax Enterprise is amazing, as it allows for horizontal scaling while maintaining availability, which is one of its best features.
How are customer service and support?
The customer support for DataStax Enterprise is amazing. Any requests I have raised receive prompt responses, often within minutes, and the support engineers are knowledgeable and helpful.
How was the initial setup?
We realized significant cost savings after migrating to DataStax Enterprise, as the previously slow critical queries now run significantly faster, improving efficiency and performance metrics across the board.
What about the implementation team?
We conducted a proof of concept between Cassandra and ScyllaDB before standardizing on DataStax Enterprise.
What was our ROI?
We realized significant cost savings after migrating to DataStax Enterprise, as the previously slow critical queries now run significantly faster, improving efficiency and performance metrics across the board.
What's my experience with pricing, setup cost, and licensing?
I was not involved in the licensing for DataStax Enterprise, which is managed by a different team, but I understand it operates on a core-based licensing model, which is standard. The licensing team handles renewals, and while I do not have direct experience with it, it seems to function regularly.
Which other solutions did I evaluate?
We conducted a proof of concept between Cassandra and ScyllaDB before standardizing on DataStax Enterprise.
What other advice do I have?
I advise those looking into DataStax Enterprise to stop comparing relational systems with distributed NoSQL systems, as they are designed to solve different problems. Understanding the use case is vital for making informed decisions regarding database choices.
DataStax Enterprise is deployed in a hybrid cloud environment in my organization, utilizing Azure and GCP. I most often use Azure with DataStax Enterprise.
I would rate this product 9.5 out of 10.
Which deployment model are you using for this solution?
Hybrid Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Microsoft Azure