Graphic Hub Administrator Guide

Version 3.1 | Published July 11, 2018 ©

Resolve Pilot Data Differences Between Graphic Hubs

The Pilot differences window in the Graphic Hub Manager is used to view and resolve differences in Pilot data between two or more Graphic Hub servers. This can be the main and replication servers in a cluster environment, or other Graphic Hub servers that contain Pilot data, such as a backup server.

To Check for Pilot Data Differences

  1. In Graphic Hub Manager, log on to the servers that you want to compare.

  2. Click Pilot > Differences… to open the Pilot data differences window.

  3. Select the servers to compare in the Overview section, then click Check for differences. This compares the Pilot content on the selected servers, and you can now perform a manual backup or resolve potential cluster differences.

Understanding the Pilot Data Differences window

images/download/attachments/41793441/pilot_database_pilot_data_differences_window.png

  • Tables left/right (1): The two panes Tables left and Tables right show a listing of all database tables that are compared between the two servers.

  • Overview (2): The Overview pane provides a quick overview of the differences between two servers:

    • Drop-down menu: If the Manager is logged on to more than two servers, all servers are selectable from the drop-down menus to the left and right of the Check for differences button.

    • Check for differences: Click to compare the selected servers. This will initiate a checksum-based comparison of the table data between the servers. In the left and right panes, identical tables will be marked with a green check mark icon. Tables that differ will be marked with an orange warning icon. The Overview is populated with a summary of the differences. Any changes made after the last click will be indicated by a counter, and a timer will indicate the time passed since the latest change.

    • Lock/Unlock database: Click to lock or unlock the databases. When the database is locked, read operations are permitted, while write operations are not. Locking the databases will start a timer that shows how long the database has been locked, and the button changes to Unlock database.

      Caution: Lock & deploy overwrites content on the destination server and cannot be undone. Make sure to double check the direction of the deployment with the selected servers.

    • Lock & deploy << | >>: Use lock and deploy to lock the databases for changes and deploy any elements required to bring the two servers into identical states. The arrows indicate if the deployment will be from the right server to the left server (<<), or from left to right (>>). When clicked, a confirmation dialog appears, where you must confirm the deployment direction. A progress bar with an estimated time for the deployment is displayed during the process.

  • Table Details (3): Double click a table in the Left or Right table panes to open a detailed view of the selected table in the Details pane. Multiple tables can be opened, and will be added as separate tabs within the pane. Right clicking a table in either pane will open a context menu from which data can be loaded. Select Show differences to load only the entries that differ in the Details pane, or Show all to load all entries in the selected table. Select Lock & deploy all to lock the database on both servers, and deploy all tables from the selected server.

Scheduled Tasks

All Pilot cleanup tasks can be configured and activated via Graphic Hub Terminal. Open the Graphic Hub Terminal, then select Options -> Scheduled tasks. Scroll down the task list to find the Pilot related tasks.

Tip: In addition to the tasks described here, it is highly recommended to periodically perform a normal shutdown when using Graphic Hub as Pilot data back end. The recommended interval is once monthly.

images/download/attachments/41793441/pilot_database_pilot_terminal_scheduled_tasks.png
To enable the tasks, click Options -> Advanced settings in the Terminal and go to the CLEANUP SETTINGS pane. Check the checkboxes to enable each task:

images/download/attachments/41793441/pilot_database_pilot_terminal_enable_scheduled_tasks.png
Cleanup of Pilot data elements

Click on the task to open the configuration properties for the task:

images/download/attachments/41793441/pilot_database_pilot_terminal_scheduled_tasks_cleanup_editor.png
The following properties can be specified:

  • Start time: Define the first execution of the task.

  • Interval: Define the interval on which the task will be executed.

  • Older than: Will cleanup all elements older than the specified time span.

  • Cleanup of library elements: Check the checkbox to also include library elements during deletion.

  • Integrity cleanup: Check the checkbox to delete all rows that violates Pilot data integrity to provide data consistency.
    *Cleanup of Pilot data elements *can also be configured using the Graphic Hub Manager. However, it needs to be activated using the Graphic Hub Terminal. The Wizard will appear after a successful schema import. Refer to Key features and workflow of Graphic Hub 3 as Viz Pilot back end system for further details.

Cleanup of Pilot Changelog

Click on the task to open the configuration properties for the task:

images/download/attachments/41793441/pilot_database_pilot_terminal_scheduled_tasks_cleanup_changelog_editor.png
The following properties can be specified:

  • Start time: Define the first execution of the task.

  • Interval: Define the interval on which the task will be executed.

  • Older than: Will cleanup all elements older than the specified time span.

Graphic Hub Manager Integrity Cleanup

The Graphic Hub Manager provides a tool to perform an integrity check of Pilot data and clean data integrity violations:

  1. Click Server -> Check to open the Check Server window.

  2. In the Check section, check the Check Pilot tables checkbox:

    images/download/attachments/41793441/pilot_database_pilot_gh_manager_check_server_tables.png

    This will include a check for data consistency in the pilot tables during server check. If any violations are found, these will be listed in the Pilot Data tab:

    images/download/attachments/41793441/pilot_database_pilot_gh_manager_check_server_tables_results.png
  3. If any violations are found, click the Fix all button in the Fix panel to delete those violations:

    images/download/attachments/41793441/pilot_database_pilot_gh_manager_check_server_tables_fix_all.png

    The integrity cleanup can also be included during the execution of the data element deletion task (see Pilot Tasks on how to include it) If it is included all integrity violations will be cleared during task execution.

See Also

Multiple Graphic Hubs and Pilot Data

The *Pilot differences *dialog in the Graphic Hub Manager can be used to perform a manual backup of one server to another. However, merging the database content is not possible. The data will always be overwritten on the destination server, to ensure that the content is identical to the source.

  1. Log on to both the active and backup Graphic Hub servers.

  2. Open the Pilot differences dialog and select these servers in the overview section.

  3. Check for differences and deploy in the correct direction for backing up the data. Only the Pilot data that has been changed after the latest backup will be deployed.

Pilot Data Backup Solution

Using Graphic Hub Manager in Graphic Hub 3, Pilot data can be backed up manually to a Graphic Hub server in 5/4 Free or Multiuser mode. On the backup server, the Graphic Hub Terminal can then be used as a tool for creating full or incremental backups of the underlying data directory on Graphic Hub, using a scheduled shutdown task with backup after shutdown and server restart.

images/download/attachments/41793441/installation_gh_vcp_backup.png