31 lines
1.4 KiB
Plaintext
31 lines
1.4 KiB
Plaintext
#
|
|
# 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;
|