--let $CHILD3_1_ENGINE_TYPE=Spider
--let $CHILD3_1_ENGINE=ENGINE=Spider
--source ../../include/init_spider.inc
eval INSERT INTO mysql.spider_link_mon_servers
(db_name, table_name, link_id, sid, server, scheme, host, port, socket,
 username, password, ssl_ca, ssl_capath, ssl_cert, ssl_cipher, ssl_key,
 ssl_verify_server_cert, default_file, default_group) VALUES
('%auto_test_local%', '%ta_l%', '%', $CHILD3_1_SERVER_ID, 's_3_1', NULL, NULL,
 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL),
('%auto_test_local%', '%ta_l%', '%', $CHILD3_2_SERVER_ID, 's_3_2', NULL, NULL,
 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL),
('%auto_test_local%', '%ta_l%', '%', $CHILD3_3_SERVER_ID, 's_3_3', NULL, NULL,
 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL);
let $CHILD3_1_CHECK_LINK_STATUS=
  SELECT db_name, table_name, link_id, link_status FROM mysql.spider_tables
  ORDER BY db_name, table_name, link_id;
let $CHILD3_1_CHECK_LINK_FAILED_LOG=
  SELECT db_name, table_name, link_id FROM mysql.spider_link_failed_log;
let $CHILD3_1_SET_RECOVERY_STATUS_2_1=
  ALTER TABLE ta_l
  CONNECTION='host "localhost", user "root", password "",
  msi "$CHILD3_1_SERVER_ID", mkd "2",
  database "auto_test_remote auto_test_remote2", lst "0 2"';
let $CHILD3_1_SET_OK_STATUS_2_1=
  ALTER TABLE ta_l
  CONNECTION='host "localhost", user "root", password "",
  msi "$CHILD3_1_SERVER_ID", mkd "2",
  database "auto_test_remote auto_test_remote2", lst "0 1"';
let $CHILD3_1_SET_OK_STATUS_AS_2_1=
  ALTER TABLE ta_l
  CONNECTION='host "localhost", user "root", password "",
  msi "$CHILD3_1_SERVER_ID", mkd "2", alc "1",
  database "auto_test_remote auto_test_remote2", lst "1 0"';

let $CHILD3_1_DROP_TABLES_HA_2_1=
  DROP TABLE IF EXISTS ta_l;
if ($VERSION_COMPILE_OS_WIN)
{
  let $CHILD3_1_CREATE_TABLES_HA_2_1=
    CREATE TABLE ta_l (
      a INT DEFAULT 10,
      b CHAR(1) DEFAULT 'c',
      c DATETIME DEFAULT '1999-10-10 10:10:10',
      PRIMARY KEY(a)
    ) $CHILD3_1_ENGINE $CHILD3_1_CHARSET
    COMMENT='port "$CHILD2_1_MYPORT $CHILD2_2_MYPORT", table "ta_r ta_r3"'
    CONNECTION='host "localhost", user "root", password "",
    msi "$CHILD3_1_SERVER_ID", mkd "2",
    database "auto_test_remote auto_test_remote2"';
  let $CHILD3_1_CREATE_TABLES_HA_AS_2_1=
    CREATE TABLE ta_l (
      a INT DEFAULT 10,
      b CHAR(1) DEFAULT 'c',
      c DATETIME DEFAULT '1999-10-10 10:10:10',
      PRIMARY KEY(a)
    ) $CHILD3_1_ENGINE $CHILD3_1_CHARSET
    COMMENT='port "$CHILD2_1_MYPORT $CHILD2_2_MYPORT", table "ta_r ta_r3"'
    CONNECTION='host "localhost", user "root", password "",
    msi "$CHILD3_1_SERVER_ID", mkd "2", alc "1",
    database "auto_test_remote auto_test_remote2"';
}
if (!$VERSION_COMPILE_OS_WIN)
{
  let $CHILD3_1_CREATE_TABLES_HA_2_1=
    CREATE TABLE ta_l (
      a INT DEFAULT 10,
      b CHAR(1) DEFAULT 'c',
      c DATETIME DEFAULT '1999-10-10 10:10:10',
      PRIMARY KEY(a)
    ) $CHILD3_1_ENGINE $CHILD3_1_CHARSET
    COMMENT='socket "$CHILD2_1_MYSOCK $CHILD2_2_MYSOCK", table "ta_r ta_r3"'
    CONNECTION='host "localhost", user "root", password "",
    msi "$CHILD3_1_SERVER_ID", mkd "2",
    database "auto_test_remote auto_test_remote2"';
  let $CHILD3_1_CREATE_TABLES_HA_AS_2_1=
    CREATE TABLE ta_l (
      a INT DEFAULT 10,
      b CHAR(1) DEFAULT 'c',
      c DATETIME DEFAULT '1999-10-10 10:10:10',
      PRIMARY KEY(a)
    ) $CHILD3_1_ENGINE $CHILD3_1_CHARSET
    COMMENT='socket "$CHILD2_1_MYSOCK $CHILD2_2_MYSOCK", table "ta_r ta_r3"'
    CONNECTION='host "localhost", user "root", password "",
    msi "$CHILD3_1_SERVER_ID", mkd "2", alc "1",
    database "auto_test_remote auto_test_remote2"';
}
let $CHILD3_1_DROP_TABLES_HA_P_2_1=
  DROP TABLE IF EXISTS ta_l2;
let $CHILD3_1_CREATE_TABLES_HA_P_2_1=
  CREATE TABLE ta_l2 (
    a INT DEFAULT 10,
    b CHAR(1) DEFAULT 'c',
    c DATETIME DEFAULT '1999-10-10 10:10:10',
    PRIMARY KEY(a)
  ) $CHILD3_1_ENGINE $CHILD3_1_CHARSET
  COMMENT='msi "$CHILD3_1_SERVER_ID", mkd "2"'
  PARTITION BY KEY(a) (
    PARTITION pt1 COMMENT='srv "s_2_1 s_2_2", tbl "ta_r ta_r3",
    priority "1000"',
    PARTITION pt2 COMMENT='srv "s_2_1 s_2_3", tbl "ta_r2 ta_r4",
    priority "1000001"'
  );
let $CHILD3_1_CREATE_TABLES_HA_AS_P_2_1=
  CREATE TABLE ta_l2 (
    a INT DEFAULT 10,
    b CHAR(1) DEFAULT 'c',
    c DATETIME DEFAULT '1999-10-10 10:10:10',
    PRIMARY KEY(a)
  ) $CHILD3_1_ENGINE $CHILD3_1_CHARSET
  COMMENT='msi "$CHILD3_1_SERVER_ID", mkd "2", alc "1"'
  PARTITION BY KEY(a) (
    PARTITION pt1 COMMENT='srv "s_2_1 s_2_2", tbl "ta_r ta_r3",
    priority "1000"',
    PARTITION pt2 COMMENT='srv "s_2_1 s_2_3", tbl "ta_r2 ta_r4",
    priority "1000001"'
  );
let $CHILD3_1_SET_RECOVERY_STATUS_P_2_1=
  ALTER TABLE ta_l2
  PARTITION BY KEY(a) (
    PARTITION pt1 COMMENT='srv "s_2_1 s_2_2", tbl "ta_r ta_r3",
    priority "1000"',
    PARTITION pt2 COMMENT='srv "s_2_1 s_2_3", tbl "ta_r2 ta_r4",
    priority "1000001", lst "0 2"'
  );
let $CHILD3_1_SET_OK_STATUS_P_2_1=
  ALTER TABLE ta_l2
  PARTITION BY KEY(a) (
    PARTITION pt1 COMMENT='srv "s_2_1 s_2_2", tbl "ta_r ta_r3",
    priority "1000"',
    PARTITION pt2 COMMENT='srv "s_2_1 s_2_3", tbl "ta_r2 ta_r4",
    priority "1000001", lst "0 1"'
  );
let $CHILD3_1_SET_OK_STATUS_AS_P_2_1=
  ALTER TABLE ta_l2
  PARTITION BY KEY(a) (
    PARTITION pt1 COMMENT='srv "s_2_1 s_2_2", tbl "ta_r ta_r3",
    priority "1000"',
    PARTITION pt2 COMMENT='srv "s_2_1 s_2_3", tbl "ta_r2 ta_r4",
    priority "1000001", lst "1 0"'
  );
