Codeless SQL Caching: 5x Performance Gain from 5-Minutes of Integration

Erik Brandsberg, Chief Technical Officer, Heimdall Data

Tue. Mar. 27, 2018 6:30pm
New York City
Free fun drinks, swag, junk food, plus win a JBL Flip 4!

Erik Brandsberg

Chief Technical Officer, Heimdall Data

Codeless SQL Caching: 5x Performance Gain from 5-Minutes of Integration

David Wheeler once said that 'All problems in computer science can be solved by another level of indirection' but how do you leverage this for databases?

In this session, Erik Brandsberg, CTO of Heimdall Data, will provide an overview of how to implement a transparent indirection layer between the application and database to provide users with:

  • Query result caching with automatic invalidation to improve scale and performance
  • Load balancing of read/write splits to better leverage resources
  • Transparent failover for zero-downtime operations
  • Auto-caching logic for grid caching with Redis, Amazon Elasticache, Hazelcast & Pivotal Gemfire
  • Analytics that identify poorly performing queries, along with automatic query plan extraction
  • Security to lock-down databases against zero-day SQL injection attacks

The presentation will include live demos on various unmodified third-party applications.

These techniques were designed for Postgres, MySQL, MS SQL Server and any JDBC-based database.

Erik Brandsberg

Chief Technical Officer,
Heimdall Data

Erik Brandsberg is CTO and Architect of Heimdall Data. He specializes in application-networking technologies for web and backend data. Erik's diverse experience at Alteon, Citrix and Juniper Networks have given him a solid understanding of operational complexities in a modern infrastructure, which has subsequently led to the founding of Heimdall Data.

  • All
  • Images
  • Videos