mysql_cluster: db backend supporting replication for MySQL
Ivan Sagalaev
I'd like to introduce a db backend that supports master-slave
replication for MySQL - mysql_cluster[1]. It's written at our company
Yandex[1] (mostly by myself :-) ). We use MySQL replication heavily and
our admins have finally made me to get my hands dirty and write this
thing :-). Now anyone who wanted to scale database reads to replicated
hosts can do this more or less easily.
Some notes are due:
- the backend is an external app, it doesn't require changes in Django core
- it's not the same thing as multiple-db branch, it only solves one
task: master-slave replication
- it works with recent trunk versions from the moment when
DATABASE_ENGINE settings started to get custom backends
- the backend works by switching django.db.connection between master and
slave modes which means that programmer should watch when writes to a DB
are allowed
- it's not very hard though -- please do read "README"
Comments are welcome!
[1]: http://softwaremaniacs.org/soft/mysql_cluster/en/
[2]: http://yandex.com