Always i was using MySQL or PostgreSQL for my projects such as Web/Desktop apps. I had data loss few times and thanks to old backup i was always up and running.
But for a recent project for Airport, i have to use something which never ever can lose its data at-least not database until it has power in the circuit..
So i am thinking DB2 should be the best for such risk less missions? Any idea or hints.
Thanks in advance.
All of the platforms you have mentioned can run close to zero data loss configurations. All of them could be deployed in a configuration that will fail.
Platform choice is one part of the puzzle. It will be your implementation of the platform that determines whether or not your requirements are met.
In reality, high availability and disaster recovery are a trade off between uptime, Recovery Point Objective, Recovery Time Objective and cost.
Zero data loss and zero downtime is expensive, complicated to setup and complicated to maintain. There is no free lunch.
I would just add that since the question was answered, Postgres-XC has been released. It is basically an open source fork of Postgres which allows for Teradata-style clustering which offers both high availability and write extensibility. I would expect this to be the preferred approach in very high-reliability, high throughput environments.
