How to build a database that stores huge data while no need of frequent query?
I might consider below option if it is in Mysql.


Table will be partitioned by RANGE weekly.
On Master keep latest week's partition. And drop earlier partitions in below way.



  a). set sql_log_bin=0; #Set local session to not log into binlog.

  b). alter table drop partition OLD_PARTITION_NAME;

  c). exit;




On Slave keep old data.
Set this kind of automated/manual job every week to drop old partition on Master.
You might have to once verify the selects going on Master.