About
Roland Lee's background is in application networking. He has been a developer and product manager in startups and large companies. All through his career, his industry focus has been to increase the performance of Internet user data. He is currently Head of Products for Heimdall Data, an off-the-shelf data access layer for applications accessing SQL databases.
Lee Roland has presented the following presentations
3 Techniques to Improve Postgres Response Times without Code Changes
at
Silicon Valley 2023
Improve Performance via SQL Offload
presented by Lee Roland
In this session, we will discuss ways to offload SQL for low latency; all without code changes. We will discuss how database proxies (commercial and open-source) can intelligently cache, split and route queries for optimal Postgres performance and scale. During the presentation, it will be an interactive discussion with Q&A. Come join us.
Thu 20 2023 Dev
Scaling Beyond PgBouncer & Pgpool-II: Advanced Traffic Management
at
Silicon Valley 2022
Survey of Database Proxies
presented by Lee Roland
Database proxies manage connections to improve performance and scale. In this session, we will highlight deficiencies of open-source Pg-bouncer and Pg-Pool-II that users should know, and propose solutions. Features to be discussed include:
- Connection pooling
- Read/write split with Strong Consistency
- Query caching
- Persisted connection, automated Postgres failover...
Read/Write split and Replication lag detection made easy with a database proxy
presented by Lee Roland
Horizontally scaling your SQL database involves separating the write-master from read-only servers. However, writing to one node and reading from another can result in inconsistent data due to synchronization delays.
Database proxies intelligently route SQL queries to the best data source for even load distribution, while guaranteeing consistency.
In this session, we will provide a hands...
more Ops and Administration
How the Heimdall Proxy Improved SQL Scale for the World's #1 Coffee Retailer
at
Silicon Valley 2019
Query Caching and Read/Write splitting without code change
presented by Lee Roland
In this session, we will go over a customer use case of how the Heimdall Database Proxy offloaded and improved database scale for one of the world's largest coffee retailer. We will discuss features and solutions used to diagnose and cure bottlenecks. As the backend infrastructure has been the culprit of many application performance issues, Database Proxies in the market can save development an...
more Thu 19 2019 Case Studies
Improve Database Warehouse Performance 100x with a Database Proxy
at
Silicon Valley
Increase Amazon Redshift and Pivotal Greenplum Concurrency
presented by Lee Roland
Data Analytics/Warehouse solutions are often challenged with slow application response times caused by 1) High latency and 2) Frequent queries to the backend.
Heimdall Data is a Database Proxy that leverages Postgres for query optimization to improve the performance of Data Warehouse solutions (e.g. Amazon Redshift, Pivotal Greenplum). Techniques include batch processing and materialized vi...
more Mon 15 2018 Ops