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_<version>.zip) into the working directory.
Extract the contents of
replicate_<version>.zipinto the working directory. This working directory (
replicate_<version>) 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 MemSQL Replicate ZIP file in the following folders:
replicate-cli/ ├── conf ← Configuration files │ ├── applier ← Applier configuration file │ │ └── applier.yaml │ ├── conn ← Database connection files │ │ ├── memsql.yaml │ │ ├── oracle.yaml │ └── extractor ← 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