Beyond PostgreSQL: Distributed SQL with YugabyteDB
Postgres is a widely used open source database for OLTP with powerful SQL features that are continually improving. However, it faces operational challenges such as process per connection, vacuum issues, resilience to failure, and downtime for upgrades. These issues require a different storage architecture. Distributed SQL, inspired by Spanner, addresses some of these issues but often has limited SQL support. It is also essential to remain Open Source when offering an alternative to PostgreSQL
YugabyteDB overcomes these limitations by utilizing PostgreSQL code for SQL processing on multiple active nodes and employing distributed transactional storage to scale horizontally. This marks the evolution of databases towards Distributed SQL databases. We will demonstrate YugabyteDB's resilience and scalability.