KB ID : 115029
Published : Aug. 1, 2016
Created : Aug. 1, 2016
Last Modified : Nov. 14, 2018

Overview

This article explains the steps to be followed to recover the Vembu BDR backup server installation, in case of BDR backup server machine corruption or system crash.

In re-building a Vembu BDR backup server, you need to have the following:

  1. Backed up data (its metadata can be constructed out of this data itself)

  2. Dumped Server Configuration Database file.

By default, the Vembu BDR backup server’s configurations are stored in a database that is dumped daily. This file is dumped under the path given during installation for the backup storage location. For e.g.,

/sgstorage/Default_Repo/sgdatabase/sgdatabase.sql

The other piece of the database that you need is the metadata of the backup data which can be constructed from the backup data itself as described later in the sections below.

Where to find the dumped database file

If the server’s default backup location is changed during installation, then the database file is dumped under the changed location. This can be confirmed by checking the Path attribute under the tag BackupServerMetaData in “/conf/SGConfiguration.conf” file.

Steps to Rebuild Backup Server

Rebuilding the backup server is a three-step process:

  1. Install Vembu BDR, MySQL and MongoDB applications to the new machine.
  2. Import Vembu BDR backup server database to the new machine.
  3. Rebuilding backup server metadata from the backup data.

Install Vembu BDR and MySQL server to the new machine

Install and configure Vembu BDR, MySQL Server, MySQL Connectors and MongoDB in the new machine. We have simplified the installation of MySQL and its components, by bundling it into a single installer file which installs and configures MySQL, ODBC and MongoDB automatically. Download the same version of Vembu BDR Server installer which was running earlier in your machine from the links provided below:

v3.5 , v3.6 , v3.6 Update 1

Import Vembu BDR backup server database to the new machine

After installing Vembu BDR and MySQL server in the new machine, import Vembu BDR backup server database from the dumped database file of the crashed machine to the new machine’s MySQL server by executing the given command in MySQL location.

For Windows OS

mysql -u [username] -p[password]< BackupLocation]/DBNAME/DBNAME/DBNAME.sql

Example:

Mysql username and pwd

Here, the root is MySQL username, admin is MySQL password and D:\BACKUPANDDUMP_LOCATION\ is the backup location where the database dump file is stored.

For Linux OS

mysql -u [username] -p[password]< [BackupLocation]/DBNAME/DB_NAME.sql

Example:

For Linux OS

Here, the root is MySQL username, admin is MySQL password and /BACKUPANDDUMP_LOCATION/ is the backup location where the database dump file is stored.

Rebuilding backup server metadata from backup data

Once MySQL database is recovered from the dump file, install Vembu BDR backup server application in a new system with the same Vembu BDR ID as in the old backup server machine. Also, ensure the hostname of the new backup server and the old backup server are the same. Also, make sure that the same storage location is specified as before.

  1. Choose the option not to start Vembu BDR service immediately after installation. Vembu BDR can be started after a little tweak in the installation.

  2. Delete the data/dbpopulation.txt file in the fresh Vembu BDR installation location.

NOTE: This step is crucial as the text file is present to ensure proper internal DB creation in the fresh installation of Vembu BDR.

  1. Confirm whether backed up data (<drive_letter sgstorage="">) is available in the backup location

  2. The metadata of the backups can be reconstructed using the backed up data by running Vembu BDR from its installation location as shown below:

For Windows

Rebuild MySQL and MongoDB metadata for all backups:

  • bin\VembuBDR.exe CheckAndUpdateDB All

Rebuild MySQL metadata alone for all backups:

  • bin\VembuBDR.exe CheckAndUpdateDB MySQL

Rebuild MongoDB metadata alone for all backups:

  • bin\VembuBDR.exe CheckAndUpdateDB Mongo

Rebuild MySQL and MongoDB metadata for all backups under one client machine:

  • bin\VembuBDR.exe CheckAndUpdateDB All CLIENT_NAME

Rebuild MySQL and MongoDB metadata for one backup:

  • bin\VembuBDR.exe CheckAndUpdateDB All CLIENTNAME BACKUPNAME

For Linux

Rebuild MySQL and MongoDB metadata for all backups:

  • ./bin/VembuBDR CheckAndUpdateDB All

Rebuild MySQL metadata alone for all backups:

  • ./bin/VembuBDR CheckAndUpdateDB MySQL

Rebuild MongoDB metadata alone for all backups:

  • ./bin/VembuBDR CheckAndUpdateDB Mongo

Rebuild MySQL and MongoDB metadata for all backups under one client machine:

  • ./bin/VembuBDR CheckAndUpdateDB All CLIENT_NAME

Rebuild MySQL and MongoDB metadata for one backup:

  • ./bin/VembuBDR CheckAndUpdateDB All CLIENTNAME BACKUPNAME

Here, Vembu\Vembu BDR is Vembu BDR installation location.

This command will construct all the metadata and insert them into the database. Now database and all the backed up data are attached with new backup server machine.

edit retag flag offensive close merge delete