The following outlines the steps to upgrade from your current ArangoDB to a newer version.

We would always strongly recommend backing up your VM/Server prior to following these steps. These steps should take approximately 20-50 minutes to complete.

1.Open Command Prompt

On your Windows server that contains ArangoDB, in a command prompt, type

arangosh

Enter the root password.

Or from the browser GUI, the login page identifies this.

2. Shut down the Centro Web App in the IIS

This is to prevent any addtional changes to the database by shutting down Centro. First start wth the web app.

  1. Notify your user base on downtime.

  2. Make sure there are no files being processed in the Centro Pipeline Manager.

  3. Bring up IIS Manager on your web server.

  4. Click Stop on the right side.

3. Stop the Pipeline Host service

Stop and disable the Pipeline Host service to prevent it from restarting on its own.

  1. Bring up Services.

  2. Double click on Centro | Pipeline Host.

  3. Click Stop.

  4. Set the Startup type to Disabled.

  5. Click OK.

4. Stop the Pipeline Manager service

Stop and disable the Centro Pipeline Manager service to prevent it from restarting on its own.

  1. Again bring up Services.

  2. Double click on Centro | Pipeline Manager.

  3. Click Stop.

  4. Set the Startup type to Disabled.

  5. Click OK.

5. Back up the database

  1. Open a command prompt.

  2. Navigate to an approprate folder that holds Arangodump.exe (i.e C:\Program Files\ArangoDB3e 3.x.x/usr/bin). If there are more versions under “C:\Program Files\”, it will be the latest version, this can be double checked by logging into your ArangoDB Website)

  3. On the command line, use the arangodump command.
    Usage:
    arangodump --server.database [database name] --output.directory “[dir name]”

    Notes:
    * The default Centro database name is ActifyDB.
    * The directory the files are exported to does not have to exist beforehand.
    * A valid ArangoDB root password is needed for this step.

    Add --overwrite true if you rerun the command and want to overwrite the existing files.

Example

arangodump --server.database ActifyDB --output-directory "dump" --overwrite true
CODE

At the time of this writing there are 75 collections dumped.

6. Store a copy

In case of a catastrophic failure, save a copy of the back up folder/files on a separate system or drive.

Make sure the separate system is secure and conforms to your organizations security protocols.

7. Stop arangodb3

Stop the ArangoDB service.

  1. Again bring up Services.

  2. Double click on ArangoDB.

  3. Click Stop.

  4. Click OK.

8. Save backup of the Arangod.conf file

  1. Go to the c:\Progam Files\ArangoDB 3.8.x\etc folder.

  2. Save the arangod.conf file to another directory/hard drive that can be used as a backup incase the original is lost or corrupted.

9.A Method A (ArangDB Upgrade)

This is the recommend approach. Install the consecutive versions of ArangoDB until you are on the latest Actify Supported version for your version of CAD Publisher (ArangoDB Compatibility Chart).

If your version of CAD Publisher supports up to ArangoDB 3.9 you can use the example below:

Example:

  • Upgrading from ArangoDB 3.6.8 to ArangoDB 3.7.18

  • Then upgrading from ArangoDB 3.7.18 to ArangoDB 3.8.

  • And then finally ArangoDB 3.8.8 to ArangoDB 3.9.x.

  • Note - Upgrading that skips major versions, such as 3.6.x to 3.9.x is not officially supported. The officially supported upgrade path is the example given above.

In the above example, you would need the following:

  • ArangoDB3-3.7.18_win64.exe

  • ArangoDB3-3.8.8_win64.exe

  • ArangoDB3-3.9.5_win64.exe

We would strongly recommend checking with Actify’s Technical Support Team for the appropriate versions to use for this method by reaching out to them at centrosupport@actify.com or https://support.actify.com.

  • Once the upgrades have been completed. Skip 9B to 14 and Proceed to Step 15. Test for Completion.

9.B Method B (ArangDB Upgrade)

This is the original method that was used to upgrade your ArangoDB to the latest version.

First, Uninstall Arangodb

  1. Open Programs and Features.

  2. Select ArangoDB3e 3.x.x in the list.

  3. Click Uninstall/Change.

4. Follow the uninstall wizard.

5. When asked do not delete ArangoDB user elements. Leave it unticked.

10. Install Arangodb Community Edition

  1. Download ArangoDB Community version 3.x.x for Windows. (Actify can provide you the download links)

  2. Double-click on the ArangoDB installation and follow the wizard instructions. (Note - Do not change the ticked/unticked boxes shown below, leave as default)

3. Once complete, stop the ArangoDB service in Services if it has started.

4. Adjust configuration such as any endpoint adjustments for GUI. The arangod.conf file can be found and edited in the C:\Program Files\ArangoDB3 3.9.2\etc\arangodb3 folder (depending if you’ve used the default and depending on the exact version).
You can apply the arangod.conf file save from step #8.

  1. If you utilize an encrypted link (SSL) between the database and Centro make those adjustments.

  2. Restart the ArangoDB service in Services,

11. Restore the database

On Windows, the database should still be intact. However, if you find that the database and the data is not there then restore the database through the following steps.

  1. Open a Command Prompt.

  2. Navigate to the folder above the folder where you dumped the database.

  3. From the ArangoDB Web GUI (localhost:8529), login as the root user.

  4. Select _System.

  5. Create an empty database with your database name
    (Centro defaults to “ActfyDB”).

  6. On the command line, use the arangorsetore command.
    Usage:
    arangorestore --server.database [database name] --output.directory “[dir name]”

Example

arangorestore --server.database ActifyDB --input-directory “dump”
CODE

12. Start the Centro Web App

  1. Bring up IIS Manager on your web server.

  2. Click Start on the right side.

13. Start the Pipeline Host service

To start up the Pipeline Host service.

  1. Bring up Services.

  2. Double click on Centro | Pipeline Host.

  3. Set the Startup type to Automatic.

  4. Click Apply.

  5. Click Start.

  6. Click OK.

14. Start the Pipeline Manager service

To start up the Pipeline Manager service.

  1. Bring up Services.

  2. Double click on Centro | Pipeline Manager.

  3. Set the Startup type to Automatic.

  4. Click Apply.

  5. Click Start.

  6. Click OK.

15. Test for completion

Verify your update and data restore worked by conducting the following simple tests.

  • Verify the database is a Community version and is 3.9.x.
    To do this login to the web GUI.

  • If you are NOT updating your CAD Publisher software. Proceed back to Step 3 and 4 to change the startup types for those services back to “Automatic” for the Pipeline Host and Pipeline Manager, as shown below.

  • Login to the CAD Publisher website to ensure it still loads with no errors. Logging into CAD Publisher validates the database is still accessible after the upgrades.

  • ArangoDB upgrade procedure has now been completed!

16. Next, Upgrading the CAD Publisher Software