DB commands to create logical shards

Logical Shard 1

create database KVStore; CREATE TABLE KVStore.KVTable ( k VARCHAR(255) NOT NULL, val MEDIUMTEXT NOT NULL, expires_at DATETIME NOT NULL, PRIMARY KEY (k) ); ALTER TABLE KVStore.KVTable ADD COLUMN is_deleted TINYINT(1) NOT NULL DEFAULT 0;

Logical Shard 2

create database KVStore2; CREATE TABLE KVStore2.KVTable ( k VARCHAR(255) NOT NULL, val MEDIUMTEXT NOT NULL, expires_at DATETIME NOT NULL, PRIMARY KEY (k) ); ALTER TABLE KVStore2.KVTable ADD COLUMN is_deleted TINYINT(1) NOT NULL DEFAULT 0;

Logical Shard 3

create database KVStore3; CREATE TABLE KVStore3.KVTable ( k VARCHAR(255) NOT NULL, val MEDIUMTEXT NOT NULL, expires_at DATETIME NOT NULL, PRIMARY KEY (k) ); ALTER TABLE KVStore3.KVTable ADD COLUMN is_deleted TINYINT(1) NOT NULL DEFAULT 0;