How to configure MySQL database replication with removal of replicated records from the main database?

Question

MySQL

The situation is this. Data from the application is poured into the database on the main MySQL server, but there is not enough disk space on the server (you need many times more space). Therefore, another MySQL server was raised, where data from the main database should eventually be poured. That is, the main MySQL server acts as a buffer. The overflow logic should be as follows: the record from the main database is copied to the secondary database, after which it is deleted in the main database (the place on the raid is freed up). What is the best way to implement this?
ps.
- There is no possibility to increase the disk space on the main server,
- There is no possibility to upload data directly to the secondary server either.

Answer 1

IMHO, such standard replication not to make, only hands. Maybe it's easier for you to raise a MySQL proxy on the first server?