Simultaneous Database Backup Using TCP/IP and a Specialized Network Interface Card
Scott J. Lloyd (University of Rhode Island, USA), Joan Peckham (University of Rhode Island, USA), Jian Li (Cornell University, USA) and Qing (Ken) Yang (University of Rhode Island, USA)
Copyright: © 2005
Data play an essential role in business today. Most, if not all, e-business applications are database driven, and data backup is a necessary element of managing data. Backup and recovery techniques have always been critical to any database and as real-time databases are used more often, real-time online backup strategies become critical to optimize performance. In this chapter, current backup methods are discussed and evaluated for response time and cost. A prototype device driver, RORIB (Real-time Online Remote Information Backup) is presented and discussed. An experiment is conducted comparing the performance, in terms of response time, of the prototype and several current backup strategies. RORIB provides an economic and efficient solution for real-time online remote backup. Significant improvement in response time is demonstrated using this prototype device driver when compared to other types of software driven backup protocols. Another advantage of RORIB is that the cost is negligible when compared to other hardware solutions for backup, such as Storage Area Networks (SAN) and Private Backup Networks (PBN). Additionally, this multilayered device driver uses TCP/IP, (Telecommunications Protocol/Internet Protocol) which allows the driver to be a “drop in” filter between existing hardware layers and thus reduces the implementation overhead and improves portability. Linux is used as the operating system in this experiment because of its open source nature and its similarity to UNIX. This also increases the portability of this approach. The driver is transparent to both the user and the database management system. Other potential applications and future research directions for this technology are presented. The goal of this work is to show a multifaceted approach that uses software and hardware to provide a cost effective and efficient real-time backup system for databases. This chapter explores the use of a specialized network card and corresponding software to provide service that is demonstrably better than current methods, due to cost containment, ease of operation, real time backup capabilities, or combinations of all of these. Prior to this research, the only option that approached this level of service was the use of an extremely expensive Private Backup Network (PBN) that does not adequately address the issue of obtaining real-time capabilities. Therefore, this research shows a true real-time system that is hardware and software independent and that can be used by any type of system to achieve the desired features.