Yes, I understand completely. Unfortunately there is no simple or inexpensive way for you to achieve what you want.
It can be done. It has been done. But it requires a lot of extra software, and synchronising MySQL databases is a pain, and it is expensive.
There is a new option from Parallels that you might want to look at and which would allow you to do what you want, but it requires three servers and it is not inexpensive. Take a look at Parallels Cloud Server 6 (PCS6) and Parallels Cloud Storage. With this combination, and using three servers, if one goes down your users may not even notice a problem, because the technology replicates all data in such a way as to allow one server to go down completely and handles everything automatically.
Otherwise, look at the problem from a different direction: What is likely to go wrong with a server? Most often it is the disk or the power supply. If you use mirrored disks (via hardware RAID or even software if you have to), if one disk goes bad there won't be a problem. You can get servers with dual redundant power supplies, but another option is simply to have a spare available on-site. And if something else blows (e.g. disk controller, motherboard) then quick hardware replacement is a great option - once the hardware has been replaced, you just put the original disk(s) back in and you are up and running again very quickly.
You should still back up, and ideally backup off-site as well as on-site.
There are sooooo many options, from cheap to horrificly expensive. Try talking to the people at your data centre -- they are likely to be able to offer you a CDP solution, or maybe something else, but it won't be cheap.