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
448 Views Asked by nad2000 At
1
There are 1 best solutions below
Related Questions in DATABASE
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- How to not load all database records in my TListbox in Firemonkey Delphi XE8
- microsoft odbc driver manager data source name not found and no default driver specified
- Cloud Connection with Java Window application
- Automatic background scan if user edit column?
- Jmeter JDBC Connection Configuration Parametrization of Database URL for accessing SQL Database
- How to grant privileges to current user
- MySQL: Insert a new row at a specific primary key, or alternately, bump all subsequent rows down?
- Inserting and returning autoidentity in SQLite3
- Architecture: Multiple Mongo databases+connections vs multiple collections with Express
- SQL - Adding a flag based on results within a query - best practice?
- Android database query not returning any results
- Developing a search and tag heavy website
- Oracle stored procedure wrapping compile error with inline comments
- Problems communicating with mysql in php
Related Questions in CASSANDRA
- How to perform ordering in cassandra
- Kong: Running Mashape Kong fails on Mac OS X
- Cassandra spark connector data loss
- How to insert a custom type with map<text, boolean> field using cqlsh in Cassandra?
- How to setup cassandra and spark
- Error running spark app using spark-cassandra connector
- Where are the API docs for org.apache.spark.sql.cassandra for Spark 1.3.x?
- java.sql.SQLSyntaxErrorException: name provided was not in the list of valid column labels:
- Cassandra query on 2 dates
- Cassandra WordCount Hadoop
- Cassandra: range select with incorrect result
- How to export data from Cassandra to mongodb?
- Spark Cassandra SQL can't perform DataFrame methods on query results
- Why is my cassandra insert rate better with a client/node in the same host than with client and one node in separate hosts?
- Does Cassandra support aggregation function or any other capabilities like Map Reduce?
Related Questions in CASSANDRA-2.0
- Why is my cassandra insert rate better with a client/node in the same host than with client and one node in separate hosts?
- Apache Cassandra 2.1.6 Not Binding to port 9042
- how many partition key for a Cassandra table?
- How to delete a record in Cassandra?
- How exactly batch work in cql
- Cassandra inconsistencies in batch inserts/updates
- Cassandra requires restart when ALTER TABLE ADD COLUMN to table with existing data records
- Granularity level in clustering key( high unique values)
- Web analytics customer segmentation data modeling with Cassandra?
- No viable alternative at input '>' in cassandra
- Facing issue while adding a node in the existing cluster(data center) in Cassandra
- Exception in thread "main" com.datastax.driver.core.exceptions.InvalidQueryException: Unknown definition referenced in PRIMARY KEY
- Cassandra Bulk Loader
- Set Cassandra's replication factor in cassandra.yaml
- Selenium web driver with Cassandra service
Related Questions in HIGH-AVAILABILITY
- Google Cloud Bigtable Durability/Availability Guarantees
- Hive with Hadoop high availability
- Can't start Neo4j cluster -- Write transactions to database disabled
- HACluster Config for Stardog
- High Availability with hot-standby and auto-failover in postgresql
- Nagios monitoring for Exchange highavailability [Failover]
- Neo4j v2.2.3 Embedded HA: can't create cluster
- Can elasticsearch instances with different settings join the same cluster?
- High Availability Websockets Server
- Website/webserver fault tolerance - the best practices
- HaProxy - group tcp and http hosts dependent of each other
- Jenkins master failover scenario
- spring-xd job repository datasource enable oracle fast connection failover
- auth in kibana cluster
- Hadoop Ha namenode java client
Related Questions in MULTI-MASTER-REPLICATION
- pt-table-sync unable to modify binlog_format
- Using Redis Replication on different machines (multi master)
- MySQL Multi-Master Replication multi location
- ADD_MASTER_DATABASE procedure changes tns login username
- Can I use codeigniter session_id to SmartScale sessionid in Tungsten Replicator for MySQL?
- MySQL multi-muster replication
- Connect to a MySQL master-master setup from code
- PostgreSQL BDR issues with replication slots
- AWS RDS multi master writes in multiple regions
- MariaDB 10 Galera Cluster or Downgrade?
- Postgres 15 Multi-Master Replication
- Which replication mechanism to chose in distributed system?
- How to update all primary keys in the existing database
- MySQL Master-Master replication error 1062
- Questions About Load Balancing ProstgreSQL 9.6
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 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.