Franck Pachot – Medium

Pinned

Franck Pachot

Oracle Sharding methods compared to YugabyteDB

Oracle has long been a leader in partitioning, distributing, and replicating databases. They offer shared-storage RAC for High Availability…

8 min readFeb 20, 2024

--

1

Oracle Sharding methods compared to YugabyteDB

--

1

Pinned

Franck Pachot

YugabyteDB: Achieving High Availability and Disaster Recovery with Two Data Centers

Synchronous replication in the Raft groups, which requires the majority of replicas for each tablet, is crucial to YugabyteDB’s cluster…

11 min readApr 20, 2023

--

YugabyteDB: Achieving High Availability and Disaster Recovery with Two Data Centers

--

Franck Pachot

Isolation Levels — part XII: To go further

SQL isolation levels are typically characterized by their effects, such as anomalies or phenomena, or by their implementation, such as…

2 min readDec 18, 2023

--

Isolation Levels — part XII: To go further

--

Franck Pachot

Isolation Levels — part XI: Read Uncommitted

The Read Uncommitted isolation level is designed to prevent dirty reads, which are changes made by other transactions that have not yet…

1 min readDec 13, 2023

--

Isolation Levels — part XI: Read Uncommitted

--

Franck Pachot

Isolation Levels — part X: Non-Transactional Writes

Previous isolation levels described in this series were focused on ensuring consistency of read operations and maintaining the read state…

2 min readDec 13, 2023

--

Isolation Levels — part X: Non-Transactional Writes

--

Franck Pachot

Isolation Levels — part IX: Read Committed

The lowest level of MVCC databases is Read Committed, which is commonly used as the default setting. However, it is also possibly the…

4 min readDec 10, 2023

--

Isolation Levels — part IX: Read Committed

--

Franck Pachot

The 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 readDec 8, 2023

--

The Most Annoying Optimizer Fail in Postgres ✅ Best index solved it.

--

Franck Pachot

Isolation Levels — part VIII: Cursor Stability

Cursor 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 readDec 8, 2023

--

Isolation Levels — part VIII: Cursor Stability

--

Franck Pachot

Isolation Levels — part VII: Repeatable Read

The Repeatable Read isolation level allows changes on what you have scanned, except for rows returned after all filtering conditions. This…

3 min readDec 5, 2023

--

Isolation Levels — part VII: Repeatable Read

--

Franck Pachot

Isolation Levels — part VI: Snapshot Isolation

In databases that use multi-version concurrency control (MVCC), the Snapshot Isolation (SI) technique is used as the basis for read-only…

2 min readDec 5, 2023

--

Isolation Levels — part VI: Snapshot Isolation

--

Franck Pachot

Franck Pachot

Developer Advocate for YugabyteDB (Open-Source, PostgreSQL-compatible Distributed SQL Database. Oracle Certified Master and AWS Data Hero.

Help
Status
About
Careers
Blog
Privacy
Terms
Text to speech
Teams