Публікація:
Evaluating relational database scaling strategies in web engineering

Завантаження...
Зображення мініатюри

Дата

2025

Назва журналу

ISSN журналу

Назва тома

Видавництво

Lviv Polytechnic Publishing House

Дослідницькі проекти

Організаційні підрозділи

Видання журналу

Анотація

This document provides a comprehensive overview of horizontal scaling strategies for relational databases used in modern web engineering. The paper examines key approaches including replication, sharding, clustering, and caching techniques to address performance and scalability challenges in database systems. The study explores replication models, from traditional master-slave configurations to more complex multi-master setups, analyzing their benefits in handling read-heavy workloads while addressing synchronization challenges and potential data inconsistency issues. The paper discusses sharding as a method for distributing data across independent databases, enabling parallel processing but requiring significant application logic modifications and routing complexity. Clustering solutions, particularly Galera Cluster for MySQL, are presented as approaches providing synchronous replication with simultaneous write support, offering high consistency at the cost of increased complexity and infrastructure requirements. The role of caching technologies like Redis and Memcached is examined as supplementary but crucial practices for reducing database access frequency and improving system performance. The document includes a comparative analysis evaluating these strategies across multiple criteria: performance, reliability, implementation complexity, data consistency, and scalability. It identifies optimal use cases for each approach, from content platforms and analytics systems to financial services and social networks. The paper concludes that no single strategy is universal, advocating for hybrid approaches that combine multiple scaling techniques to achieve optimal balance between scalability, performance, and data consistency. It emphasizes that database scaling represents not only a technical challenge but a strategic decision critical to web project durability and competitiveness.

Опис

Ключові слова

evaluating, relational database, scaling strategies, web engineering

Бібліографічний опис

Sotnik S. Evaluating relational database scaling strategies in web engineering / S. Sotnik, M. Rudenko // International Conference on Advanced Trends In Radioelectronics and Infocommunications (ATRIC-2025), May 21–22, 2025. - Lviv : Lviv Polytechnic Publishing House, 2025. – рр. 224-228.

DOI