Rudenko, М.Sotnik, S.2025-01-192025-01-192024Rudenko М. Overview of approaches to scaling relational databases in development and adaptation of web applications / М. Rudenko, S. Sotnik // Сучасні проблеми і досягнення в галузі радіотехніки, телекомунікацій та інформаційних технологій : тези доповідей ХІІ Міжнародної науково-практичної конференції, 10-12 грудня 2024 р. - Запоріжжя: НУ «Запорізька політехніка», 2024. – С. 398-402.https://openarchive.nure.ua/handle/document/29615The work explores various approaches to scaling relational databases in the development and adaptation of web applications. Relational databases, despite their reliability and stability, face challenges in handling large amounts of data and high concurrency. Key methods discussed include replication (master/slave and master/master), functional partitioning, horizontal data distribution (sharding), and denormalization. Each method offers specific advantages, such as improving performance, ensuring high availability, and providing fault tolerance, while also presenting certain disadvantages, including synchronization delays, data conflicts, or increased complexity. The study emphasizes the importance of selecting appropriate scaling techniques based on the unique requirements of a given application to ensure efficiency, scalability, and system stability under heavy loads.en-USscaling relational databasesweb applicationsdatabase shardingvertical scalingdistributed databasesConference proceedings