- Source: Log shipping
Log shipping is the process of automating the backup of 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, 4D Server, MySQL, and PostgreSQL. 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. A replicated server can be modified (e.g. views) and is therefore unsuitable for failover purposes.
References
External links
Log Shipping, MS SQL Server implementation
Hot Standby, PostgreSQL implementation
Kata Kunci Pencarian:
- Mediterranean Shipping Company
- Zim Integrated Shipping Services
- Daftar perusahaan pengapalan peti kemas menurut jumlah kapal dan peti kemas
- Globalisasi
- CMA CGM
- Suku Jawa
- Institut Teknologi Sepuluh Nopember
- Norwegian Cruise Line
- Daftar padanan istilah bahari
- HMS Endeavour
- Log shipping
- Microsoft Exchange Server
- Change data capture
- Truncate (SQL)
- Failover
- Database administration
- Shipping container
- Log flume
- Logbook (nautical)
- SQL Server Agent
