Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

create sequences table in kunlun_sysdb #10

Open
jd-zhang opened this issue Nov 22, 2021 · 1 comment
Open

create sequences table in kunlun_sysdb #10

jd-zhang opened this issue Nov 22, 2021 · 1 comment

Comments

@jd-zhang
Copy link
Contributor

Issue migrated from trac ticket # 237

component: kunlun-storage | priority: major

2021-11-22 10:15:04: @david-zhao created the issue


In kunlun-storage-8.0.26, create the kunlun_sysdb database when installing a kunlun-storage instance, and create the heartbeat table and the below sequences table in kunlun_sysdb.

CREATE TABLE IF NOT EXISTS sequences( db varchar(512) not null, name varchar(512) not null, curval bigint not null, start bigint not null, step int not null, max_value bigint not null, min_value bigint not null, do_cycle bool not null, n_cache int unsigned not null, primary key(db,name) ) engine=innodb CHARACTER SET utf8 COLLATE utf8_general_ci STATS_PERSISTENT=0 comment='Kunlun sequence metadata used by computing nodes.' ROW_FORMAT=DYNAMIC

@jd-zhang
Copy link
Contributor Author

2021-11-22 10:15:59: @david-zhao edited the issue description

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants