Mariadb with more than one node each node will have recent 1 year data

I am creating a saas which will then have time based data every seconds for example. I want horizontal scalling when data reach its limit of 1 year. after 1 year old data should be shift to another server so only 1 year data is available on 1st node 2nd will have 1 year old data and 3rd will have 2 years old data so on. let me know which db tool I should use to achieve this and how? or let me know better solution if any