#33496: Auto database mirroring.
-------------------------------------+-------------------------------------
Reporter: M Hadi Azarabad | Owner: nobody
Type: New feature | Status: closed
Component: Database layer | Version: 4.0
(models, ORM) |
Severity: Normal | Resolution: wontfix
Keywords: multi-database / | Triage Stage:
mirror database | Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Steven Mapes):
Following on from Mariusz's reply with the Postgres reference on HA, load
balancing and replication here's [https://dev.mysql.com/doc/refman/8.0/en
/replication-solutions.html MySQL's replication solutions] and
[https://downloads.mysql.com/docs/mysql-proxy-en.pdf MySQL Proxy] which
can be used as load balancer to distribute requests and perform automatic
failover, here's a [https://www.digitalocean.com/community/tutorials/how-
to-use-proxysql-as-a-load-balancer-for-mysql-on-ubuntu-16-04 Digital Ocean
install guide] for the latter.
If you are using MariaDB then here's the [https://mariadb.com/kb/en
/standard-replication/ replication docs] to get you started.
If you are looking at Multi-Master using either then look into
[https://galeracluster.com/ Galera Cluster] but these will be better
solutions than writing twice from code
--
Ticket URL: <https://code.djangoproject.com/ticket/33496#comment:3>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/068.6f23ceeade4cdc9f5b2df2892dc88a19%40djangoproject.com.
