Capabilities for MariaDB

This section lists the Capabilities of Fivetran HVR when using 'MariaDB'. For more information about the pre-requisites, access privileges, and other configuration requirements, see MariaDB Requirements.

Capture

HVR supports the following capabilities on MariaDB:

• Capture changes from location (MariaDB from version 10.0 to version 10.11).
• Log-based capture (capture from DBMS logging system) (MariaDB from version 10.0 to version 10.11).
• Log-based capture of tables without a primary key (MariaDB from version 10.0 to version 10.11).
• Direct access to logs on a file system (MariaDB from version 10.0 to version 10.11, except on Amazon RDS for MariaDB, and Microsoft Azure Database for MariaDB).
• Access to logs using SQL interface (MariaDB from version 10.0 to version 10.11).
• Log-based capture of tables with LOB column (MariaDB from version 10.0 to version 10.11).
• Rewind log-based capture to specific time (hvractivate option -i) (MariaDB from version 10.0 to version 10.11).
• Online refresh using accurate LSN/SCN (MariaDB from version 10.0 to version 10.11).
• Log-based capture of truncate table statements (MariaDB from version 10.0 to version 10.11).
• Multiple log-based capture jobs can capture from same database (MariaDB from version 10.0 to version 10.11).
• Capture from tables with any compression (MariaDB from version 10.0 to version 10.11).

HVR does not support the following capabilities on MariaDB:

• Capture from Archive log files only.
• Log-based capture from hidden rowid/RRN column (ColumnProperties with parameter 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 using location property Capture_Checkpoint_Frequency.
• Read archives from an alternative directory (location property Archive_Log_Path on the capture location).
• Trigger-based capture (location property Capture_Method=DB_TRIGGER on the capture location).

Repository Database

HVR supports Repository database on MariaDB.

Integrate

HVR supports the following capabilities on MariaDB:

• Integrate changes into location (MariaDB from version 10.0 to version 10.11).
• Burst integration (Integrate with parameter Method=BURST) (MariaDB from version 10.0 to version 10.11).
• Integrate with parameter BurstCommitFrequency (MariaDB from version 10.0 to version 10.11).
• Continuous integration (Integrate with parameter Method=CONTINUOUS) (MariaDB from version 10.0 to version 10.11).
• Tables without a key and without TableProperties with NoDuplicateRows for continuous integration (MariaDB from version 10.0 to version 10.11).
• Continuous integrate with parameter OnErrorSaveFailed (MariaDB from version 10.0 to version 10.11).
• ColumnProperties with parameter SoftDelete (MariaDB from version 10.0 to version 10.11).
• Bulk load requires a staging area (location property Staging_Directory) (MariaDB from version 10.0 to version 10.11).
• Creation and update of HVR state tables (MariaDB from version 10.0 to version 10.11).

HVR does not support the following capabilities on MariaDB:

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

Bi-directional Replication

HVR supports the following capabilities on MariaDB:

• Detection of changes made by HVR in a bidirectional channel to prevent loop-back (MariaDB from version 10.0 to version 10.11).
• CollisionDetect with parameter TimestampColumn (MariaDB from version 10.0 to version 10.11).

HVR does not support the following capabilities on MariaDB:

• CollisionDetect with Log-based Capture (without parameter TimestampColumn).

Refresh and Compare

HVR supports the following capabilities on MariaDB:

• hvrrefresh or hvrcompare from source location (MariaDB from version 10.0 to version 10.11).
• hvrrefresh into target location (MariaDB from version 10.0 to version 10.11).
• Row-wise hvrrefresh into target location (option -g) (MariaDB from version 10.0 to version 10.11).

Other Capabilities

HVR supports the following capabilities on MariaDB:

• Call database procedure dbproc during replication jobs (AgentPlugin with parameter DbProc) (MariaDB from version 10.0 to version 10.11).
• International table and column names where DBMS is not configured with UTF-8 encoding (MariaDB from version 10.0 to version 10.11).
• Always treat DBMS table names and column names as case sensitive, even if not configured (equivalent to location property Case_Sensitive_Names always set to TRUE) (MariaDB from version 10.0 to version 10.11).
• Always treat DBMS schema names case sensitive (MariaDB from version 10.0 to version 10.11).

HVR does not support the following capabilities on MariaDB:

• Use distribution key for parallelizing changes within a table (ColumnProperties with parameter DistributionKey).
• Lossless binary float datatypes. No data loss when transporting float values (because base 2 fractions are never converted to base 10). The values for these datatypes, when selected back from the database, might be slightly different from the ones that were inserted. This leads to Compare differences..