SingleStore Requirements

This section describes the requirements, access privileges, and other features of Data Source Solutions DSS when using SingleStore (formerly MemSQL) for replication.

Supported Platforms

• Learn about the SingleStore versions compatible with DSS on our Platform Support Matrix page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).

Supported Capabilities

• Discover what DSS 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 DSS 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 DSS 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

Using Authentication Plugins

DSS 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.

Related Articles

• SingleStore as Source

• SingleStore as Target

  • Staging for SingleStore

• Location Connection for SingleStore