Erik Brandsberg @@heimdalldata
CTO at Heimdall Data, Inc.
About
Erik Brandsberg is CTO at Heimdall Data. He specializes in application-networking technologies for web and backend data. Whether it's coding, testing or installing, he has been involved. His diverse experience at Alteon, Citrix, and Juniper Networks gave him a solid understanding of operational complexities in a modern infrastructure, which led to the founding of Heimdall Data.
- Connection pooling
- Read/write split with Strong Consistency
- Query caching
- Persisted connection, automated Postgres failove...
- Reduce Postgres resource utilization with with per user and global connection pooling limits.
- Simplify database access management with 1) Active Directory and LDAP and 2) Group extraction for Postgres.
Improve Postgres Scale with Database Proxies
presented by Erik Brandsberg
video
Database proxies intelligently manage Postgres connections to improve performance and scale. In this session, we will highlight deficiencies of Pg-bouncer and Pg-Pool-II that users should know, and propose solutions. Features to be discussed include:
presented by Erik Brandsberg
video
Join us in learning all about Enterprise Connection Pooling and Authentication with Postgres! In this digital breakout session you will learn how to:
Get the most out of your Postgres DB without application changes
presented by Erik Brandsberg
In this session, we will demonstrate how a database proxy can be deployed in minutes to improve read/write transaction/sec (TPS). We will cover typical operations challenges and ways to solve to improve scale with: 1) Query caching, 2) Granular connection pooling, and 3) Read/write split with replication lag detection. No application changes required for deployment.
Technical hands-on demo a...
more Ops and AdministrationHow to scale high Enterprise connection counts for Postgres
presented by Erik Brandsberg
Most Postgres deployments support a limited number of users to the database. Users are typically managed manually by the DBA. In this session, we will explore how database proxies manage users at high scale quickly and easily: We will cover:
Full Authentication/Authorization/Auditing (aka AAA) over database access: - Authentication of the user via Active Directory/LDAP - Group extraction a...
more Ops and AdministrationHow database proxies optimize query read/write performance with no code changes
presented by Erik Brandsberg and Zack Odom
Learn the various techniques on how Heimdall's Database Proxy improved throughput and performance:
1) Batch DML operations: intelligently process singleton operations as micro-batches. 2) Intelligently route diverse workloads (i.e. OLTP, OLAP) to Postgres, utilizing Postgres's latest features, such as materialized views for analytic purposes. 3) Auto-caches into GemFire or other cache eng...
more Wed 20 2019 DataPGPool replacement and Auto-caching without the programming
presented by Erik Brandsberg
Implementing Postgres failover and caching requires development work and adds risk. What if there was a solution that removes these complexities?
In this session, we will demonstrate how Heimdall Data is deployed in minutes as a PgPool-II replacement and supports automated, distributed caching for improved performance.
Heimdall Data intelligently caches, invalidates and synchronizes ac...
more devpresented by Erik Brandsberg
Join Heimdall Data for a Workshop on Automatic Failover and Caching for PostgreSQL.
Operations and AdministrationImprove application performance and reliability in minutes without the development work
presented by Erik Brandsberg
In this session, we will demonstrate how to implement failover (like PGPool-II) in minutes while adding automated caching for improved performance. Additional topics include monitoring, analyzing query performance, and read/write split to leverage read-only servers. Supported databases include open source Postgres, Greenplum, AWS Aurora for Postgres, and others, without change...
more Wed 18 2018 Operations and Administration