Mechanisms of replication and backup of databases in the cloud environment

The functionality of deploying databases on cloud computing environments, the main tools of the MS SQL SERVER DBMS for saving data in industrial databases, as well as the construction of a fault-tolerant database cluster on industrial servers are considered. All possible methods of data synchronization between the main and backup database, as well as methods of data backup to the cloud are considered. Researching the mechanisms of database synchronization and data backup, as well as the construction of a fault-tolerant cluster, will allow to consider in more detail the methods of data storage, synchronization with backup databases and the construction of a fault-tolerant cluster, synchronization of the main and backup databases. Mechanisms for synchronizing the main and backup database of the server are primarily considered. The technology with a high level of database availability is AlwaysOn, which in turn creates a cluster of two databases and allows you to build a fault-tolerant cluster in which two databases work simultaneously and are simultaneously synchronized with each other. Application of Transaction Log Shipping technology will automatically send backup copies of transaction logs from the source database to the source server instance in one or more databases. When using data synchronization technology, database servers work in Active – StandBy/ReadOnly mode, that is, the main database will always be the main one, and if necessary, switch to the backup database. Also, replication technology is a set of technologies for copying and distributing data and database objects between databases, as well as synchronizing databases to maintain consistency. Accordingly, the construction of a fault-tolerant database cluster will allow maintaining the functionality of the enterprise's information system even if one of the database servers completely loses its functionality.