[Maria-discuss] Replication set up to ignore Delete statements
![](https://secure.gravatar.com/avatar/9c6150fe14c72a0542763e76f7332937.jpg?s=120&d=mm&r=g)
25 Jan
2018
25 Jan
'18
9:49 p.m.
I am new to MariaDB and am wondering if it's possible to set up replication to only replicate INSERTS & UPDATES? Can Deletes be ignored? The purpose is to keep the primary DB small and the secondary DB would be a data warehouse. Does --binlog-format=STATEMENT mean all writes? I've been reading the documention but haven't been able to find a definitive answer. If Delete statements are executed by a different user is it possible to ignore them that way such as through the CURRENT_USER()https://mariadb.com/kb/en/current_user/ function? Thanks. John
2375
Age (days ago)
2375
Last active (days ago)
0 comments
1 participants
participants (1)
-
Furlong, John