CDP for Databases

The purpose of this manual is to provide you with complete instructions on how to use the Database Add-on Module.

h2. About Database Add-on Module

Having the Database Add-on Module allows the agent to protect any number or combination of database instances (MySQL, SQL Server, MS Exchange). The R1Soft Database Add-on Module integrates Continuous Data Protection® with an online hot backup (snapshot) of databases to provide fast, efficient, and safe backups. The R1Soft Database Add-on Module ensures that tables be locked and flushed before a backup operation can take place. Database Add-on Module coordinates with the point-in-time file system snapshot.

The Database Add-on Module requires you to specify a database account with administrative privileges that is used by the Agent to flush tables with read lock before the file system snapshot is taken. And the lock must be held until the snapshot completes.

{note:title=Notice}
If you use CDP to backup MySQL and do not use the R1Soft Database Add-on Module, then the table lock and flush operation will not take place and your MySQL backup may likely be corrupt.
{note}
*Supported versions*:
* SQL Server 2005 all editions
* SQL Server 2008 all editions
* SQL Express
* SQL Server 2012 TBD
* {color:#000000}MariaDB{color}
* {color:#000000}Percona Server{color}
* {color:#000000}MS Exchange 2007{color}
* {color:#000000}MS Exchange 2010{color}

*Unsupported configurations*:
* MSDE (SQL Server 2000 version of SQL Express) or Anything Prior to 2005
* Object (e.g. table) level restore
* Support Active/Active SQL Server Clusters
* Log Shipping
* Backup of a selection of individual databases (the feature will be added in the future)
* MS Exchange 2003

h2.Databases Replication and Restore Overview

Do the following to *backup* your database:
# Add an Agent to the system and enable the Databases Add-on for the Agent. See [Enabling Databases Add-On for Agent|Enabling Databases Add-On for Agent].
# Upload Java connector (only for MySQL). See [Installing the MySQL Connector JDBC into CDP3 Server].
# Create a Policy for the Agent. On the "MySQL," "SQL" and "Exchange" tabs, add your database instance(s) and specify other settings. See [Adding a MySQL Instance to a Policy], [CDP:Configuring MS SQL Server Replication], [CDP:Configuring an Exchange Instance].
# Run the created Policy.

{note:title=Notice}
In CDP, end-user level databases backup is not supported. Only super-users can fulfill databases backup. Sub-users are limited by agent user permission.
{note}

The following steps should be taken to *restore* your database:

{composition-setup}
{deck:id=myDeck}
{card:label=Section Contents}
{children:excerpt=true}
{card}
{card:label=PDF Downloads}
[!ug-a.png!|http://wiki.r1soft.com/spaces/flyingpdf/pdfpageexport.action?pageId=22187691|CDP Advanced Edition User Guide]



[!ug-e.png!|http://wiki.r1soft.com/spaces/flyingpdf/pdfpageexport.action?pageId=22187702|CDP Enterprise Edition User Guide]






{card}
{card:label=Related Articles}
{contentbylabel:mysql_3|space=kb3|maxResults=10|showLabels=false|sort=modified|reverse=true}
{card}
{deck}
{excerpt:hidden=true}
General information about the Database Add-on Module on Linux or Windows CDP Server Enterprise and Advanced Editions.
{excerpt}\\