August 7, 2007 – (HOSTSEARCH.COM) – Data protection provider R1Soft (http://www.r1soft.com), the developer of “near-continuous” data protection products for Linux and Windows, has announced that its MySQL backup product offers a new feature called ‘True Granular Restore’. The feature offers developers and administrators more control and options when restoring MySQL databases.
True Granular allows administrators to control what data is restored when restoring MySQL databases. The option operates on the individual table level, and allows any combination of tables and databases to be restored to alternate locations. This provides a great level of flexibility when, for instance, an administrator only wishes to restore a small amount of data in a large database. Restoring data to an alternate location allows administrators to review it before making it live.
“When we began developing our product, we realized that table level restores would be the killer new feature for MySQL database recovery,” explained R1Soft Founder and CEO, David Wartell. “In looking at the technical limitations, we realized why it had never been done before, especially with InnoDB. But after a lot of coffee and many late nights, we ultimately developed a way to make it happen, and we’re the first to do so,” “Other backup software vendors have been sitting back and waiting for MySQL to build them a next-generation backup API, which is years away at best. We made a decision early on that we are not going to wait, and neither should the market. With our product, the MySQL community finally has the easy to use and high performance backup software it needs.”
R1Soft recently received MySQL’s Enterprise Certified Technology seal, an important recognition from the makers of the open source database. R1Soft’s MySQL product currently works with both the MyISAM and InnoDB storage engines, as well as all MySQL Enterprise and Community releases, versions 4.1 and greater.
R1Soft’s CDP products diverge significantly from traditional database backup technologies, which essentially create SQL dumps to another medium, such as a tape drive. These methods only provide data protection on a daily or weekly basis, and interrupt transactions on busy MySQL servers. R1Soft’s CDP technology, however, monitors changes to the disk as they happen, thereby reducing backup periods to seconds or minutes. It also affords even the busiest MySQL servers hot backups for both MyISAM and InnoDB with zero transaction loss or down time.
