Django使用AliyunRDS只读实例实现读写分离.pdfVIP

Django 使用 AliyunRDS 只读实例 实现读写分离 前几天为了上读写分离功能，MySQL5.1 直接升到 5.6 （而且5.1 也不维护了）。 新增的只读实例 找了半天才在管理控制台看到 常规实例点开+号，展开才能看 到。 不是类型筛选（筛选只有一个选项常规实例） 自定义了 django db router ： import random class MasterSlaveRouter(object): def db_for_read(self, model, **hints): return random.choice([slave1, slave2, slave3]) def db_for_write(self, model, **hints): return default def allow_relation(self, obj1, obj2, **hints): return True def allow_syncdb(self, db, model): return True settings.py 添加的配置如下： DATABASES = { default: { 第1 页 共3 页 ENGINE: django.db.backends.mysql, # Add postgresql_psycopg2, postgresql, mysql, sqlite3 or oracle. NAME: xxxxxxx, # Or path to database file if using sqlite3. USER: xxxxxx, # Not used with sqlite3. PASSWORD: xxxxxx, # Not used with sqlite3. HOST: , # Set to empty string for localhost. Not used with sqlite3. PORT: , # Set to empty string for default. Not used with sqlite3. OPTIONS: { use_unicode: utf-8, init_command: SET storage_engine=INNODB, } }, slave1: { ENGINE: django.db.backends.mysql, # Add postgresql_psycopg2, postgresql, mysql, sqlite3 or oracle. NAME: xxxx, # Or path to database file if using sqlite3. USER: xxxxx, # Not used with sqlite3. PASSWORD: xxxxxx, # Not used with sqlite3. HOST: , # Set to empty string for localhost. Not used with sqlite3. PORT: , # Set to empty string for default. Not used with sqlite3. OPTIONS: { use_unicode: utf-8, init_command: SET storage_engine=INNODB, } } } DATABASE_ROUTERS = [epu