28 lines
776 B
Plaintext
28 lines
776 B
Plaintext
# start a new learner
|
|
# connect leader
|
|
call dbms_consensus.add_learner(learner_cluster_info);
|
|
select count(*) from information_schema.alisql_cluster_global where role='LEARNER';
|
|
count(*)
|
|
1
|
|
create database aaa;
|
|
use aaa;
|
|
create table t (id int);
|
|
insert into t values(1);
|
|
show databases like '%aaa%';
|
|
Database (%aaa%)
|
|
aaa
|
|
drop database aaa;
|
|
call dbms_consensus.drop_learner(learner_cluster_info);
|
|
# start a new learner
|
|
call dbms_consensus.add_follower(learner_cluster_info);
|
|
select count(*) from information_schema.alisql_cluster_global where role='FOLLOWER';
|
|
count(*)
|
|
3
|
|
create database aaa;
|
|
show databases like '%aaa%';
|
|
Database (%aaa%)
|
|
aaa
|
|
drop database aaa;
|
|
call dbms_consensus.downgrade_follower(learner_cluster_info);
|
|
call dbms_consensus.drop_learner(learner_cluster_info);
|