Capabilities for Aurora MySQL

From HVR
Jump to: navigation, search

This section describes the capabilities supported by HVR on Aurora MySQL.

Capture

HVR supports the following capabilities on Aurora MySQL:

  • Capture changes from location (Aurora MySQL since HVR 5.3.1/25)
  • Log-based capture (capture from DBMS logging system)
  • Log-based capture of tables without a primary key
  • Direct access to logs on a file system
  • Access to logs using SQL interface
  • Log-based capture with /LogReadMethod param
  • Log-based capture of tables with LOB column
  • Rewind log-based capture to specific time (hvrinit option -i)
  • Online refresh using accurate LSN/SCN
  • Log-based capture of truncate table statements
  • Multiple log-based capture jobs can capture from same database
  • Capture from tables with any compression


HVR does not support the following capabilities on Aurora MySQL:

  • Log-based capture from hidden rowid column (ColumnProperties /CaptureFromRowId)
  • Rewind log-based capture to the beginning of currently active oldest transaction
  • Populates column hvr_cap_user for use in ColumnProperties {hvr_cap_user} substitutions
  • Log-based capture checkpointing (action Capture /CheckpointingFrequency)
  • hvrlogrelease to preserve journal/archives
  • Read archives from an alternative directory (Capture /ArchiveLogPath)
  • Trigger-based capture (action Capture /TriggerBased)


HVR Hub

HVR supports Hub database (Aurora MySQL since HVR 5.3.1/25)


Integrate

HVR supports the following capabilities on Aurora MySQL:

  • Integrate changes into location (Aurora MySQL since HVR 5.3.1/25)
  • Integrate with /Burst
  • Integrate with /BurstCommitFrequency
  • Continuous integration (Integrate without /Burst)
  • Action TableProperties with /DuplicateRows for continuous integration
  • Continuous integrate with /OnErrorSaveFailed (without /Burst)
  • Action Transform /SoftDelete
  • Bulk load requires a staging area (LocationProperties /StagingDirectoryHvr)
  • Creation and update of HVR state tables


HVR does not support the following capabilities on Aurora MySQL:

  • Disable/enable database triggers during integrate (/NoTriggerFiring)
  • Integrate with /DbProc


Bi-directional Replication

HVR supports the following capabilities on Aurora MySQL:

  • Detection of changes made by HVR in a bidirectional channel to prevent loop-back (Aurora MySQL since HVR 5.3.1/25)
  • Collision Detect with /TimestampColumn (Aurora MySQL since HVR 5.3.1/25)


HVR does not support the following capabilities on Aurora MySQL:


Refresh and Compare

HVR supports the following capabilities on Aurora MySQL:

  • Refresh or Compare from source location (Aurora MySQL since HVR 5.3.1/25)
  • Refresh into target location
  • Row-wise refresh into target location (option -g)


Other Capabilities

HVR supports the following capabilities on Aurora MySQL:

  • Treat DBMS table names and columns case sensitive (action LocationProperties /CaseSensitiveNames) (Aurora MySQL since HVR 5.3.1/25)


HVR does not support the following capabilities on Aurora MySQL:

  • Use distribution key for parallelizing changes within a table (ColumnProperties /DistributionKey)
  • International table and column names where DBMS is not configured with UTF-8 encoding
  • Lossless binary float datatypes. No dataloss when transporting float values (because base 2 fractions are never converted to base 10)