Setting up a Separate Dedicated Database Server for Xinet versions


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.



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.
Troubleshooting information:
Can the Venture database migration be done while the database is ingesting data?
Only if you are copying a Full Backup from the Xinet Administration server to ensure you’re using a static version of the database. If you are copying the database tables, ensure that the database is not running before copying your tables.
What happens when the webbdlogs is running on the Xinet Administration Server while migrating the Venture database?
The webdblog continues to be processed by the Database Daemon (dblogd(8). Once the dbmgr -remotemysql command is run, the webdblog entries are processed and entered into the database on the Dedicated DB Server instead of the main Xinet Administration Server.
Should the database server be built from scratch?
Only if you are installing Xinet for the first time on both the Xinet Administration Server and the Dedicated DB Server. If you are working with a previously installed Xinet Venture database, the data will begin to ingest on the DATABASE server once the migration is completed.
How do you remove the database server?
In the Xinet Administration Server, stop the database to prevent further processing. Contact Xinet Support for assistance.
Why isn’t mysqld running on the Xinet Administration Server?
After the Venture database migration is completed, mysgld will only run on the database server.
Is the Solr database also moved in the migration to the database server?
No, the Solr database will continue to run on the main Xinet Administration Server. It is a separate database used to store Solr search tokens for servers with Solr Search enabled.
How can I lookup the DB server using a command-line from the Xinet Administration server (master)?
Open the my.cnf and locate the following code:
host=<IP Addr> | <hostname>
This information is also found in the dblogd.conf file.
Mysql Host=<IP Addr> | <hostname> | local



Please sign in to leave a comment.