Sonic 8 ESB - NetApp Snapshots

Posted by petter.glenstrup on 20-Oct-2010 05:18

Hi
I have a Progress Sonic 8 ESB customer that are asking if he can put his ESB database into backup state, to enable a NetApp snapshot.
Are there any of you guys that are using NetApp storage to do backups of the Sonic ESB DB ?
If yes – how ?

All Replies

Posted by tsteinbo on 01-Nov-2010 10:56

Could you elaborate which database you referring to? The broker or the directory service one? There are different answers for each.

Thomas

Posted by petter.glenstrup on 05-Nov-2010 08:12

Hi

Right now it is the Broker, but in future SOA projects the Directory DB will also be used.

Could you help out with a answer for this ?

Posted by tsteinbo on 10-Nov-2010 02:04

There is very little value in performing a backup of a broker database because it just contains snapshots of messages going through the broker which are gone a few milliseconds later. So any backup will be worthless the same amount of milliseconds later. The right way to deal with messaging resilience is to use replicated broker pairs (CAA).

The story is different for the DS though. Since it contains configuration information that you typically do not want to loose it makes sense to backup the underlying db. That can actually be done in online mode (see dsAdmin.bat(sh)). So best is to plug dsAdmin into a script that is executed before NetApp gets at the data so you will be sure to have a transactionally consistent view of the db (it consist of multiple files which need to be backed up as a set).

Thomas

This thread is closed