Replication : Delete from Master Database Is it possible to delete certain data from Master Database and
retain that data in the slave ?

For, example I want to delete data of before 5 years from master.
And I'm sure that data is not being used in any current transactions.

Will this cause any synchronization problems ?

Is it not recommended ?

I researched for it, but couldn't find any perfect solution !
set sql_log_bin=0;
&lt;delete_query&gt;;
set sql_log_bin=1;


That should take care with the delete on master and will not replicate to the slave.

I'd recommend against this though. I think it's better to transfer data older than 5 years to a separate table then drop the table from the master side and retain the one on the slave.