maria-discuss team mailing list archive

Thread
Date

maria-discuss team
Mailing list archive
Message #04986

Replication set up to ignore Delete statements

To: "maria-discuss@xxxxxxxxxxxxxxxxxxx" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
From: "Furlong, John" <John.Furlong@xxxxxxxxxxxxxxxxx>
Date: Thu, 25 Jan 2018 20:49:22 +0000
Accept-language: en-US
Thread-index: AdOWHVEbfS8KK7MzQDqbKWWOenekAA==
Thread-topic: 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?

Thanks.

John