This has been killing me for weeks - I'm finally breaking down and asking for advice.
I'm currently in the process of setting up database servers for a startup web application. The application manages real-time payments at retailers, so downtime and redundancy are huge factors. I would like to keep an offsite hot backup as well in case we have a region failure.
PCI is also something we are bound to.
Initially, I investigated some MySql solutions such as NDB, Percona Cluster, MMM, and master/slave setups. After a ton of research, I don't think any of these systems could work - simply because of either downtime with failure or the high probability of data corruption.
I've since started looking at databases like mongodb and crunchbase, I feel like I'm just wondering aimlessly looking for a perfect solution, but I doubt I will find one.
I would really appreciate any guidance!