Opened 2 years ago

Last modified 2 years ago

#33496 closed New feature

mirror database in django — at Version 1

Reported by: M Hadi Azarabad Owned by: nobody
Component: Database layer (models, ORM) Version: 4.0
Severity: Normal Keywords: multi-database / mirror database
Cc: Triage Stage: Unreviewed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description (last modified by Tim Graham)

Hi. I'm looking for a solution to save data on mirror database. Using database routers allow us to save a record and lets us decide which database must be used and I think manual database selection is not optimal because it uses ORM to create raw SQL twice or more (based on the number of mirror database). 

model_obj.save(using='db_1') 
model_obj.save(using='db_2')

I think django can handle this problem and optimize it by adding setting list variable called MIRROR_DATABASES so all mirror databases place in there and Django save all of records by creating one raw SQL if mirror databases using the same backend.

Change History (1)

comment:1 by Tim Graham, 2 years ago

Description: modified (diff)
Note: See TracTickets for help on using tickets.
Back to Top