title: ÐÐ¾Ð²ÑÑÐµÐ½Ð¸Ðµ Ð¾ÑÐºÐ°Ð·Ð¾ÑÑÑÐ¾Ð¹ÑÐ¸Ð²Ð¾ÑÑÐ¸ Ð¸ ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÐ¸ ÑÐ¸ÑÑÐµÐ¼Ñ Ð·Ð° ÑÑÐµÑ Ð¼Ð¸Ð³ÑÐ°ÑÐ¸Ð¸ Ð² NewSQL Ñ ÑÐ°Ð½Ð¸Ð»Ð¸ÑÐµ Ð´Ð°Ð½Ð½ÑÑ
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð±Ð°ÐºÐ°Ð»Ð°Ð²ÑÐ°
titleType: Subtitle
title: Enhancing system fault tolerance and efficiency through migration to a NewSQL data storage
Creators: name: ÐÐ¾Ð±ÐµÐ´Ð¾Ð½Ð¾ÑÑÐµÐ², ÐÐ¸ÑÐ¸Ð»Ð»
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2024
Subjects: ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð½ÑÐµ ÑÐ¸ÑÑÐµÐ¼Ñ
NewSQL
Ð¾ÑÐºÐ°Ð·Ð¾ÑÑÑÐ¾Ð¹ÑÐ¸Ð²Ð¾ÑÑÑ
Ð¼Ð¸Ð³ÑÐ°ÑÐ¸Ñ Ð´Ð°Ð½Ð½ÑÑ
Ð¡Ð£ÐÐ
distributed systems
fault tolerance
data migration
DBMS

description: ÐÑÐ¾ÐµÐºÑ Ð¿Ð¾ÑÐ²ÑÑÐµÐ½ Ð¿Ð¾Ð²ÑÑÐµÐ½Ð¸Ñ Ð¾ÑÐºÐ°Ð·Ð¾ÑÑÑÐ¾Ð¹ÑÐ¸Ð²Ð¾ÑÑÐ¸ Ð¸ ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÐ¸ Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ ÑÐ¸ÑÑÐµÐ¼Ñ Ð¿ÑÑÐµÐ¼ Ð¿ÐµÑÐµÑÐ¾Ð´Ð° Ð½Ð° Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸Ðµ NewSQL ÑÑÐ°Ð½Ð¸Ð»Ð¸Ñ Ð´Ð°Ð½Ð½ÑÑ. ÐÐºÑÑÐ°Ð»ÑÐ½Ð¾ÑÑÑ ÑÐµÐ¼Ñ Ð¾Ð±ÑÑÐ»Ð¾Ð²Ð»ÐµÐ½Ð° ÑÑÐµÐ±Ð¾Ð²Ð°Ð½Ð¸ÐµÐ¼ Ð±ÑÑÑÑÐ¾Ð¹ Ð¾Ð±ÑÐ°Ð±Ð¾ÑÐºÐ¸ ÑÑÐ°Ð½Ð¸Ð¼ÑÑ Ð´Ð°Ð½Ð½ÑÑ Ð² ÑÑÐ»Ð¾Ð²Ð¸ÑÑ Ð¸Ñ Ð±Ð¾Ð»ÑÑÐµÐ³Ð¾ Ð¾Ð±ÑÐµÐ¼Ð° Ð¸ Ð±ÑÑÑÑÑÐ¼ ÑÐ°Ð·Ð²Ð¸ÑÐ¸ÐµÐ¼ ÑÐ¾Ð²ÑÐµÐ¼ÐµÐ½Ð½ÑÑ ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð½ÑÑ ÑÐ¸ÑÑÐµÐ¼. Ð Ð¿ÑÐ¾ÑÐµÑÑÐµ ÑÐ°Ð±Ð¾ÑÑ Ð²ÑÐ¿Ð¾Ð»Ð½ÐµÐ½ ÑÐµÐ¾ÑÐµÑÐ¸ÑÐµÑÐºÐ¸Ð¹ Ð°Ð½Ð°Ð»Ð¸Ð· ÑÑÑÐµÑÑÐ²ÑÑÑÐ¸Ñ Ð½Ð° ÑÑÐ½ÐºÐµ ÑÐµÑÐµÐ½Ð¸Ð¹ Ð² Ð¾Ð±Ð»Ð°ÑÑÐ¸ ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð½ÑÑ ÑÐ¸ÑÑÐµÐ¼ Ð¸ ÑÑÐ°Ð½Ð¸Ð»Ð¸Ñ Ð´Ð°Ð½Ð½ÑÑ, Ð¸Ð·ÑÑÐµÐ½Ñ Ð¸Ñ Ð´Ð¾ÑÑÐ¾Ð¸Ð½ÑÑÐ²Ð° Ð¸ Ð½ÐµÐ´Ð¾ÑÑÐ°ÑÐºÐ¸. ÐÐ»Ñ Ð¾Ð±ÐµÑÐ¿ÐµÑÐµÐ½Ð¸Ñ ÑÑÐ¿ÐµÑÐ½Ð¾Ð¹ Ð¼Ð¸Ð³ÑÐ°ÑÐ¸Ð¸ Ð±ÑÐ»Ð° ÑÐ¼Ð¾Ð´ÐµÐ»Ð¸ÑÐ¾Ð²Ð°Ð½Ð° Ð½Ð¾Ð²Ð°Ñ ÑÑÐµÐ¼Ð° Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ, ÑÑÐ¸ÑÑÐ²Ð°ÑÑÐ°Ñ Ð¾ÑÐ¾Ð±ÐµÐ½Ð½Ð¾ÑÑÐ¸ Ð¸ Ð²Ð¾Ð·Ð¼Ð¾Ð¶Ð½Ð¾ÑÑÐ¸ NewSQL ÑÑÐ°Ð½Ð¸Ð»Ð¸Ñ. ÐÐ°Ð¿Ð¸ÑÐ°Ð½ ÐºÐ¾Ð´, Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´ÑÑÐ¸Ð¹ Ð¼Ð¸Ð³ÑÐ°ÑÐ¸Ñ Ð´Ð°Ð½Ð½ÑÑ Ñ Ð¿ÑÐ¸Ð¼ÐµÐ½ÐµÐ½Ð¸ÐµÐ¼ Ð¼ÐµÑÐ¾Ð´Ð¸Ðº Ð¾ÑÐ½Ð¾Ð²Ð°Ð½Ð½ÑÑ Ð½Ð° ÑÐ²Ð¾Ð¹ÑÑÐ²Ð°Ñ ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð½ÑÑ ÑÐ¸ÑÑÐµÐ¼, ÐºÐ¾ÑÐ¾ÑÑÐµ Ð½Ð°Ð¿ÑÐ°Ð²Ð»ÐµÐ½Ñ Ð½Ð° Ð¼Ð¸Ð½Ð¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ñ Ð²ÑÐµÐ¼ÐµÐ½Ð¸ Ð¿ÑÐ¾ÑÑÐ¾Ñ Ð¸ Ð¿Ð¾ÑÐµÑÐ¸ Ð´Ð°Ð½Ð½ÑÑ. Ð ÐµÐ·ÑÐ»ÑÑÐ°ÑÑ Ð¼Ð¾Ð½Ð¸ÑÐ¾ÑÐ¸Ð½Ð³Ð° Ð¸ ÑÐºÑÐ¿ÐµÑÐ¸Ð¼ÐµÐ½ÑÐ¾Ð² Ð¿Ð¾ÐºÐ°Ð·ÑÐ²Ð°ÑÑ Ð·Ð½Ð°ÑÐ¸ÑÐµÐ»ÑÐ½Ð¾Ðµ ÑÐ»ÑÑÑÐµÐ½Ð¸Ðµ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´Ð¸ÑÐµÐ»ÑÐ½Ð¾ÑÑÐ¸ Ð¸ ÑÑÑÐ¾Ð¹ÑÐ¸Ð²Ð¾ÑÑÐ¸ ÑÐ¸ÑÑÐµÐ¼Ñ Ð¿Ð¾ÑÐ»Ðµ Ð¼Ð¸Ð³ÑÐ°ÑÐ¸Ð¸.
description: The project is dedicated to improving the fault tolerance and efficiency of an information system by transitioning to the use of NewSQL data storage. The relevance of the topic is driven by the requirement for fast processing of stored data under conditions of their large volume and the rapid development of modern distributed systems. In the course of the work, a theoretical analysis of existing solutions in the field of distributed systems and data storage available on the market was performed, their advantages and disadvantages were studied. To ensure a successful migration, a new database schema was modeled, considering the features and capabilities of NewSQL storage. Code was written to perform the data migration using techniques based on the properties of distributed systems, aimed at minimizing downtime and data loss. The results of monitoring and experiments show a significant improvement in system performance and resilience after the migration.