多个域名用同一个数据库

CREATE TABLE orders (
    order_id INT AUTO_INCREMENT,
    domain VARCHAR(255),
    order_data TEXT,
    PRIMARY KEY (order_id)
) PARTITION BY LIST COLUMNS(domain) (
    PARTITION p1 VALUES IN ('domain1.com'),
    PARTITION p2 VALUES IN ('domain2.com')
);

import redis
import mysql.connector

# 连接Redis
redis_client = redis.Redis(host='localhost', port=6379, db=0)

# 连接MySQL
mysql_conn = mysql.connector.connect(user='user', password='password', host='localhost', database='database')
mysql_cursor = mysql_conn.cursor()

def get_data(domain, key):
    cache_key = f"{domain}:{key}"
    data = redis_client.get(cache_key)
    if data is None:
        mysql_cursor.execute("SELECT data FROM orders WHERE domain = %s AND key = %s", (domain, key))
        data = mysql_cursor.fetchone()
        if data:
            redis_client.setex(cache_key, 3600, data[0])  # 缓存1小时
    return data

from django.db import models

class Order(models.Model):
    domain = models.CharField(max_length=255)
    order_data = models.TextField()

    class Meta:
        unique_together = ('domain', 'order_data')