Calculation of the optimal timeout of executing a SQL query for multi-master replication system
Электронный научный архив УРФУ
Информация об архиве | Просмотр оригинала| Поле | Значение | |
| Заглавие |
Calculation of the optimal timeout of executing a SQL query for multi-master replication system
|
|
| Автор |
Babaylov, V.
Timofeeva, G. |
|
| Описание |
Many multi-master replication systems are based on a two-phase commit mechanism. One of its problems is waiting for a response from the database servers by the coordinator, which may not come due to problems on the network or on the database server itself, which leads to delays in the activity of the multi-master replication system. Usually, such problems are solved by introducing a timeout, but if its value is too large, the problem may not be noticed in a timely manner, and too small a timeout will be processed for SQL queries, which will cause an increase in the load on the network due to additional service messages. The paper analyzes the execution time of a SQL query on several servers in order to calculate the optimal timeout for a multi-master replication operation. Based on the results obtained, a module for calculating the optimal query execution timeout for multi-master replication systems has been developed. © 2022 Author(s).
|
|
| Дата |
2024-04-22T15:52:32Z
2024-04-22T15:52:32Z 2022 |
|
| Тип |
Conference paper
Conference object (info:eu-repo/semantics/conferenceObject) Published version (info:eu-repo/semantics/publishedVersion) |
|
| Идентификатор |
Babaylov, V & Timofeeva, G 2022, Calculation of the optimal timeout of executing a SQL query for multi-master replication system. в MD Todorov (ред.), Application of Mathematics in Technical and Natural Sciences - 13th International Hybrid Conference for Promoting the Application of Mathematics in Technical and Natural Sciences, AMiTaNS 2021., 060001, AIP Conference Proceedings, Том. 2522, American Institute of Physics Inc., 13th International Hybrid Conference for Promoting the Application of Mathematics in Technical and Natural Sciences, AMiTaNS 2021, Albena, Болгария, 24/06/2021. https://doi.org/10.1063/5.0100779
Babaylov, V., & Timofeeva, G. (2022). Calculation of the optimal timeout of executing a SQL query for multi-master replication system. в M. D. Todorov (Ред.), Application of Mathematics in Technical and Natural Sciences - 13th International Hybrid Conference for Promoting the Application of Mathematics in Technical and Natural Sciences, AMiTaNS 2021 [060001] (AIP Conference Proceedings; Том 2522). American Institute of Physics Inc.. https://doi.org/10.1063/5.0100779 978-073544361-7 0094-243X Final All Open Access; Bronze Open Access https://aip.scitation.org/doi/pdf/10.1063/5.0100779 https://aip.scitation.org/doi/pdf/10.1063/5.0100779 http://elar.urfu.ru/handle/10995/132321 10.1063/5.0100779 85140222604 |
|
| Язык |
en
|
|
| Права |
Open access (info:eu-repo/semantics/openAccess)
|
|
| Формат |
application/pdf
|
|
| Издатель |
American Institute of Physics Inc.
|
|
| Источник |
APPLICATION OF MATHEMATICS IN TECHNICAL AND NATURAL SCIENCES: 13th International Hybrid Conference for Promoting the Application of Mathematics in Technical and Natural Sciences - AMiTaNS’21
AIP Conference Proceedings |
|