Hey,
That's a set back , I was getting a lot of Access Denied errors on mysql console. However i figured out a badly designed hack-around, in Django specifying database to use, I could override the save method of a model to save in both the main and backup databases. That ensures replication though it makes the website slower, that's okay for my current setup.
Ex.
def save(self, *args, **kwargs):
# check if the using parameter is not specified in args or kwargs
to_ret = super(SomeModelName, self).save(using='default', *args, **kwargs)
try:
super(SomeModelName, self).save(using='backup', *args, **kwargs)
except:
# Handle race condition while inserting multiple new objects at the same time, maybe force insert or get a lock on the
# backup while inserting into the main one?
pass
return to_ret
However i can only override the save methods for the models in the django app's that I have written not the third party apps, hence can't assure backup for all models, can you guys help me out over here?