I think you should take a quick look at oracle's exadata machines. Mostly because they are both distributed and ACID compliant.