Trying to manually shard an RDBMS or scale out a NoSQL DB is so last year. There is a better way.
At Oracle, we used the following recipe to create the world's fastest OLTP DB:
- Use the lowest latency SQL RDBMS as a building block (TimesTen In-Memory Database)
- Use many instances of TimesTen in a scale out, shared nothing architecture
- Enhance the TimesTen SQL so that the applications see a single database image
- Enable high availability via K-Safety
- Use ACID transactions so that your data is always consistent
- Enable centralized monitoring and management to make devops life simpler
- Enable existing applications to work without re-writing (keep your schemas, PK, FK, SQL and SQL APIs)
- Give it a cool name (Velocity Scale)
The result looks like this:
Come to Oracle Open World 2017 to find out all of the details.
Disclaimer: these are my personal thoughts and do not represent Oracle's official viewpoint in any way, shape, or form.