Research And Tool Development Of Real-time High-speed Backup For Structured Database Based On Rsync

In the information age,data has become an important part of corporate and personal intangible assets,and its security needs have become more and more attention and attention.The problems of data security are mainly caused by natural disasters,virus intrusion,manual misuse,hardware failure and other factors.It might damage to the data,or even cause the system to be paralyzed and bring destructive blow to the enterprise.Therefore,we can see the importance of the database disaster recovery system to the enterprise that can provide a comprehensive,efficient and real-time recovery and can guarantee data security and continuous access,and simultaneously data backup technology is an effective way to solve the disaster recovery database.And some of the existing structure of the database backup tool,can not meet all of the above requirements,the traditional data backup technology is non-real-time,low backup efficiency,non-automation,poor applicability,expensive and so inadequate.Therefore,this article is based on the optimized Rsync remote file synchronization algorithm,and at the same time real-time monitoring of source-side database file changes,developed a lightweight,real-time high-speed and does not rely on any database platform file incremental backup tool to achieve the database remote Backup disaster recovery purposes.The tool is divided into two major functional modules: file monitoring module and file synchronization module.To a common Oracle database,for example,the file monitoring module on the database directory file for real-time monitoring.Which file monitoring module is based on Linux inotify mechanism to achieve,file synchronization module is selected under the Linux Rsync remote file backup tool to achieve.Then,in order to improve the overall efficiency and performance of the tool,we have analyzed the algorithm and logical idea of the tool as a whole.We propose two points of optimization,the file verification performance optimization in Rsync synchronization algorithm and multi-threaded optimization in synchronization operations,and through the source code analysis and modification to achieve.At the end of the paper,we will test the backup tools according to the test scheme we designed,and compare the results before and after the optimization.The results show that the performance and efficiency of the tool have a certain upgrade based of realizing the real-time and high-speed backup of the data file.