高可用性:确保双十一期间数据库服务不中断
高性能:支持高并发读写操作
可扩展性:应对突发流量增长
数据一致性:保证交易数据准确无误
容灾能力:应对硬件故障和网络问题
CREATE TABLE users (
user_id BIGINT PRIMARY KEY,
username VARCHAR(50) NOT NULL UNIQUE,
password VARCHAR(100) NOT NULL,
phone VARCHAR(20) UNIQUE,
email VARCHAR(100) UNIQUE,
create_time DATETIME DEFAULT CURRENT_TIMESTAMP,
last_login_time DATETIME,
status TINYINT DEFAULT 1 COMMENT '1-正常 0-冻结'
) ENGINE=InnoDB;CREATE TABLE products (
product_id BIGINT PRIMARY KEY,
name VARCHAR(200) NOT NULL,
price DECIMAL(10,2) NOT NULL,
stock INT NOT NULL DEFAULT 0,
category_id INT,
description TEXT,
images JSON,
status TINYINT DEFAULT 1 COMMENT '1-上架 0-下架',
create_time DATETIME DEFAULT CURRENT_TIMESTAMP,
update_time DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
INDEX idx_category (category_id),
INDEX idx_price (price)
) ENGINE=InnoDB;CREATE TABLE orders (
order_id BIGINT PRIMARY KEY,
user_id BIGINT NOT NULL,
total_amount DECIMAL(10,2) NOT NULL,
status TINYINT DEFAULT 0 COMMENT '0-待支付 1-已支付 2-已取消 3-已完成',
pay_time DATETIME,
create_time DATETIME DEFAULT CURRENT_TIMESTAMP,
update_time DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
INDEX idx_user (user_id),
INDEX idx_status (status),
INDEX idx_create_time (create_time)
) ENGINE=InnoDB;CREATE TABLE order_items (
item_id BIGINT PRIMARY KEY,
order_id BIGINT NOT NULL,
product_id BIGINT NOT NULL,
quantity INT NOT NULL,
price DECIMAL(10,2) NOT NULL,
FOREIGN KEY (order_id) REFERENCES orders(order_id),
FOREIGN KEY (product_id) REFERENCES products(product_id)
) ENGINE=InnoDB;CREATE TABLE stock_logs (
log_id BIGINT PRIMARY KEY,
product_id BIGINT NOT NULL,
change_type TINYINT NOT NULL COMMENT '1-下单扣减 2-支付确认 3-取消返还',
change_quantity INT NOT NULL,
old_stock INT NOT NULL,
new_stock INT NOT NULL,
create_time DATETIME DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (product_id) REFERENCES products(product_id)
) ENGINE=InnoDB;预热阶段
索引优化:
查询优化:
事务优化:
慢查询分析:
连接池监控:
性能基准测试:
自动扩缩容:
没有搜到相关的沙龙