Overview

To improve the performance and expand the functionality of environments with a large number of assets, a separate dedicated database server should be set up to manage the "Venture" database, which is the name the Xinet team has given to the database used to store ancillary information about assets, such as low resolution previews of images/videos, annotations, metadata, and file IDs for linking.

Solution

Note: This solution works for the current Xinet version (2020.7) and below.

As an Administrator, install Xinet on your dedicated database server, obtain a separate Venture-only license, and migrate the Venture database from the main Xinet Administration server to your dedicated db server. Instructions are provided below.

Once Xinet is licensed on your Dedicated DB Server, a limited number of Administration tabs specific to the Venture database are available. For details on the options available in this view, see Xinet Statistics and Database Operations — the Database, Admin subtab.

Note: The database daemon (dblogd(8)) will run on the main Xinet Server, not on the Dedicated DB Server, so the Dedicated DB Server cannot run independently of the Xinet Administration server.

To install and license Xinet on a Dedicated DB Server:

1. Install the Xinet Administration software on your Dedicated DB Server
   For more information, see Install Xinet Server on a Macintosh Server (first time or upgrade).
2. Launch Xinet on your Dedicated DB Server and click License > License > Send License Request.
3. Fill out the form to submit a request for a Venture license for your Dedicated DB Server.

Note: Remember to place a check mark in the Database Server only field to indicate a Venture license is required.

For more information, see Licensing Software.

Next, as an Administrator, start the database manager (dbmgr) on your Dedicated DB Server and migrate the Venture database from your main Xinet Administration server.

To migrate the database to your Dedicated DB Server:

1. On your Dedicated DB Server, open a command-line and type the following command to run the database manager:
   dbmgr -mysqldonly <IP address or hostname of the Xinet Administration Server>
2. On your main Xinet Administration server, stop the database.
   
   • Click Database > Admin > Settings and in the Database Server options click Stop Database.
     IMPORTANT: If this is a new Xinet installation on both the Xinet server and your dedicated database server, DO NOT STOP the database.
3. Migrate the latest database from the main Xinet Administration server to your Dedicated DB Server.
   
   • Copy a ‘Full’ backup from your Xinet Administration Server to your Dedicated DB Server.
     Establish where and when the latest backup is located. On the Xinet Administration view, click Database > Admin > Backup to review the details. Click Full Backup to generate a backup and copy it to your Dedicated DB Server.

Next, configure the main Xinet Administration server to point to the database on your Dedicated DB Server.

To configure the Venture DB location on the main Xinet server:

• On the Xinet Administration server, open a command-line and type the following:
  # /usr/etc/venture/bin/dbmgr -remotemysqld <IP address or host name of the Dedicated DB Server>
• Note: For an environment where Xinet has been installed previously, some records may not have been transferred at the time of migration to the Venture database to your Dedicated DB Server. To resolve this issue, run any of the following programs on your Dedicated DB Server:
  
  • Run the listdir program to verify if the contents displayed in the Portal browser are up-to-date in the Venture database.
  • Run the database daemon (dblogd(8)) to stop and restart the database. Once restarted, the database daemon checks for changes and updates the Venture database.
  • Run the program syncvoltodb with no flags to manually synchronize file information in the Venture database.