Archiving of old data combined with replication to data warehouse I have a setup that I'm sure is not unheard of (this is MySQL 5.5, but upgrading):

I have a fast growing OLTP database, that I am replicating to an OLAP database. I want to start archiving the fastest growing tables in the OLTP db, but I want the OLAP db to accumulate everything without the archiving part. Is there an easy way to achieve this, or so I have invent my own procedures?
Consider the following...


The Master is collecting "raw" data in a "Fact" table.  (I am using Data Wherehouse terminology; I hope the analogy works.)
The Fact table is not replicated.  But it is PARTITIONed by date for efficient archiving.  (We can discuss that separately.)  (If you need 'some' of the Fact table replicated, we can discuss that.)
On the Master, a few "Summary Tables" ("rollups") are built and maintained.
The Summary tables are replicated.  Querying against these will be much faster than against the Fact table.


DW discussion:  http://mysql.rjweb.org/doc.php/datawarehouse
Summary Tables:  http://mysql.rjweb.org/doc.php/summarytables
Time Series pruning:  http://mysql.rjweb.org/doc.php/partitionmaint

If you want to dig deeper into these ideas, please provide more details of the application and its data.