MySQL Forums
Forum List  »  InnoDB

Can I get InoDB to split tables by size?
Posted by: Selahattin ÇİLEK
Date: December 12, 2023 01:21AM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
Can I get InoDB to split tables by size?
407
December 12, 2023 01:21AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.