What is our primary use case?
My use case for Cassandra is for a document and other unstructured data management system as well as structured data for ultra-poor member community edition, community members' PII information, so that's a secure database. I understand that, and MongoDB is another environment we have already introduced. I have already informed you since two years ago that it was utilized in our HMPP health data, healthcare data, so there is no issue in that environment. Basically, we are using it in our GCP environment, all environments are on GCP.
What is most valuable?
The functions or features in Cassandra that I have found most valuable are that it is a distributed system similar to Mongo. It's good enough for comparison with another SQL database, so it's smooth and organized for distributed database system.
The peer-to-peer architecture in Cassandra is helpful for network decentralization, and I have already introduced that feature. Cassandra features in peer-to-peer as well as another monitoring, so basically, it's good enough for our service.
The tunable consistency level in Cassandra is good, and we are using that feature already. In terms of built-in caching and lightweight transactions in Cassandra, the transaction level is good, and it's optimized, so there are no more issues in that database.
Based on my experience, Cassandra is good for document management system, as well as distributed database system, and the automatic recovery process is there. Additionally, the database monitoring system or auditing system is well-comparable with other database systems, so we are actually happy to be using this Cassandra database.
What needs improvement?
Regarding areas of improvement for Cassandra, currently, we are not facing significant issues. Some issues arise from our vendors like Apache slowness and distribution or load balancing from HAProxy, which should better handle consumption for high-level concurrency.
I think it would be great to have a better open plugin library, where any kind of Apache could be included in Cassandra database, as well as a built-in Apache library, which would be better for Cassandra optimization or publication.
For how long have I used the solution?
I have been working with Cassandra for more than seven years.
What do I think about the stability of the solution?
I would rate the stability of Cassandra as eight out of ten.
What do I think about the scalability of the solution?
For scalability, my rating for the ability to scale and expand is nine out of ten.
How are customer service and support?
My mark for Apache technical support is seven out of ten.
They should improve response time or quality, which would rate as eight out of ten.
Technical support from the vendor is more than enough, and they are knowledgeable, so I think there is no problem from the vendor side.
How would you rate customer service and support?
How was the initial setup?
The setup process for Cassandra is easy and not complex, not plenty for technical people. As a technical person, I have no issues with it.
What's my experience with pricing, setup cost, and licensing?
The pricing for Cassandra is a little bit high, so it would be better for our community services if they consider community pricing for any non-profit organization like an NGO or other things. It would be better to have enterprise-level features in our community edition, which could support our future development for global community development.
What other advice do I have?
We already used MongoDB and upgraded the version to the latest version on that, and also, we are using Cassandra and another OLTP database like PostgreSQL, MS SQL, SQL Server, and MySQL. Our ERP database is EDB, PostgreSQL database.
We are using a peer-to-peer cluster in Cassandra.
My assessment of multi-data center replication and disaster recovery for Cassandra is that recovery is currently not introduced in our environment, but we hope it would be included in our auto recovery module. Currently, we are recovering the whole VM snapshot in our GCP environment, and that's why we are not taking care of that backup and recovery process. We focus just on the backup process in GCP VM which is snapshot, and it happens every night. It has already happened in the GCP bucket environment as well as in another region, so we're not looking directly for any recovery system. I hope it would be introduced hopefully next year or the following year for the recovery process because we are already introducing it as part of our policy for database backup and recovery process as a DR system. Once that policy is published, we will introduce our recovery system or DR system for every database environment.
Though we are not extensively using Cassandra CQL, some of us are using that one, but we are using a common tool like DBeaver or HeidiSQL. In most cases, we are utilizing that open source or community edition because we are a non-profit organization, so that's why we consider that.
Cassandra is deployed on VM, and that VM is built on our GCP environment, Google Cloud environment.
My comparison of Cassandra with products from other vendors indicates that competitors are basically organizations like BRAC, along with others such as BN and INGO and ASA International, who are using the Cassandra application. I think most of the people are aware that Cassandra is a good distributed database system for transactional use, and it tends to perform better with clustering or replicated database distribution. Most people appreciate that database, so I think it would be better in our Bangladesh market.
I rate this review overall at eight out of ten.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Google