Contact your MemSQL AE or SE if you are interested in using the replicate tool.
Replicate does not require Administrator privileges to install or run, and can be installed via the following steps:
Create a working directory for Replicate on your machine.
Download the ZIP file of the release (
replicate-cli-<version>.zip) into the working directory.
Extract the contents of
replicate-cli-<version>.zipinto the working directory. This working directory (
replicate-cli) is Replicate’s
Place the license file (
replicate.lic) in Replicate’s
HOMEdirectory. Note: Do not rename or modify the license file.
Sample configuration, filter, and mapper files are included with the Replicate ZIP file in the following folders:
replicate-cli/ ├── conf ← Configuration files │ ├── dst ← Applier configuration file │ │ └── applier.yaml │ ├── conn ← Database connection files │ │ ├── memsql.yaml │ │ ├── oracle.yaml │ └── src ← Extractor files │ ├── memsql.yaml │ └── oracle.yaml ├── filter ← Filter files │ ├── filter_example.yaml │ └── filter_format.yaml └── mapper ← Mapper files ├── mapper_example.yaml └── mapper_format.yaml
Note: The connection (
conn) config files can be reused when both the source and the destination databases are the same. For example, to replicate databases from A → B → C, where database B is the destination of the first replication and also the source of the second replication, the same
conn configuration file can be used.
Change to Replicate’s
./bin/replicate COMMAND [parameters]
To resume Replicate, run:
./bin/replicate COMMAND [parameters] --resume
To check the Replicate version, run:
Refer to the Quick Start section to learn more about the various files and their options that you may use to replicate data into MemSQL, and to use Replicate’s configurator command-line utility to automatically configure them.
You may also review the Reference section to learn more about these files and their options prior to using Replicate’s configurator.