I have a write heavy application. Approx 5lac+ inserts per day in a MySQL table. I have master <> master -> slave. Performance is not an issue here.
I need your inputs with regards to management of the data. After a certain ammount of time I'd see the table becomes bulky and I would like to discard old records; though I'd be needing them later. I want to discuss the best way to keep this data.
Partitioning on monthly basis is the one way I can think of.