SingleStore Replicate

Overview

SingleStore Replicate is a tool for transferring data from a wide variety of heterogeneous databases into SingleStore Helios. It provides a number of features and functions to tailor how the data is replicated, and offers:

• A command-line interface for installation, configuration, and use

• Importing data from certain sources, notably Oracle, via a transaction-consistent point-in-time snapshot

• Customizable filters and maps to tailor the replicated data

• SQL 2017, 2016, and 2014 standards compliance

To best take advantage of SingleStore Helios’s flexibility and scalability, data in existing databases can now be moved into SingleStore Helios, allowing data-driven applications to work with minimal changes to either code or data. This capability is especially important when the requirements of the original application have grown beyond the ability to scale the current database, or the database system product hosting the original database has simply become too costly to scale.

Supported Data Sources

SingleStore Replicate supports data transfer from the following sources into SingleStore Helios:

• AWS Aurora

• Cassandra

• DB2 (IBM)

• Hana (SAP)

• MemSQL v6.0 and later

• MongoDB®

• MySQL

• Netezza

• Oracle Enterprise Edition (EE) including Compression and Partitioning and Real Application Workspaces (RAC)

• PostgreSQL v9.4 and later

• Salesforce

• SQL Server (Microsoft)

• Teradata

• Vertica

Capabilities and Benefits

Replicate supports high-performance ingest using a parallel, distributed architecture that reduces labor and speeds data transfer, which decreases the time it takes to complete complex data transfer jobs from weeks down to days. Replicate’s benefits grow as the complexity of the data transfer increases.

System Requirements

Physical or virtual machines configured for high performance will make Replicate achieve maximum scaling and replication throughput. An example hardware configuration that typically works well for Replicate consists of:

• A multi-core 32/64-bit CPU with 128GB memory

• A minimum of 400-500GB (SSDs/NVMe) of free storage

• A current Linux version (Red Hat/CentOS/Ubuntu)

• Java 8 or later installed (via the JRE or JDK)

A fast network connection with provisioned redundancies at all points of failure will offer the best performance, reliability, and lowest latency for replication.

As Replicate is Java-based, it may be possible, though not guaranteed, to work on other operating systems that can run Java SE Runtime Environment 8. Support for other operating systems is planned for future releases.

Obtain Replicate Software and Documentation

SingleStore Replicate is available to all customers who have purchased the SingleStore Helios database or SingleStore Helios. To obtain the SingleStore Replicate software and full documentation, contact your SingleStore sales representative, or SingleStore support.