top of page
Brian Pace
Oct 25, 20234 min read
Bi-directional Replication: Conflict Resolution
Introduction It will happen. Despite all of the compensating controls, care, and precautions taken, it will happen. At some point in...
64 views0 comments
Brian Pace
Oct 5, 20234 min read
Bi-directional Replication: The Rest of the Story
Introduction Throughout my three decades of experience in dealing with enterprise databases, the concept of bi-directional...
54 views0 comments
Brian Pace
Oct 5, 202312 min read
Recovering Data from a Split-Brain Incident
Introduction The best practice when deploying Patroni alongside PostgreSQL, and potentially for standalone PostgreSQL setups with...
198 views0 comments
Brian Pace
Sep 13, 20236 min read
Bi-directional Replication: Am I in-sync?
Introduction Years of administering databases employing logical replication solutions like Shareplex or GoldenGate have given rise to the...
17 views0 comments
Brian Pace
Sep 13, 20236 min read
Bi-directional Replication: PostgreSQL is ready. Are you?
Introduction Postgres is a robust and popular open-source relational database management system known for its advanced features and...
53 views0 comments
Brian Pace
May 11, 20233 min read
From Code to SQL: Mortgage Amortization Schedule
A recent conversation with a teammate brought me back to my roots as a developer in the mortgage loan industry. Thinking back to some of...
645 views0 comments
Brian Pace
Nov 2, 20223 min read
Database Replication for Postgres/Oracle using Debezium and Kafka
Hands on tutorial of setting up replication between Oracle and Postgres (both directions) using Debezium and Kafka.
97 views0 comments
Brian Pace
Sep 30, 20226 min read
Data Migration with ASM and Storage Snapshots
Overview It is not uncommon for large system migration efforts to use an interim or staging database to perform data transformation...
6 views0 comments
Brian Pace
Sep 30, 20222 min read
Don't Take Grants for Granted
Impact of Direct Grants While monitoring a critical database there was a large concurrency spike that resulted in an application...
10 views0 comments
Brian Pace
Sep 30, 20222 min read
Impact of Block Change Tracking
Overview Enabling block change tracking will improve the performance of incremental backups, but at what cost? It is common to hear...
58 views0 comments
Brian Pace
Sep 30, 20225 min read
A Tale of Disks and Disk Groups
Overview The topic of how many disks, disk allocations, file separation, etc. have been around for years between DBAs, Storage Admins,...
4 views0 comments
Brian Pace
Sep 30, 20228 min read
The Missing Guide for pgBouncer Metrics
Introduction Several pgBouncer metrics are critically important. However, there is often a lack of understanding as to what these...
162 views0 comments
bottom of page