Replicate relies on a series of YAML-based configuration files to copy data from a source database to a destination database. Given the level of control these configuration files afford, crafting them by hand can sometimes become time-consuming.
The Replicate configurator is a command-line utility that is an alternative to creating the desired Replicate configuration YAML files by hand. It requires Java 8 to connect to databases and create configuration files, and supports Oracle, PostgreSQL, MySQL, and MemSQL as a source, and only MemSQL as target.
The configurator offers the following options:
|1. Source connection||Creates connection details for a source database.|
|2. Destination connection||Creates connection details for a MemSQL database.|
|3. Extractor||Creates an extractor configuration file that can be used to fine-tune Replicate’s behavior when retrieving data from a source.|
|4. Applier||Creates an applier configuration file that can be used to fine-tune Replicate’s behavior when applying changes to MemSQL.|
|5. Filter||Creates a filter file that can be used to replicate only a specified subset of source data.|
|6. Mapper||Creates a mapper file that can be used to precisely define how the source data is applied to the destination.|
|7. Command Line||Generates the command that can be used to run Replicate based on the information provided in the above options. Note: Change to Replicate’s
|0. Exit||Exits the configurator.|
Similar to Replicate, the configurator requires Java 8 to connect to databases and create configuration files.
Run the Configurator
Change to the configurator’s
In the configurator’s
Sample Configurator Files
Below are sample files generated by the configurator.
type: ORACLE host: localhost port: 1521 service-name: ORCL username: REPLICATE password: Replicate#123 max-connections: 30
type: MEMSQL host: localhost port: 3306 username: "replicate" password: "Replicate#123" max-connections: 30
type: MEMSQL host: localhost port: 3306 username: replicate password: Replicate#123 max-connections: 30
Replicate’s logs are stored in one of two directories in the Replicate
If an instance name has not been assigned to Replicate:
If an instance name has been assigned to Replicate via
The trace log is the best place to troubleshoot any errors experienced when running Replicate. The error messages written to this log will typically provide the required level of information to effectively troubleshoot an issue.