开源扫码点餐系统源码部署实战：服务器与数据库优化方案

Nginx  →  应用层（Spring Boot / Node） →  Redis  →  MySQL

upstream order_system {
    server 127.0.0.1:8081;
    server 127.0.0.1:8082;
}

server {
    listen 80;
    server_name yourdomain.com;

    location / {
        proxy_pass http://order_system;
        proxy_set_header Host $host;
        proxy_set_header X-Real-IP $remote_addr;
    }
}

java -jar order.jar --server.port=8081
java -jar order.jar --server.port=8082

CREATE TABLE orders (
    id BIGINT PRIMARY KEY AUTO_INCREMENT,
    order_no VARCHAR(32) NOT NULL,
    user_id BIGINT NOT NULL,
    total_amount DECIMAL(10,2),
    status TINYINT,
    create_time DATETIME,
    INDEX idx_user_id(user_id),
    INDEX idx_order_no(order_no)
) ENGINE=InnoDB;

@Autowired
private RedisTemplate<String, Object> redisTemplate;

public List<Menu> getMenuList() {
    String key = "menu:list";
    if(redisTemplate.hasKey(key)) {
        return (List<Menu>) redisTemplate.opsForValue().get(key);
    }

    List<Menu> list = menuMapper.selectList(null);
    redisTemplate.opsForValue().set(key, list, 30, TimeUnit.MINUTES);
    return list;
}

String lockKey = "order:lock:" + userId;

Boolean lock = redisTemplate.opsForValue()
        .setIfAbsent(lockKey, "1", 5, TimeUnit.SECONDS);

if(!lock){
    throw new RuntimeException("请勿重复提交");
}

// 创建订单逻辑

innodb_buffer_pool_size = 1G
max_connections = 500
query_cache_size = 0

SET GLOBAL slow_query_log = 'ON';

public class SnowflakeIdWorker {
    private long workerId = 1L;
    private long datacenterId = 1L;
    private long sequence = 0L;

    public synchronized long nextId() {
        long timestamp = System.currentTimeMillis();
        return (timestamp << 22)
                | (datacenterId << 17)
                | (workerId << 12)
                | sequence++;
    }
}

主库 → 写操作
从库 → 查询操作

spring:
  datasource:
    dynamic:
      primary: master
      datasource:
        master:
          url: jdbc:mysql://master-db:3306/order
        slave:
          url: jdbc:mysql://slave-db:3306/order