########settings.py############

DATABASES = {
    ‘default‘: {
        ‘ENGINE‘: ‘django.db.backends.mysql‘,
        ‘HOST‘: ‘10.211.55.5‘,
        ‘PORT‘: 3306,
        ‘USER‘: ‘root‘,
        ‘PASSWORD‘: ‘123456‘,
        ‘NAME‘: ‘opwf‘
    },
    ‘slave‘: {
        ‘ENGINE‘: ‘django.db.backends.mysql‘,
        ‘HOST‘: ‘10.211.55.5‘,
        ‘PORT‘: 8306,
        ‘USER‘: ‘root‘,
        ‘PASSWORD‘: ‘123456‘,
        ‘NAME‘: ‘opwf‘
    }
}

#######opwf/utils/db_router.py########

class MasterSlaveDBRouter(object):
    """数据库主从读写分离路由"""

    def db_for_read(self, model, **hints):
        """读数据库"""
        return "slave"

    def db_for_write(self, model, **hints):
        """写数据库"""
        return "default"

    def allow_relation(self, obj1, obj2, **hints):
        """是否运行关联操作"""
        return True

##########settings.py##########
# 配置读写分离
DATABASE_ROUTERS = [‘utils.db_router.MasterSlaveDBRouter‘]