ITFLY8 Architecture Home - focused on architecture knowledge sharing and exchange, covering project management and product design. Includes large-scale distributed website architecture (high performance, high availability, caching, message queues...), design patterns, architecture patterns, big data, project management (SCRUM, PMP, Prince2), product design, and more.
Learn the fundamentals of logical database design, including key concepts such as candidate and primary keys, attributes, ER diagram symbols, and detailed explanations of the first, second, third, and BC normal forms with practical e‑commerce examples to avoid data anomalies.
This article compares standard service interfaces and standard messaging, explains their characteristics, and shows how to choose the appropriate approach for different scenarios such as content moderation, points systems, open platforms, monitoring, and task execution pipelines.
This article walks through building a low‑code platform that automatically creates Spring Boot REST endpoints from plain SQL definitions, covering datasource configuration, dynamic request mapping, SQL execution, and optional Swagger documentation generation.
This article compiles essential software architecture diagrams—including application, technical, security, and deployment views—providing visual references for developers to understand system structures, and encourages exploration of best practices in system design.
This article explains single sign‑on concepts, compares SAML, OAuth2 and OpenID Connect, outlines their benefits and typical workflows, and provides guidance on choosing the right protocol for different security and user‑experience scenarios.
This article explains how Wix uses Kafka‑based event‑driven messaging to decouple microservices, improve scalability, and achieve exactly‑once processing through patterns such as consume‑and‑project, end‑to‑end event streams, in‑memory KV stores, scheduled jobs, transactional events, and event aggregation.
This article details how a billion‑user membership platform achieved high performance and high availability by deploying dual‑center Elasticsearch clusters, traffic‑isolated ES architectures, extensive ES optimizations, a Redis caching layer with distributed locking, a dual‑center partitioned MySQL migration, and fine‑grained flow‑control and degradation strategies.
This article explains why solid database design is crucial for scalable applications and outlines ten best‑practice guidelines—including stakeholder input, choosing the right DB type, consistent naming, normalization, documentation, security, scalability, stored procedures, modeling time, and thorough testing.
This article explains the motivations, challenges, and design principles of horizontal scaling for databases, using TDSQL as a case study to illustrate architecture, scaling procedures, shard key selection, high‑availability mechanisms, distributed transactions, and performance optimization techniques.
This article examines how vertical and horizontal data partitioning leads to migration and consistency challenges, outlines full, full‑plus‑incremental, and binlog‑based migration strategies, and compares strong‑consistency XA transactions with flexible BASE approaches such as TCC and AT, including their components, workflows, advantages, and drawbacks.
