# # TODO may need more check # --source include/paxos.inc select SERVER_ID,ROLE,FORCE_SYNC,ELECTION_WEIGHT from information_schema.alisql_cluster_global; #CHANGE CONSENSUS_NODE 1 CONSENSUS_FORCE_SYNC true CONSENSUS_ELECTION_WEIGHT 9; --replace_result $PAXOS_PORT_1 PAXOS_PORT_1 eval call dbms_consensus.configure_follower("127.0.0.1:$PAXOS_PORT_1", 9, 1); #CHANGE CONSENSUS_NODE 3 CONSENSUS_FORCE_SYNC false CONSENSUS_ELECTION_WEIGHT 1; --replace_result $PAXOS_PORT_3 PAXOS_PORT_3 eval call dbms_consensus.configure_follower("127.0.0.1:$PAXOS_PORT_3", 1, 0); select SERVER_ID,ROLE,FORCE_SYNC,ELECTION_WEIGHT from information_schema.alisql_cluster_global; --connect (conn1,127.0.0.1,root,,test,$MYPORT_1) --connection conn1 #change consensus_leader to 3; --replace_result $PAXOS_PORT_3 PAXOS_PORT_3 eval call dbms_consensus.change_leader("127.0.0.1:$PAXOS_PORT_3"); --sleep 1 --connect (conn3,127.0.0.1,root,,test,$MYPORT_3) --connection conn3 let $wait_condition= select count(*)=1 from information_schema.alisql_cluster_local where role='No Role'; --source include/wait_condition.inc select role from information_schema.alisql_cluster_local; --connect (conn1_1,127.0.0.1,root,,test,$MYPORT_1) --connection conn1_1 let $wait_condition= select count(*)=1 from information_schema.alisql_cluster_local where role='leader'; --source include/wait_condition.inc --sleep 1 select role from information_schema.alisql_cluster_local;