Mariadb-dump, backing up single partition
Hi Everyone, I want to add the ability to backup a single partition using mysqldump. I have some large (500GB+) partitioned tables I want to backup fast. So the idea is to run each partition in parallel using mariadb-dump but AFAIK there's no option for specifying the partition yet. Will you merge my code if I add that to mariadb-dump ? I assume MariaDB/server/blob/main/client/mysqldump.cc is where dev for that happens? Thanks
pslawek83 via discuss <discuss@lists.mariadb.org> writes:
partition yet. Will you merge my code if I add that to mariadb-dump ?
There is no guarantee, of course, but it sounds like a useful addition, so if the code is good / becomes good after review, it seems like something that should be merged. MariaDB does take contributions, if that is what you are asking.
I assume MariaDB/server/blob/main/client/mysqldump.cc is where dev for that happens? Thanks
Yes. - Kristian.
Hi, pslawek83, Note that mariadb-dump already supports --parallel option that can dump many tables in parallel. Depending on your use case you might want to extend --parallel to automatically dump individual partitions in parallel, instead of extending mariadb-dump to allow to specify what partition to dump. Depends on what you need, of course, I'm just listing the options so that you could choose what works better for you. On Mar 12, pslawek83 via discuss wrote:
Hi Everyone, I want to add the ability to backup a single partition using mysqldump. I have some large (500GB+) partitioned tables I want to backup fast. So the idea is to run each partition in parallel using mariadb-dump but AFAIK there's no option for specifying the partition yet. Will you merge my code if I add that to mariadb-dump ? I assume MariaDB/server/blob/main/client/mysqldump.cc is where dev for that happens? Thanks
Regards, Sergei Chief Architect, MariaDB Server and security@mariadb.org
participants (3)
-
Kristian Nielsen -
pslawek83 -
Sergei Golubchik