Sayed Alesawy

Archive (38)

How to Use ClickHouse Aggregation States to Boost Materialized Views Performance by More Than 10 Times?

Jan 27, 2024 ·  Sayed Alesawy

Designing Data Intensive Applications: Ch.7 Transactions (weak isolation levels)

Dec 10, 2023 ·  Sayed Alesawy

Designing Data Intensive Applications: Ch.7 Transactions (intro to ACID transactions)

Dec 2, 2023 ·  Sayed Alesawy

Designing Data Intensive Applications: Ch.6 Partitioning (Part 3: Rebalancing Partitions and Request Routing)

Aug 26, 2023 ·  Sayed Alesawy

Designing Data Intensive Applications: Ch.6 Partitioning (Part 2: Partitioning and Secondary Indexes)

Aug 4, 2023 ·  Sayed Alesawy

Designing Data Intensive Applications: Ch.6 Partitioning (Part 1: Partitioning of Key-Value Data)

Jul 22, 2023 ·  Sayed Alesawy

How to implement Efficient Point Queries in ClickHouse?

Mar 31, 2023 ·  Sayed Alesawy

Designing Data Intensive Applications: Ch5. Replication (Part 4: Leaderless Replication)

Dec 24, 2022 ·  Sayed Alesawy

Designing Data Intensive Applications: Ch5. Replication (Part 3: Multi-Leader Replication)

Nov 11, 2022 ·  Sayed Alesawy

Designing Data Intensive Applications: Ch5. Replication (Part 2: Problems with Replication Lag)

Oct 29, 2022 ·  Sayed Alesawy

Designing Data Intensive Applications: Ch5. Replication (Part 1: Leader-Based Replication)

Sep 17, 2022 ·  Sayed Alesawy

Designing Data Intensive Applications: Ch4. Encoding and Evolution

Aug 26, 2022 ·  Sayed Alesawy

Concurrency, Race Conditions and Concurrency Control

Jun 19, 2022 ·  Sayed Alesawy

Designing Data Intensive Applications: Ch3. Storage and Retrieval | Part 2

Jun 17, 2022 ·  Sayed Alesawy

Designing Data Intensive Applications: Ch3. Storage and Retrieval | Part 1

Mar 12, 2022 ·  Sayed Alesawy

Designing Data Intensive Applications: Ch2. Data Models and Query Languages | Part 2

Jan 21, 2022 ·  Sayed Alesawy

Designing Data Intensive Applications: Ch2. Data Models and Query Languages | Part 1

Jan 15, 2022 ·  Sayed Alesawy

Designing Data Intensive Applications: Ch1. Reliable, Scalable and Maintainable Applications

Dec 3, 2021 ·  Sayed Alesawy

Spanner: Google’s Globally-Distributed Database

Nov 5, 2021 ·  Sayed Alesawy

Calvin: Fast Distributed Transactions for Partitioned Database Systems

Oct 1, 2021 ·  Sayed Alesawy

Facebook’s Tectonic Filesystem: Efficiency from Exascale

Aug 13, 2021 ·  Sayed Alesawy

Learn MySQL Internals and Query Performance Optimization Techniques

Jul 10, 2021 ·  Sayed Alesawy

Facebook Storage Infrastructure: How Facebook Cuts Costs by Managing BLOB Storage Life Cycle

Jun 26, 2021 ·  Sayed Alesawy

High Performance MySQL [Ch.7: Advanced MySQL Features]

Jun 19, 2021 ·  Sayed Alesawy

Amazon Aurora: MySQL on Steroids

Jun 15, 2021 ·  Sayed Alesawy