index_schema.sql

-- unsharded database
CREATE TABLE `shops_index` (
  `shop_id` bigint(20) unsigned NOT NULL,
  `shop_shard` int(11)  NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`shop_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;

queries.sql

USE `index_test`;
INSERT INTO shops_index (shop_id, shop_shard) VALUES(15, 15);

USE `shard_test:-80`;
INSERT INTO shop_data (shop_id, k, v) VALUES(1, 'a', 'a');

shards_schema.sql

-- sharded database
CREATE TABLE `shop_data` (
  `shop_id` bigint(20) unsigned NOT NULL,
  `k` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `v` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`shop_id`, `k`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;