Art of Distributed System Architecture Design
Author

Art of Distributed System Architecture Design

Introductions to large-scale distributed system architectures; insights and knowledge sharing on large-scale internet system architecture; front-end web architecture overviews; practical tips and experiences with PHP, JavaScript, Erlang, C/C++ and other languages in large-scale internet system development.

267
Articles
0
Likes
357
Views
0
Comments
Recent Articles

Latest from Art of Distributed System Architecture Design

100 recent articles max

An Introduction to Ansible: Installation, Configuration, and MySQL Replication with Playbooks

This article introduces Ansible, a Python‑based configuration management and deployment tool, explains its installation prerequisites, demonstrates basic ad‑hoc commands, and provides a comprehensive guide to managing MySQL master‑slave replication using Ansible modules, playbooks, and role‑based directory structures.

AnsibleAutomationConfiguration Management
0 likes · 19 min read
An Introduction to Ansible: Installation, Configuration, and MySQL Replication with Playbooks
Art of Distributed System Architecture Design
Art of Distributed System Architecture Design
May 23, 2016 · Information Security

Testing HTTP Header Parameters for SQL Injection: Coverage, Tools, and Best Practices

The article examines how HTTP header and cookie parameters can serve as SQL injection vectors, evaluates the coverage of commercial and open‑source web vulnerability scanners, demonstrates manual testing techniques, and recommends tools such as sqlmap for comprehensive security assessments.

SQL InjectionSQLMapcookies
0 likes · 13 min read
Testing HTTP Header Parameters for SQL Injection: Coverage, Tools, and Best Practices

MySQL Performance Optimization Tips for Web Applications

This article presents a comprehensive set of MySQL performance optimization techniques for web applications, covering query cache usage, EXPLAIN analysis, LIMIT 1, proper indexing, join optimization, avoiding ORDER BY RAND(), selective column retrieval, proper primary keys, ENUM usage, PROCEDURE ANALYSE, NOT NULL fields, prepared statements, unbuffered queries, IP storage as unsigned int, fixed‑length tables, vertical partitioning, batch DELETE/INSERT, column size reduction, storage engine selection, ORM usage, and careful handling of persistent connections.

MySQLPerformancePrepared Statements
0 likes · 21 min read
MySQL Performance Optimization Tips for Web Applications

Performance Optimization: Algorithm Improvements, Resource Tuning, and Caching Strategies

The article outlines how to boost system performance through algorithmic refinements, hardware and software resource upgrades, interaction optimizations between algorithms and resources, and effective caching techniques, while acknowledging trade‑offs and the need for balanced decisions.

OptimizationPerformancealgorithm
0 likes · 7 min read
Performance Optimization: Algorithm Improvements, Resource Tuning, and Caching Strategies

How eBay Scales to Billions: 7 Proven Practices for Massive Web Systems

This article outlines eBay's seven key scalability best practices—including functional partitioning, horizontal sharding, avoiding distributed transactions, asynchronous decoupling, stream processing, virtualization, and strategic caching—to illustrate how large‑scale web platforms can achieve linear resource growth and high availability.

Asynchronousarchitecturecaching
0 likes · 14 min read
How eBay Scales to Billions: 7 Proven Practices for Massive Web Systems