cdn加速数据库查询

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

import redis
import pymysql

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

# 连接MySQL
mysql_conn = pymysql.connect(host='localhost', user='root', password='password', db='test')
mysql_cursor = mysql_conn.cursor()

def get_user_by_id(user_id):
    # 尝试从Redis缓存中获取用户信息
    user_info = redis_client.get(f'user:{user_id}')
    if user_info:
        return user_info.decode('utf-8')
    
    # 如果缓存中没有，则查询MySQL数据库
    mysql_cursor.execute("SELECT * FROM users WHERE id = %s", (user_id,))
    user_info = mysql_cursor.fetchone()
    
    # 将查询结果存入Redis缓存
    redis_client.setex(f'user:{user_id}', 3600, str(user_info))
    
    return user_info

# 示例调用
print(get_user_by_id(1))