Data Center Replication from GridGain 8

-- List all indexes for a specific table
SELECT * FROM SYS.INDEXES
WHERE SCHEMA_NAME = 'PUBLIC' AND TABLE_NAME = 'PERSON';

./bin/control.sh --cache idle_verify --dump --cache-filter PERSON

-- Example: recreating indexes for the PERSON table
CREATE INDEX idx_person_age ON PERSON(AGE);
CREATE INDEX idx_person_name ON PERSON(NAME);
CREATE INDEX idx_person_salary_region ON PERSON(SALARY, REGION);

dr-service-config = {
  cacheMapping = [
    # Only one mapping at a time is supported.
    # Mapping for key and value object fields to distinct columns.
    {
      cache = "cacheName"
      table = "schemaName.tableName"
      keyFields = [
        { field = "key1", column = "C1" }
        { field = "key2", column = "C2" }
        { field = "key3", column = "C3" }
        { field = "key4", column = "ignored_column", ignore = true }
      ]
      valueFields = [
        { field = "value1", column = "C4" }
        { field = "value2", column = "ignored_column", ignore = true }
      ]
    }

#    # Alternative mapping.
#    # The fields option maps fields to columns regardless of if they are key of value fields.
#    {
#      cache = "cacheName"
#      table = "schemaName.tableName"
#      fields = [
#        { field = "_key", column = "ID" }
#        { field = "field1", column = "C1" }
#        { field = "field2", column = "C2" }
#        { field = "field3", column = "ignored_column", ignore = true }
#      ]
#    }
  ]

  clientConfiguration = {
    serverEndpoints = [ "127.0.0.1:10800" ]
    port = 10800
    connectTimeout = 0
    metricsEnabled = false
    name = "drClient"
    heartbeatInterval = 30000
    heartbeatTimeout = 5000
    backgroundReconnectInterval = 30000

    ssl = {
      enabled = false
      ciphers = ""
      keyStore = {
        password = ""
        path = ""
        type = "PKCS12"
      }
      trustStore = {
        password = ""
        path = ""
        type = "PKCS12"
      }
    }

    authenticator = {
      type = "BASIC"
      identity = "<user>"
      secret = "<password>"
    }
  }

  drReceiverConfiguration = {
    dataCenterId = 1
    inboundHost = ""
    inboundPort = 10800
    drReceiverMetricsEnabled = true
    idleTimeout = 60000
    ignoreMissingTable = true
    selectorCnt = 4
    socketReceiveBufferSize = 0
    socketSendBufferSize = 0
    tcpNodelay = true
    tombstoneTtl = 1800000
    workerThreads = 10
    writeTimeout = 60000
    ssl = {
      enabled = false
      clientAuth = "none"
      ciphers = ""
      keyStore = {
        password = ""
        path = ""
        type = "PKCS12"
      }
      trustStore = {
        password = ""
        path = ""
        type = "PKCS12"
      }
    }
  }

  timeZone = "Europe/Berlin"
}

dr-service-config = {
  cacheMapping = [
    {
      cache = "cacheName"
      table = "schemaName.tableName"
      keyFields = [
        { field = "K1", column = "COL_1" }
        { field = "K2", column = "COL_2" }
        { field = "K3", column = "COL_3" }
        { field = "K4", column = "ignored_column", ignore = true }
      ]
      valueFields = [
        { field = "V1", column = "COL_4" }
        { field = "V2", column = "COL_5" }
        { field = "V3", column = "COL_6" }
        { field = "V4", column = "ignored_column", ignore = true }
      ]
    }
  ]
}

dr-service-config = {
  cacheMapping = [
    {
      cache = "cacheName1"
      table = "cacheName1"
      keyFields = [
        # This example is valid.
        { field = "_key", column = "ID" }

        # The example below would not work.
        #{ field = "id", column = "ID" }
      ]
      valueFields = [
        { field = "name", column = "NAME" }
        { field = "age", column = "AGE" }
      ]
    }
  ]
}

dr-service-config = {
  cacheMapping = [
    {
      cache = "cacheName1"
      table = "cacheName1"
      keyFields = [
        { field = "USERID", column = "USERID" }
        { field = "CITYID", column = "CITYID" }
      ]
      valueFields = [
        # This example is valid.
        { field = "_val", column = "NAME" }

        # This example would not work
        # { field = "AGE", column = "AGE" }
      ]
    }
  ]
}

dr-service-config = {
  cacheMapping = [
    {
      cache = "cacheName2"
      table = "cacheName2"
      keyFields = [
        { field = "_key", column = "ID" }
      ]
      valueFields = [
        { field = "name", column = "NAME" }
        { field = "age", column = "AGE" }
        # Ignore the duplicate.
        { field = "id", column = "", ignore = true }
      ]
    }
  ]
}

# Via control script
./bin/control.sh --dr full-state-transfer start --caches cacheName --sender-group grp1 --data-centers 2 --yes

<bean class="org.gridgain.grid.configuration.GridGainConfiguration">
    <!-- This parameter must match the drReceiverConfiguration.datacenterId parameter. -->
    <property name="dataCenterId" value="1"/>
    ...
</bean>

A sender hub has successfully connected to a remote receiver

./bin/control.sh --dr cache cacheName --action full-state-transfer --yes