187,068
Quick Links
CDP for MySQL - How does it work?
The CDP MySQL add-on locks and flushes MySQL during synchronization providing for consistent MySQL table files. These files are the same MySQL InnoDB and MyISAM files you are already backing up. With the MySQL Agent add-on, these files will be...
[more]About Archiving Add-on
Continuous Data Protection® - Enterprise Edition
Affordable High Performance Disk to Disk Backup Software for Linux Servers with central management and data repository.
Continuous Data Protection (CDP) Enterprise Edition reduces server backup windows from hours to minutes. Works over most TCP/IP networks. Install in as little as 15 minutes. Provide high performance backups for up to 30 or more servers with one central CDP data repository and user interface.
PostgreSQL Server Continuous Data Protection
The Linux CDP Agent has support for backing up PostgreSQL databases while they are online. There are no options to check. Just back up the partition where your database files are stored.
At all times, PostgreSQL maintains a write ahead log (WAL) in the pg_xlog/ subdirectory of the cluster's data directory. The log describes every change made to the database's data files. This log exists primarily for crash-safety purposes: if the system crashes, the database can be restored to consistency by "replaying" the log entries made since the last checkpoint.
R1Soft will perform block-level Continuous Data Protection on both the PostgreSQL table space and write ahead log. The addition of R1Soft's open-file (snapshot) technology means restoring the table space is all that is needed. PostgreSQL will automatically replay any needed transaction in the write ahead log.
The following section in PostgreSQL manual goes into more detail on this subject:
http://www.postgresql.org/docs/8.1/static/backup-online.html
del.icio.us
Digg
Reddit
