--source include/paxos.inc --connect (leader,127.0.0.1,root,,test,$MYPORT_1) let $learner_base_port = query_get_value("select $MYPORT_1+50 as c1", c1, 1); # learner 100 --source include/start_new_learner.inc let $learner_cluster_info_100 = $learner_cluster_info; --echo # connect leader --connection leader #eval add consensus_learner $learner_cluster_info; --replace_result $learner_cluster_info learner_cluster_info eval call dbms_consensus.add_learner($learner_cluster_info); let $learner_base_port = query_get_value("select $MYPORT_1+51 as c1", c1, 1); # learner 101 --source include/start_new_learner.inc --echo # connect leader --connection leader #eval add consensus_learner $learner_cluster_info; --replace_result $learner_cluster_info learner_cluster_info eval call dbms_consensus.add_learner($learner_cluster_info); #change consensus_node 100 consensus_learner_source 2; --replace_result $learner_cluster_info_100 learner_cluster_info_100 $PAXOS_PORT_2 PAXOS_PORT_2 eval call dbms_consensus.configure_learner($learner_cluster_info_100, "127.0.0.1:$PAXOS_PORT_2"); #change consensus_node 101 consensus_learner_source 100; --replace_result $learner_cluster_info learner_cluster_info $learner_cluster_info_100 learner_cluster_info_100 eval call dbms_consensus.configure_learner($learner_cluster_info, $learner_cluster_info_100); select server_id, role, learner_source from information_schema.alisql_cluster_global; #drop consensus_learner "$learner_cluster_info_100"; --replace_result $learner_cluster_info_100 learner_cluster_info_100 eval call dbms_consensus.drop_learner($learner_cluster_info_100); #drop consensus_learner "$learner_cluster_info"; --replace_result $learner_cluster_info learner_cluster_info eval call dbms_consensus.drop_learner($learner_cluster_info); # cleanup let $learner_base_port = query_get_value("select $MYPORT_1+50 as c1", c1, 1); --source include/stop_new_learner.inc let $learner_base_port = query_get_value("select $MYPORT_1+51 as c1", c1, 1); --source include/stop_new_learner.inc