23 lines
806 B
Plaintext
23 lines
806 B
Plaintext
select server_id, role from information_schema.alisql_cluster_local where role='leader';
|
|
server_id role
|
|
1 Leader
|
|
select server_id, voted_for, role from information_schema.alisql_cluster_local;
|
|
server_id voted_for role
|
|
2 1 Follower
|
|
create table t1(id int);
|
|
insert into t1 values (1);
|
|
insert into t1 values (2);
|
|
insert into t1 values (3);
|
|
insert into t1 values (4);
|
|
insert into t1 values (5);
|
|
# restart: --cluster-start-index=LOGINDEX
|
|
insert into t1 values (6);
|
|
select count(distinct(match_index)) from information_schema.alisql_cluster_global where server_id <= 3;
|
|
count(distinct(match_index))
|
|
2
|
|
call dbms_consensus.change_leader("127.0.0.1:PAXOS_PORT_1");
|
|
select count(distinct(match_index)) from information_schema.alisql_cluster_global where server_id <= 3;
|
|
count(distinct(match_index))
|
|
1
|
|
drop table t1;
|