Скачать или смотреть Scaling databases with a database access layer

When an application goes viral, it not an easy feet to scale the infrastructure to support it. It requires some crafty deployments, constant improvement in the application stack and a lot of automation in the infrastructure to serve the growing business.

For the past couple of years, Gaurav Gupta has been looking at the problem of scaling the database tier efficiently. Database (especially relational database) remains an interesting frontier to scale up in the multi-tier architecture. NoSQL offers promise of scale for certain use cases, but there a large ecosystem for SQL that remains and will continue to grow. Gaurav proposes a database abstraction layer that offers great potential to scale, optimize, perform and manage the traditional database tier. This layer will virtualize the databases from applications and provides a single interface to DBAs, DevOps and Developers to manage, test and develop their database tier.

In this talk, Gaurav talks about certain common optimization techniques that can be offered from this layer:

1). Instant scale up - transparent connection pooling and multiplexing, transparent caching, surge protection.
2). Transparent scale out - read/write split, load balancing, query routing, Sharding.
3). Automatic high availability - automatic failover
Real-time Analytics.