Log shipping

Log shipping is the process of automating the backup of a database and transaction log files on a primary (production) database server, and then restoring them onto a standby server. This technique is supported by Microsoft SQL Server,^[1] 4D Server,^[2] MySQL,^[3] and PostgreSQL.^[4]^[5] Similar to replication, the primary purpose of log shipping is to increase database availability by maintaining a backup server that can replace a production server quickly. Other databases such as Adaptive Server Enterprise and Oracle Database support the technique but require the Database Administrator to write code or scripts to perform the work.

Although the actual failover mechanism in log shipping is manual, this implementation is often chosen due to its low cost in human and server resources, and ease of implementation. In comparison, SQL server clusters enable automatic failover, but at the expense of much higher storage costs. Compared to database replication, log shipping does not provide as much in terms of reporting capabilities, but backs up system tables along with data tables, and locks the standby server from users' modifications.^[6] A replicated server can be modified (e.g. views) and is therefore unsuitable for failover purposes.

References

↑ How to Perform SQL Server Log Shipping, "What is Log Shipping". Retrieved on 2008-12-16.
↑ "Setting Up a Logical Mirror". 4D Server v14 Documentation.
↑ "MySQL :: MySQL 5.7 Reference Manual :: 17.1 Configuring Replication". mysql.com.
↑ "Warm Standby Servers for High Availability". PostgreSQL 8.2.19 Documentation.
↑ "Hot Standby". PostgreSQL Wiki. Retrieved 2011-01-25.
↑ Ibison, Paul. "Log Shipping vs Replication". SQLServerCentral.com. Retrieved 2009-08-07.

External links

Log Shipping, MS SQL Server implementation
Hot Standby, PostgreSQL implementation

Database
Main	Requirements Theory Models Database management system Machine Server Application Connection datasource DSN Administrator Lock Types Tools
Languages	Data definition Data manipulation Query information retrieval
Security	Activity monitoring Audit Forensics Negative database
Design	Entities and relationships (and Enhanced notation) Normalization Refactoring
Programming	Abstraction layer Object-relational mapping
Management	Virtualization Tuning caching Migration Preservation Integrity
See also	Database-centric architecture Intelligent database Two-phase locking Locks with ordered sharing Load file Publishing Halloween Problem Log shipping
Book Category WikiProject

This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.