josh wrote:
> I have replication set-up between my two db servers and everything is working perfectly. I am
> hoping to keep this in place however not allow deletes and drops from taking place on the slave
> db. Is this possible? I'm basically using this as realtime (almost realtime) backup of critical
> data. If this isn't possible, is there a better solution for my problem?
Most commonly, you would set up a user for your app on the master, and a different user on the slave. An app would connect to both, do selects on the slave, and any updates on the master. The slave user would only have SELECT privileges, which of course prevents any accidental updates into the slave system.
This should work fine for your case too?
Regards,
Arjen.
Regards, Arjen.
--
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Remote expertise & maintenance for MySQL/MariaDB server environments.
Follow us at
http://openquery.com/blog/ &
http://twitter.com/openquery