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() function?

Thanks.

John