How is the mechanism of auto deletion / archiving of data in a MySQL table implemented upon expiration of time?

Question

MySQL

Good time dear colleagues!
I got into a stupor on a simple question ..
How to implement AUTO deletion or data archiving in SQL after, say, a year ...
The table content is straightforward:
ID - bigint (11) AUTO_INCREMENT
DATE_READ - datetime (0000-00-00 00:00:00 )
well, and further varchars ..
i.e. we have the date and time when the record gets into the table and exactly after say 365 days it should not be there anymore)) Without initiating direct queries, is it possible to implement this at the MySQL levels? If not, which one has any ideas?)) Thank you
in advance from the bottom of my heart!

Answer 1

You can use MySQL Triggers/Events/Procedures

Answer 2

cron

Answer 3

Good old =)

if(rand(0, 9) < 3) {
// archive
}