PinnedFranck PachotOracle Sharding methods compared to YugabyteDBOracle has long been a leader in partitioning, distributing, and replicating databases. They offer shared-storage RAC for High Availability…8 min read·Feb 20, 2024--1--1
PinnedFranck PachotYugabyteDB: Achieving High Availability and Disaster Recovery with Two Data CentersSynchronous replication in the Raft groups, which requires the majority of replicas for each tablet, is crucial to YugabyteDB’s cluster…11 min read·Apr 20, 2023----
Franck PachotIsolation Levels — part XII: To go furtherSQL isolation levels are typically characterized by their effects, such as anomalies or phenomena, or by their implementation, such as…2 min read·Dec 18, 2023----
Franck PachotIsolation Levels — part XI: Read UncommittedThe Read Uncommitted isolation level is designed to prevent dirty reads, which are changes made by other transactions that have not yet…1 min read·Dec 13, 2023----
Franck PachotIsolation Levels — part X: Non-Transactional WritesPrevious isolation levels described in this series were focused on ensuring consistency of read operations and maintaining the read state…2 min read·Dec 13, 2023----
Franck PachotIsolation Levels — part IX: Read CommittedThe lowest level of MVCC databases is Read Committed, which is commonly used as the default setting. However, it is also possibly the…4 min read·Dec 10, 2023----
Franck PachotThe Most Annoying Optimizer Fail in Postgres ✅ Best index solved it.This blog post is based on a question asked on the PostgreSQL Slack channel (you can join via this invite link…8 min read·Dec 8, 2023----
Franck PachotIsolation Levels — part VIII: Cursor StabilityCursor Stability is not defined in SQL Standard, and I’ve seen it only in DB2. The Cursor Stability isolation level prevents lost updates…2 min read·Dec 8, 2023----
Franck PachotIsolation Levels — part VII: Repeatable ReadThe Repeatable Read isolation level allows changes on what you have scanned, except for rows returned after all filtering conditions. This…3 min read·Dec 5, 2023----
Franck PachotIsolation Levels — part VI: Snapshot IsolationIn databases that use multi-version concurrency control (MVCC), the Snapshot Isolation (SI) technique is used as the basis for read-only…2 min read·Dec 5, 2023----