search

zettadb / kunlun-storage-081809

Kunlun-storage is the storage component for Kunlun distributed DBMS. It's developed based on percona-mysql-8.0.x and contains exclusive features used by Kunlun distributed DBMS, performance enhancements and XA transaction crash safety enhancements without which MySQL would not be able to execute XA transactions reliably.
Other
31 stars 6 forks source link

create sequences table in kunlun_sysdb #10

Open jd-zhang opened 3 years ago

jd-zhang commented 3 years ago

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 commented 3 years ago

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