How to build a database that stores huge data while no need of frequent query? We want to separate our data into fresh data and history data. History data is rarely used so we decide to move them to a specific database that stores huge data while no need of frequent query nor very good speed.

What kind of database is most suitable for this case?
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.