Django Database Routers Master-Slave

routers.py

import random
 
class MasterSlaveRouter(object):
    def db_for_read(self, model, **hints):
        """
        Reads go to a randomly-chosen slave.
        """
        return random.choice(['master','slave1', 'slave2'])
 
    def db_for_write(self, model, **hints):
        """
        Writes always go to master.
        """
        return 'master'
 
    def allow_relation(self, obj1, obj2, **hints):
        """
        Relations between objects are allowed if both objects are
        in the master/slave pool.
        """
        db_list = ('master', 'slave1', 'slave2')
        if obj1.state.db in db_list and obj2.state.db in db_list:
            return True
        return None
 
    def allow_syncdb(self, db, model):
        """
        All non-auth models end up in this pool.
        """
        return True

settings.py

DATABASES = {
	'default': {
		'ENGINE': 'django.db.backends.mysql',
		'NAME': 'anotherdatabase',
		'USER': 'anotherusername',
		'PASSWORD': 'anotherpassword',
		'HOST': '192.168.1.1',
		'PORT': '',
	},
	'master': {
		'ENGINE': 'django.db.backends.mysql',
		'NAME': 'anotherdatabase',
		'USER': 'anotherusername',
		'PASSWORD': 'anotherpassword',
		'HOST': '192.168.1.1',
		'PORT': '',
	},
	'slave1': {
		'ENGINE': 'django.db.backends.mysql',
		'NAME': 'anotherdatabase',
		'USER': 'anotherusername',
		'PASSWORD': 'anotherpassword',
		'HOST': '192.168.1.2',
		'PORT': '',
	},
	'slave2': {
		'ENGINE': 'django.db.backends.mysql',
		'NAME': 'anotherdatabase',
		'USER': 'anotherusername',
		'PASSWORD': 'anotherpassword',
		'HOST': '192.168.1.3',
		'PORT': '',
	},
}
 
DATABASE_ROUTERS = ['my_project.routers.MasterSlaveRouter']