SingleStore Requirements
This section describes the requirements, access privileges, and other features of Fivetran HVR when using SingleStore (formerly MemSQL) for replication.
For information about compatibility and supported versions of SingleStore with HVR platforms, see Supported Platforms.
For the Capabilities supported by HVR on SingleStore, see Capabilities for SingleStore.
For information about the supported data types and mapping of data types in source DBMS to the corresponding data types in target DBMS or file format, see Data Type Mapping.
For the character encodings supported by HVR on SingleStore, see the Character Encodings page.
SingleStore Server Time Zone
To use the timestamp data type in SingleStore database, the SingleStore server's time zone must be set to UTC or +00:00 using the default_time_zone configuration parameter. For more information about setting the time zone, refer to Setting the Time Zone in SingleStore documentation.
For example, to set the time zone to UTC on a host, run the command:
sdb-admin update-config --key default_time_zone --value "+00:00" --all
While updating a time zone on a host, it is required to update it identically on all hosts in the cluster and then the cluster must be restarted.
Using Authentication Plugins
HVR supports using MariaDB authentication plugins for user authentication. For more information about authentication plugins, refer to the Authentication Plugins section in the MariaDB documentation. To use authentication plugins installed in a custom directory, you must define the environment variable MARIADB_PLUGIN_DIR. You can define this environment variable using the action Environment with parameters Name=MARIADB_PLUGIN_DIR and Value=path_to_directory.