CODEWITHSUNDEEP
nosql
Anas Rabei
Anas Rabei

Reputation: 317

no single point of failure with traditional RDBMS

I am working in a trading applications that depends on an Oracle DB.

The DB is crashed two times and the business owner wants some solution in which the application still works even the DB is crashed.

My team leader introduced Cassandra NOSQL as a solution as it has no single point of failure but this option will make us move from the traditional relational model into the NOSQL model which I consider as a drawback.

My question here, Is there a way to avoid a single point of DB failure with traditional relational DBMS like Mysql, postgreSQL,......etc ?

Upvotes: 0

Views: 1285

Answers (3)

Scott Presnell
Scott Presnell

Reputation: 1538

NoSQL isn't the only possible solution. You can set up replication with MySQL:

http://dev.mysql.com/doc/refman/5.0/en/replication-solutions.html

and

 http://mysql-mmm.org/

and concerming failover discussions:

http://serverfault.com/questions/274094/automated-failover-strategy-for-master-slave-mysql-replication-why-would-this

Upvotes: 0

oleksii
oleksii

Reputation: 35905

Is there a way to avoid a single point of DB failure with traditional relational DBMS

No, that's not possible. Simply because when one node dies. It is gone.

Any fault-tolerant system will use several nodes that replicate each other. You can still use traditional RDBMS, but you will need to configure mirroring in order for the system to tolerate a node failure.

Upvotes: 1

matt b
matt b

Reputation: 139931

Sounds like you just need a cluster of Oracle database instances, rather than just a single instance, such as Oracle RAC.

If your solution for the Oracle server being offline is to use Cassandra, what happens if the Cassandra cluster goes down? And are you really in the situation where it makes sense to rewrite and re-architect your entire application to use a different type of data store, just to avoid downtime from Oracle? I would suspect this only makes sense for applications with huge usage and load numbers, where any downtime is going to cost serious money (and not just cause embarrassment to the business folks to their bosses).

Upvotes: 1

Related Questions