Django的多数据库与读写分离
发布时间:2020-12-20 10:16:39 所属栏目:Python 来源:网络整理
导读:1.多个数据库 settings.py DATABASES = { 'default': { 'ENGINE': 'django.db.backends.sqlite3','NAME': os.path.join(BASE_DIR,'db.sqlite3'),},'db2': { 'ENGINE': 'django.db.backends.sqlite3','db2.sqlite3'),} 迁移其他的数据库 python manage.py mig
1.多个数据库
DATABASES = { 'default': { 'ENGINE': 'django.db.backends.sqlite3','NAME': os.path.join(BASE_DIR,'db.sqlite3'),},'db2': { 'ENGINE': 'django.db.backends.sqlite3','db2.sqlite3'),}
2.读写分离2.1手动指定models.Student.objects.using('db2').all() obj = models.Student.objects.using('db2').get(name='zhazha') obj.name = 'star' obj.save(using='default') 2.4自动选择
DATABASE_ROUTERS = ['myrouter.Router']
class Router: """ 读写分离 """ def db_for_write(self,model,**kwargs): return 'db2' def db_for_read(self,**kwargs): return 'default'
class Router: """ 一主多从 """ def db_for_write(self,**kwargs): return 'db1' def db_for_read(self,**kwargs): return random.choices['db2','db3','db4']
class Router: """ 分库分表 app01 model db1 app02 model db2 """ def db_for_write(self,**kwargs): app_name = model._meta.app_label if app_name == 'app01': return 'db1' elif app_name == 'app02': return 'db2' def db_for_read(self,**kwargs): app_name = model._meta.app_label if app_name == 'app01': return 'db1' elif app_name == 'app02': return 'db2' (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |