MySQL Forums
Forum List  »  Docs

Re: Replication without deletes and drops
Posted by: Arjen Lentz
Date: October 05, 2004 03:20PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
3934
September 24, 2004 10:42AM
Re: Replication without deletes and drops
2432
October 05, 2004 03:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.