In my previous story about Amazon, I talked about a problem with an Oracle database.
You know, eight years later, I still don't see what I really want from a database. Hot standbys and replication remain the state of the art.
What I want is a robust, high performance virtual relational database that runs transparently over a cluster, nodes dropping in an out of service at will, read-write replication and data migration all done automatically.
I want to be able to install a database on a server cloud and use it like it was all running on one machine.
Yes, I realize how hard this is to engineer, especially if you deal well with nasty issues like intermittent slowness or failures of nodes, major data inconsistencies after a network partition of the cluster, or real-time performance optimization based on access patterns.
I still want it. And I'm not the only one.
See also my previous posts, "Google's BigTable" and "Clustered databases".