My current experience with databases is mainly with MS SQL, MySQL and oracle. I've been looking around at some of the more scalable alternatives (many NoSQL solutions) when I stumbled upon VoltDB.
It looks quite interesting since it maintains the use of SQL, transactions and ACID. The FAQ on their site seems to suggest that even multi-partition (likely across multiple servers) transactions are fully ACID compliant. However it wasn't explicitly stated and I couldn't find any other sources confirming the fact, so I was wondering if anyone could confirm / deny it.
Yes, VoltDB supports cross-partition transactions with full ACID semantics. Typical workloads are usually a mix of mostly single-partition transactions with a smaller fraction of cross-partition transactions.