27 lines
812 B
Plaintext
27 lines
812 B
Plaintext
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;
|