Can I get InoDB to split tables by size?

[Selahattin ÇİLEK]

OS: FreeBSD 14.0-RELEASE
MySQL: MySQL 8.0.32_3
FS: ZFS


I am working on a new database. The schema consists of a single table and nothing else. I know the table will grow at a rapid and constant rate; and since the data is very valuable, it will have to be backed up, probably to two separate locations.

My concern is that the backups will grow substantially every time a new one is created, as each backup will contain all the data, so the backups will grow bigger and bigger, and take longer and longer to send.

That's why I have opted to use ZFS remote replication, due to its incremental replication abilities.

But then, thinking it over, I realized that ZFS incremental replication will not cut it because the whole table will be copied every time a new snapshot is created.

So my question is: Can I get InnoDB to split files by size, so they are easier to manage by the system?