Capabilities for Ingres

From HVR
Jump to: navigation, search

This section describes the capabilities supported by HVR on Ingres. For more information about the requirements, access privileges, and other features of HVR when using Aurora MySQL for replication, see Requirements for Ingres and Vector.

Capture

HVR supports the following capabilities on Ingres:

  • Capture changes from location (Ingres version 9.1 and above)
  • Log-based capture (capture from DBMS logging system) (Ingres version 9.1 and above)
  • Log-based capture of tables without a primary key (Ingres version 9.1 and above)
  • Direct access to logs on a file system (Ingres version 9.1 and above)
  • Log-based capture of tables with LOB column (Ingres version 9.1 and above)
  • Rewind log-based capture to specific time (hvrinit option -i) (Ingres version 9.1 and above)
  • Populates column hvr_cap_user for use in ColumnProperties {hvr_cap_user} substitutions (Ingres version 9.1 and above)
  • Log-based capture of truncate table statements (Ingres version 9.1 and above)
  • Multiple log-based capture jobs can capture from same database (Ingres version 9.1 and above)
  • Capture from tables with compression=data (Ingres version 9.1 and above)
  • Capture from tables with compression=hidata (Ingres version 9.1 and above)
  • Log-based capture checkpointing (action Capture /CheckpointingFrequency) (Ingres version 9.1 and above)
  • hvrlogrelease to preserve journal/archives (Ingres version 9.1 and above)
  • Trigger-based capture (action Capture /TriggerBased) (Ingres version 9.1 and above)
  • Capture /QuickToggle (Ingres version 9.1 and above)
  • Boundaries between transactions preserved by trigger-based capture (Ingres version 9.1 and above)
  • Trigger-based capture jobs can be woken by db-event when change happens (Ingres version 9.1 and above)


HVR does not support the following capabilities on Ingres:

  • Log-based capture of DDL statements using action AdaptDDL
  • Access to logs using SQL interface
  • Log-based capture from hidden rowid column (ColumnProperties /CaptureFromRowId)
  • Rewind log-based capture to the beginning of currently active oldest transaction
  • Online refresh using accurate LSN/SCN
  • Read archives from an alternative directory (Capture /ArchiveLogPath)


HVR Hub

HVR supports Hub database (Ingres version 9.1 and above)


Integrate

HVR supports the following capabilities on Ingres:

  • Integrate changes into location (Ingres version 9.1 and above)
  • Integrate with /Burst (Ingres version 9.1 and above)
  • Integrate with /BurstCommitFrequency (Ingres version 9.1 and above)
  • Continuous integration (Integrate without /Burst) (Ingres version 9.1 and above)
  • Action TableProperties with /DuplicateRows for continuous integration (Ingres version 9.1 and above)
  • Continuous integrate with /OnErrorSaveFailed (without /Burst) (Ingres version 9.1 and above)
  • Disable/enable database triggers during integrate (/NoTriggerFiring) (Ingres version 9.1 and above)
  • Action Transform /SoftDelete (Ingres version 9.1 and above)
  • Creation and update of HVR state tables
  • Integrate with /DbProc (Ingres version 9.1 and above)


Bi-directional Replication

HVR supports the following capabilities on Ingres:

  • Detection of changes made by HVR in a bidirectional channel to prevent loop-back (Ingres version 9.1 and above)
  • Collision Detect with Log-based Capture (without /TimestampColumn) (Ingres version 9.1 and above)
  • Collision Detect with Trigger-based Capture (with Capture /TriggerBased and without Collision Detect /TimestampColumn) (Ingres version 9.1 and above)
  • Collision Detect with /TimestampColumn (Ingres version 9.1 and above)


Refresh and Compare

HVR supports the following capabilities on Ingres:

  • Refresh or Compare from source location
  • Refresh into target location
  • Row-wise refresh into target location (option -g)
  • Disable/enable foreign keys and secondary indices during refresh (option -F)
  • For a table: disable/enable journaling, disable/enable unique/primary constraints, disable/enable volatile secondary indices, support main storage structure during refresh
  • Replicate database sequences (using action DbSequence) (Ingres version 9.1 and above)


HVR does not support the following capabilities on Ingres:


Other Capabilities

HVR supports the following capabilities on Ingres:

  • Call database procedure dbproc during replication jobs (action AgentPlugin /DbProc) (Ingres version 9.1 and above)
  • DbObjectGeneration with /IncludeSQLFile (Ingres version 9.1 and above)
  • International table and column names where DBMS is not configured with UTF-8 encoding
  • Treat DBMS table names and columns case sensitive (action LocationProperties /CaseSensitiveNames)


HVR does not support the following capabilities on Ingres:

  • Use distribution key for parallelizing changes within a table (ColumnProperties /DistributionKey)