How would you guarantee the success of the transaction? If it fails as a result of a
hardware failure, then ultimately, the system as a whole has suffered a hardware
failure. If it fails for any other reason, then it's an issue with software or bad
data. Once those things are figured out, you
Has anyone architected an oltp database using mysql where downtime is
virtually eliminated? I understand it's fairly simple to set up a readonly system
using mysql replication or another type of replication to maintain the
uptime, but I have yet to see how to do this with a heavy transaction
The thing is I'm looking for a solution with guaranteed transaction success. I have
thought about building a layer that would guarantee transaction success. Say I had
two duplicate databases and if a transaction failed on one it would still succeed
on the other. Once the transaction failed it