Skip To Main Content
Barry Ooi on Muck Rack

Barry Ooi

As seen in: Amazon Web Services, BFM :: Live & Learn
Is this you? As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work. Claim your profile

Get in touch with Barry

Contact Barry, search articles and posts on X, monitor coverage, and track replies from one place.

Learn more about Muck Rack

Actions

Share this page

Is this you?

As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.
Claim your profile

Articles

Resolving PostgreSQL replication lag with heartbeat tables in change data capture scenarios

|
By Donghua Luo, Barry Ooi
| Amazon Web Services
In this post, you will learn how to resolve PostgreSQL replication lag using heartbeat tables during database migrations that rely on change data capture (CDC) to keep the source and target in sync until cutover. We will cover the root cause of replication slot stalls, how heartbeat tables prevent WAL accumulation, and how to implement them using AWS Database Migration Service (AWS DMS) or Debezium. Replication lag during a CDC-based migration can be counterintuitive.
Open in Who Shared Issue with article?

Converting an RDS for SQL Server instance from license included to Bring Your Own Media (BYOM)

|
By Mesgana Gormley, Barry Ooi, Sudhir Amin
| Amazon Web Services
AWS Database Blog Amazon Relational Database Service (Amazon RDS) for SQL Server recently launched Bring Your Own Media (BYOM), so you can use your existing SQL Server licenses with fully managed RDS instances (see Unlock license mobility with Bring Your Own Media on fully managed Amazon RDS for SQL Server). This is particularly valuable if you have existing Microsoft licensing agreements and want to optimize your cloud spending by using those investments on AWS.
Open in Who Shared Issue with article?

Configure Optimize CPU on Amazon RDS for SQL Server | Amazon Web Services

|
By Barry Ooi, Sudarshan Roy
| Amazon Web Services
Amazon Relational Database Service (Amazon RDS) for SQL Server now offers the Optimize CPU feature, which enabled control over vCPU allocation through core count modification setting. SQL Server licensing costs can consume a significant portion of your database budget, especially when you’re paying for vCPUs that aren’t fully utilized.
Open in Who Shared Issue with article?
See all 16 articles