1
# 创建 docker-compose.yml
2
cat > docker-compose.yml << 'EOF'
3
version: "3.8"
4
services:
5
  mysql:
6
    image: mysql:8.0
7
    environment:
8
      MYSQL_ROOT_PASSWORD: root
9
      MYSQL_DATABASE: testdb
10
    ports:
11
      - "3306:3306"
12
    volumes:
13
      - mysql_data:/var/lib/mysql
14
    command: >
15
      --innodb-buffer-pool-size=256M
16
      --innodb-log-file-size=64M
17
      --innodb-flush-method=O_DIRECT
18

19
  postgres:
20
    image: postgres:16
21
    environment:
22
      POSTGRES_PASSWORD: root
23
      POSTGRES_DB: testdb
24
    ports:
25
      - "5432:5432"
26
    volumes:
27
      - pg_data:/var/lib/postgresql/data
28
    command: >
29
      -c shared_buffers=256MB
30
      -c wal_level=replica
31
      -c max_wal_size=1GB
32

33
  rocksdb:
34
    image: ubuntu:22.04
35
    ports:
36
      - "8080:8080"
37
    volumes:
38
      - rocksdb_data:/data
39
      - ./scripts:/scripts
40
    command: /bin/bash -c "apt-get update && apt-get install -y libgflags-dev libsnappy-dev zlib1g-dev libbz2-dev liblz4-dev libzstd-dev git build-essential && git clone https://github.com/facebook/rocksdb.git /rocksdb && cd /rocksdb && make static_lib -j$(nproc) && make install && sleep infinity"
41

42
  minio:
43
    image: minio/minio:latest
44
    environment:
45
      MINIO_ROOT_USER: minioadmin
46
      MINIO_ROOT_PASSWORD: minioadmin
47
    ports:
48
      - "9000:9000"
49
      - "9001:9001"
50
    volumes:
51
      - minio_data:/data
52
    command: server /data --console-address ":9001"
53

54
volumes:
55
  mysql_data:
56
  pg_data:
57
  rocksdb_data:
58
  minio_data:
59
EOF
60

61
# 启动所有服务
62
docker compose up -d
63

64
# 验证连接
65
docker compose exec mysql mysql -uroot -proot -e "SHOW ENGINE INNODB STATUS\G" | head -20
66
docker compose exec postgres psql -U postgres -c "SELECT * FROM pg_stat_wal;"
67
docker compose exec minio mc alias set local http://localhost:9000 minioadmin minioadmin

1
-- MySQL: 创建测试表并观察存储行为
2
CREATE TABLE storage_test (
3
    id BIGINT PRIMARY KEY AUTO_INCREMENT,
4
    data VARCHAR(255),
5
    payload BLOB,
6
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
7
    INDEX idx_created (created_at)
8
) ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
9

10
-- 插入测试数据
11
INSERT INTO storage_test (data, payload)
12
SELECT
13
    CONCAT('record_', n),
14
    REPEAT('x', 1000)
15
FROM (
16
    WITH RECURSIVE nums AS (
17
        SELECT 1 AS n
18
        UNION ALL
19
        SELECT n + 1 FROM nums WHERE n < 100000
20
    )
21
    SELECT n FROM nums
22
) t;
23

24
-- 观察 InnoDB 页面结构
25
SELECT
26
    table_name,
27
    table_rows,
28
    data_length,
29
    index_length,
30
    data_free
31
FROM information_schema.tables
32
WHERE table_schema = 'testdb';

1
-- PostgreSQL: 创建测试表并观察存储行为
2
CREATE TABLE storage_test (
3
    id BIGSERIAL PRIMARY KEY,
4
    data VARCHAR(255),
5
    payload BYTEA,
6
    created_at TIMESTAMP DEFAULT NOW()
7
);
8

9
-- 插入测试数据
10
INSERT INTO storage_test (data, payload)
11
SELECT
12
    'record_' || n,
13
    decode(repeat('78', 1000), 'hex')
14
FROM generate_series(1, 100000) AS n;
15

16
-- 观察页面信息
17
SELECT
18
    relname,
19
    relpages,
20
    reltuples,
21
    pg_size_pretty(pg_relation_size(oid)) AS size
22
FROM pg_class
23
WHERE relname = 'storage_test';

1
# 编译 RocksDB 后运行基准测试
2
cd /rocksdb
3

4
# 写入基准测试
5
./db_bench --benchmarks=fillseq --num=1000000 --value_size=1024 --threads=1
6

7
# 读取基准测试
8
./db_bench --benchmarks=readrandom --num=1000000 --value_size=1024 --threads=4
9

10
# Compaction 统计
11
./db_bench --benchmarks=fillrandom --num=1000000 --stats_interval=10000 \
12
    --stats_per_interval=1 --compaction_style=1

1
# 安装 mc 客户端
2
docker compose exec minio sh -c "
3
  mc alias set local http://localhost:9000 minioadmin minioadmin
4

5
  # 创建桶
6
  mc mb local/test-bucket
7

8
  # 上传文件
9
  mc cp /data/test-file local/test-bucket/
10

11
  # 查看桶信息
12
  mc ls local/test-bucket/
13

14
  # 查看纠删码信息
15
  mc admin info local
16
"