← Back to team overview

maria-discuss team mailing list archive

Replication set up to ignore Delete statements


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?