maria-discuss team mailing list archive
Mailing list archive
Re: Some questions about mariadb-dump and mariabackup
"jose.kahan@xxxxxx" <jose.kahan@xxxxxx>, "maria-discuss@xxxxxxxxxxxxxxxxxxx" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
Cédric Counotte <cedric.counotte@xxxxxxxxxx>
Tue, 2 Aug 2022 11:45:06 +0000
i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=1check.com; dmarc=pass action=none header.from=1check.com; dkim=pass header.d=1check.com; arc=none
i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=lSFOoEvYGDY0TDam+S6GO2BlUyR6kfkKoOH3yZ0dIAk=; b=h/wQIejv5q2bQcpYkAKcKpqt6hAMsTQ+1aCR6q8K6yJ7Nb3fzfUVkPb20qVdEd2dlHGpuwhFLbS7iBmygsvIze4Aw2JEKMX5b8akXiNxu+3Oc/NuKY4CcW1XdrlTAOw8Ml7cErnyxSlX5cCOCz42IOTotcllf9GORVIDLGPZWROcRVCIY6rbHbOAY3tsWUHs2B+cLJRpwvMg8bVo2SH74D+uOppO4+xMdzLVXSCFWKQGmRnseJuoP/yVxYX2DpKLWZrhIJ/BFzQyMUuLDVtG5cw9pyRgdnEtglYGp82zY3Yh4M63mhv8KAQW+66kuU34J8eNJt0BUxdEYgkoWsbrRw==
i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=NZwtNsPDXwdukSEznfsG0oeJcV/IoCxBp6DXDUB+8JH7Pq+fI1KYr59yBq7L6vbF9e6SDk/iAMLkaf99C0Fp8R1DPYh+AOdHYDJiN8m352FFjg0LfZa+8Fm83ZGZ0y0XaEGmW4erOdS6RFA9w0QAeUo4foJTRQBinGZY/yxLLYPlfNkJRqNoFTeitAnNV4H9ktnfAwAuk0X/vcguBeTooMKa1We/FDdKAd0DprSGfX3HWXY3zvkr1BO1th0We2Kuq4nS1z6IiWA1iU0bSP1OxdlXVXWWixgTv0v3DYkkEYO0aHPTtkrg/xeRZhUdkME7dcWLmnDTez9uU+ogj4cLGA==
dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=1check.com;
[Maria-discuss] Some questions about mariadb-dump and mariabackup
I will partially respond to your questions:
-skip-lock-tables, avoids locking the table when dumping them.
This means if you are on production servers, the dump won't freeze/slow your activity, however the dump may be incomplete or not reflecting an atomic state.
This as far as I know is only the way the INSERT commands will be written to the dump. With multiple inserts or a single one.
As for mariabackup, I don't think the prepare command needs access to the actual source folder, as everything has been copied. The prepare seems to replace the last bin log, but you might want to seek for someone else confirmation.
FWIW, I stopped using mariabackup for backup (using it to start replication only) because restoring a single DB (we have 300+) or a single table seems highly cumbersome because you'll have to restore the entire backup to a working MariaDB server, and then dump/import the tables/DB you need onto your production server. Had to do it once, never again. So now I'm using plain mysqldump for which I easily control the output and how I'll be able to retrieve a DB or single table!
De : Maria-discuss <maria-discuss-bounces+cedric.counotte=1check.com@xxxxxxxxxxxxxxxxxxx> De la part de jkmdb@xxxxxx
Envoyé : mardi 2 août 2022 12:34
À : maria-discuss@xxxxxxxxxxxxxxxxxxx
Objet : [Maria-discuss] Some questions about mariadb-dump and mariabackup
Hi! Sorry to bother you about this but I haven't found the answers in the doc.
Could you tell me what is the difference of calling mariadb-dump on innodb tables using --skip-lock-tables --single-transaction?
>From what I read these seem to be time / performace optimizations for doing innodb tables dumps but if we omit them, we would get the same data dumped, even it takes longer.
Could you confirm this?
We have a setup that stores the binary logs under /var/log/mysql (set up with the log_bin configuration option) and the databases themselves under /var/lib/mysql
Suppose I call mariabackup to make a backup of the database as follows (some options obmitted):
mariabackup --backup --target-dir=my_backup_dir
Could you tell me if calling
mariabackup --prepare --target-dir=my_backup_dir
needs access to the binary logs stored under /var/log/mysql or if mariabackup made a copy of all that it needs in my_backup_dir?
** mariabackup and incremental backups
This is basically the same question as the above. If i'm making incremental backups as follows (some options obmitted):
mariabackup --backup \
When I do the prepare for the incremental backups, does mariabackup need access to the /var/log/mysql bin logs or do the full + each incremental backup dirs has all the info needed to do the prepare?
mariabackup --prepare \
Many thanks in advance!
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp