Setup for Replication Database Between Cluster

Help
1

Hi all,

I’m trying to create database replication between 2 cluster by following this link :

i’m trying with 2 method :

  • docker(cluster-in-a-box) to docker(cluster-in-a-box)
    i’m use root user with grants all privileges to all database, when running this command :

REPLICATE DATABASE newdb FROM root:‘password’@192.168.110.11:3344/newdb

i’m get this error message :

(HY000): Cannot connect to node (null)@127.0.0.1:3306 with user distributed using password: YES [1045] Access denied for user ‘distributed’@‘localhost’ (using password: YES)

  • vm(cluster-in-a-box) to vm(cluster-in-a-box)
    i’m use user with grants all privileges to all databases, when running this command :

REPLICATE DATABASE web FROM rep_test:‘QgkWbW4’@192.168.110.147:3306/web;

i’m get this eror message :

ERROR 1735 (HY000): Cannot connect to node (null)@127.0.0.1:3306 with user distributed using password: YES [2004] Cannot connect to ‘127.0.0.1’:3306. Errno=111 (Connection refused)

both method get same error message, can someone please2 help me how to setup replication between cluster

2

Same here… would like to try this feature using same setup basically. Exactly same error message.

3

Oh so sorry but i am not sure about that… Thanks !!

4

is there anyone already success with singlestore replication? please let me know how to setup and what’s singlestore version

5

already solve, by following this :