34 lines
852 B
Plaintext
34 lines
852 B
Plaintext
create table t1(id int);
|
|
insert into t1 values (1);
|
|
flush logs;
|
|
insert into t1 values (2);
|
|
flush logs;
|
|
insert into t1 values (3);
|
|
show consensus logs;
|
|
Log_name File_size Start_log_index
|
|
master-bin.000001 # #
|
|
master-bin.000002 # #
|
|
master-bin.000003 # #
|
|
call dbms_consensus.purge_log(100);
|
|
flush logs;
|
|
insert into t1 values (4);
|
|
flush logs;
|
|
insert into t1 values (5);
|
|
flush logs;
|
|
insert into t1 values (6);
|
|
flush logs;
|
|
insert into t1 values (7);
|
|
insert into t1 values (8);
|
|
# start a new learner
|
|
call dbms_consensus.add_learner(learner_cluster_info);
|
|
insert into t1 values (9);
|
|
insert into t1 values (10);
|
|
insert into t1 values (11);
|
|
insert into t1 values (12);
|
|
select ROLE from information_schema.alisql_cluster_global where role='LEARNER';
|
|
ROLE
|
|
Learner
|
|
drop table t1;
|
|
select ROLE from information_schema.alisql_cluster_global where role='LEARNER';
|
|
ROLE
|