SingleStore Requirements

This section describes the requirements, access privileges, and other features of Fivetran Local Data Processing when using SingleStore (formerly MemSQL) for replication.

For information about compatibility and supported versions of SingleStore with Local Data Processing platforms, see .

For the supported by Local Data Processing on SingleStore, see .

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 .

For the character encodings supported by Local Data Processing on SingleStore, see the 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 configuration parameter. For more information about setting the time zone, refer to in .

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
content_copy

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.

Related Articles