SingleStore Requirements
This section describes the requirements, access privileges, and other features of Fivetran HVR when using SingleStore (formerly MemSQL) for replication.
Supported Platforms
- Learn about the SingleStore versions compatible with HVR on our Platform Support Matrix page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).
Supported Capabilities
- Discover what HVR offers for SingleStore on our Capabilities for SingleStore page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).
Data Management
Learn how HVR maps data types between source and target DBMSes or file systems on the Data Type Mapping page. For the list of the supported SingleStore data types and their mapping, see Data Type Mapping for SingleStore.
Understand the character encodings HVR supports for SingleStore on the Supported 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.