set global consensus_auto_leader_transfer=ON;
stop xpaxos_replication;
call dbms_consensus.configure_follower("127.0.0.1:MYPORT_CONSENSUS_3", 1, 0);
use test;
create table t1(id int);
insert into t1 values(1);
call dbms_consensus.change_leader("127.0.0.1:MYPORT_CONSENSUS_2");
select role from information_schema.alisql_cluster_local;
role
Prepared
select role from information_schema.alisql_cluster_local;
role
Follower
call dbms_consensus.change_leader("127.0.0.1:MYPORT_CONSENSUS_2");
select role from information_schema.alisql_cluster_local;
role
Prepared
select role from information_schema.alisql_cluster_local;
role
Prepared
# restart
select role from information_schema.alisql_cluster_local;
role
Follower
call dbms_consensus.configure_follower("127.0.0.1:MYPORT_CONSENSUS_3", 5, 0);
drop table test.t1;