Mind the Gap
Challenges with the Transactional Outbox Pattern
A tale of caution when implementing the Transactional Outbox Pattern in a sharded MySQL setup.
DorkusMalorkus
A blog about programming, UNIX tools, databases, memes and more.
- 5 posts
- latest
- Stack: Java, Ruby, Python, SQL
- Topics: databases, event-driven-architecture, transactional-outbox-pattern, performance
recent posts
-
-
Goin' Postal
A tiny introduction to the Transactional Outbox Pattern
Increase resiliency and consistency in your event driven architecture with the Transactional Outbox Pattern
-
Facing the SnowStorm: Part 2
Boosting Snowflake Query Performance on High Churn Tables with the Deferred Merge Strategy
The Adventure Continues! In this chapter we dive into our Snowflake table data partitions, and we're starting to suspect our good friend MERGE might have something to do with it. After some trial and error (and a few too many hairs lost), we managed to boost query speed by 90% (!!!). Read on to find out how!
-
Facing the SnowStorm: Part 1
Why Snowflake Queries Slow Down on High Churn Tables and How We Fixed It
MERGE operations in Snowflake can really slow things down, especially when you're dealing with high churn tables that end up all fragmented. In part 1 of this 2-part series, we’re diving into the problem and take you on a tale of woe, despair, lots of coffee and some glimmering nuggets of wisdom in the land of Snowflakes.
-
TIL in UNIX tooling - JQ is awesome!
Easily convert JSON <-> CSV using the magic of your terminal!
Why did the JSON file break up with the CSV file? Because we just couldn't parse their differences! ... ahem. Thankfully, this well known UNIX-tool `JQ` can help coerce JSON into other formats!