I need to choose a solution for a small, i.e., 2 tables/entities, in total max 100,000 rows (~ 20 MB of data) with HA having data distributed among multiple nodes. HA with no single point of failure is a must. I am considering Cassandra for the task. However, I feel that Cassandra might be an overkill for such a volume of data. Is there any lighter alternatives for this task that could provide HA with multi master replication capacity.
Solution for a small DB with high availability, no single point of failure
449 Views Asked by nad2000 At
1
There are 1 best solutions below
Related Questions in DATABASE
- How to add the dynamic new rows from my registration form in my database?
- How to store a date/time in sqlite (or something similar to a date)
- Problem with add new attribute in table with BOTO3 on python
- When an E-R attribute should be perceived as a relationship attribute or as an entity set attribute?
- SQLAlchemy: efficient relationship loading in 3-way many-to-many relationship
- Cannot connect to Postgres Database when running Quarkus Tests with Gitlab ci
- Local or remote database with react-native?
- I want to edit a specific row in database
- How to enter data in mongodb array at specific position such that if there is only 2 data in array and I want to insert at 5, then rest data is null
- Open Web Library
- database login.py and register.py error showing 404 file not found and doesn't work
- SQL71561: SqlComputedColumn: When column selected
- Liquibase as SaaS To Configure Multiple Database as Dynamic
- Updated max input vars but table still shows error
- Spring does not map set of roles
Related Questions in CASSANDRA
- how to create a chess board with Queen in the central position and all its moves in assembler code
- Passing arguments to ENTRYPOINT causes the container to start and run indefinitely
- Apache Cassandra Node Driver Connection
- Simulate Cassandra DB timeout
- How to update Cassandra Lucene index with a new column? rebuild or update index?
- Cassandra JDBC connection string for logstash
- Cassandra OversizedMessageException
- dsbulk unload is failing after ran couple of hours with OOM issue
- Cassandra: "Model keyspace not set" and "Connection name doesn't exist in the registry" Errors
- Unable to cqlsh to a cassandra docker container remotely
- Forward pagination with object mapper in java asyn
- Allow filter in cassandra query
- How to fix bytes unrepaired in cassandra
- Can't install Cassandra using RPM packages for RHEL 9
- Why can't get a connection to Cassandra running on Docker from a Spring Boot instace using spring-boot-starter-data-cassandra on first boot?
Related Questions in CASSANDRA-2.0
- Cassandra Live Migration from onpremises to the Compute Engine / VM
- am unable to to the database using cqlsh
- Janusgraph replication-factor not propogated to cassandra
- How to take backup and Restore huge Cassandra Database tables?
- Unable to start kong gateway with custom plugin
- Using batch queries in typescript with cassandra , inserting only one row in table in Nodejs
- NoSuchMethodError: org.apache.cassandra.db.ColumnFamilyStore.getOverlappingSSTables
- Bad Request: line 1:0 no viable alternative at input 'clear'
- Getting rpc_timeout when counting data in Cassandra
- In Scylla DB, How can I query the records for multiple condition and without mentioning ALLOW FILTERING?
- ConnectionRefusedError No connection could be made because the target machine actively refused it cassandra
- Cassandra copy n rows from one table and insert them to another table
- In Scylla DB, How can I query the records in desc order?
- Clarification about Cassandra tombstones and manual compaction
- How do I extract the Cassandra table data into json file using python or directly through cqlsh?
Related Questions in HIGH-AVAILABILITY
- How to configure in build keepalived of opensips?
- Assigning a dedicated Primary node for write operations in MongoDB replica set
- PostgreSQL high availability setup along with Read-Replica's
- Flink high-availaility in standalone cluster, kill the jobmanager process. But the jobmanager can not recover later
- How to use pacemaker to use Virtual/Floating IP address?
- ActiveMQ Artemis HA split-brain issue on OOME crash
- Kafka mirror maker: Data in some topics are not replicated
- Difference between Edge and HA clusters artifactory
- Do we need to share /var/lib/nfs for NFSv4 recovery process?
- MQTT on Raspberry Pi 3B+ (Raspbian) not working anymore
- Issue encountered while adding a script for REPMGR split-brain prevention
- What is use case where we can see the benefit out of having witness node in the PG cluster
- Do we need a load balancer while we have multiple master nodes?
- Why the values from Hadoop API doesn't match with the calculated values?
- How can I manage DB switchover for write queries?
Related Questions in MULTI-MASTER-REPLICATION
- cockroachdb data not replicating
- Postgres 15 Multi-Master Replication
- Serverless PostgreSQL replication
- Rails' DelayedJob for a multi-master setup
- PostgreSQL multi-master replication between AWS RDS and GCP Cloud SQL
- MySQL slave replication not writing binlog file
- ldap_sasl_bind_s failed (-1)
- Can we create a SQL Server RDS in AWS Active/Active?
- Node3 is not getting involved in mutli-master-replication of 3nodes using symmetric-ds 3.10.0
- How to effectively use Galera Load Balancer with JDBC URL?
- Is there any trustable enterprise grade master to master (bi directional) replication option available in PostgreSQL
- Debezium for large multi master replication?
- AWS RDS multi master writes in multiple regions
- Mysql ID Duplication issue in Replication
- reading from config file in a sql script
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
I'd consider Cassandra a reasonable candidate for what you are trying to do. Replication and high availability is an out of the box feature for Cassandra where other database solutions tend to 'tack on' HA. Cassandra is also not too heavy duty and can run on small servers pretty dependably (see CassandraHardware)
On the other hand if you have not used Cassandra before you will have to do some learning to understand conceptually how replication, consistency and availability work in Cassandra, which may take some time if you are more familiar with these concepts in other database solutions.
With 20MB of data, it looks like Redis Sentinel could do the trick as well.