Evaluating relational database scaling strategies in web engineering

Sotnik, S. V.; Rudenko, М.

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

dc.contributor.author	Sotnik, S. V.
dc.contributor.author	Rudenko, М.
dc.date.accessioned	2025-06-26T20:07:26Z
dc.date.available	2025-06-26T20:07:26Z
dc.date.issued	2025
dc.description.abstract	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.
dc.identifier.citation	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.
dc.identifier.isbn	978-966-994-062-9
dc.identifier.uri	https://openarchive.nure.ua/handle/document/31831
dc.language.iso	en_US
dc.publisher	Lviv Polytechnic Publishing House
dc.subject	evaluating
dc.subject	relational database
dc.subject	scaling strategies
dc.subject	web engineering
dc.title	Evaluating relational database scaling strategies in web engineering
dc.type	Conference proceedings
dspace.entity.type	Publication