Is there a way to set the MySQL replication to add new rows and delete the old rows? for example i have table on the master MySQL that goes back about 5 years. I would like the replication to only keep up to date with the last 30 days. Anything after 30 days will be deleted off the replication. How could i achieve this?
- Thanks in advance