HotBackup for Mariadb Using Mariabackup
We have mariadb Galera Cluster 10.2 using mariabackup as SST. I heard that mariabackup can be used to take Consistent hotbackup of production database without locking since all dbs are innoDB. Currently using mysqldump with --single-transaction ; but this gonna take longer time to backup since DBs are biGger, snapshots like mariabackup will be pretty fast. I need the following :
1) Difference in innobackupex and mariabackup ;
Is there any different in running #> innobackupex and #> mariabackup --innobackupex
2) command to use mariabackup for consistent DB backup without locking dbs in production along with compression.
3)How to apply the latest transactions or changes while we do the backups , I mean read somewhere like --apply-log , --prepare both are different and used at different occasions.
4) Restore the backup.
5) Incremental Backups as and its process.
I am not asking to do my job or anything, instead I was pretty confused, everytime I search I end up seeing its fork of xtrabackup and then diving in seeing some --innobackupex and info out there are now confusing.
Since we are using only Mariadb and mariabackup , I would like to understand that now and learn and then I will find out the others all by myself.
mariadb
asked Nov 12 at 6:07
SAGAR BHOOSHAN
1133
add a comment |
We have mariadb Galera Cluster 10.2 using mariabackup as SST. I heard that mariabackup can be used to take Consistent hotbackup of production database without locking since all dbs are innoDB. Currently using mysqldump with --single-transaction ; but this gonna take longer time to backup since DBs are biGger, snapshots like mariabackup will be pretty fast. I need the following :
1) Difference in innobackupex and mariabackup ;
Is there any different in running #> innobackupex and #> mariabackup --innobackupex
2) command to use mariabackup for consistent DB backup without locking dbs in production along with compression.
3)How to apply the latest transactions or changes while we do the backups , I mean read somewhere like --apply-log , --prepare both are different and used at different occasions.
4) Restore the backup.
5) Incremental Backups as and its process.
I am not asking to do my job or anything, instead I was pretty confused, everytime I search I end up seeing its fork of xtrabackup and then diving in seeing some --innobackupex and info out there are now confusing.
Since we are using only Mariadb and mariabackup , I would like to understand that now and learn and then I will find out the others all by myself.
mariadb
asked Nov 12 at 6:07
SAGAR BHOOSHAN
1133
add a comment |
We have mariadb Galera Cluster 10.2 using mariabackup as SST. I heard that mariabackup can be used to take Consistent hotbackup of production database without locking since all dbs are innoDB. Currently using mysqldump with --single-transaction ; but this gonna take longer time to backup since DBs are biGger, snapshots like mariabackup will be pretty fast. I need the following :
1) Difference in innobackupex and mariabackup ;
Is there any different in running #> innobackupex and #> mariabackup --innobackupex
2) command to use mariabackup for consistent DB backup without locking dbs in production along with compression.
3)How to apply the latest transactions or changes while we do the backups , I mean read somewhere like --apply-log , --prepare both are different and used at different occasions.
4) Restore the backup.
5) Incremental Backups as and its process.
I am not asking to do my job or anything, instead I was pretty confused, everytime I search I end up seeing its fork of xtrabackup and then diving in seeing some --innobackupex and info out there are now confusing.
Since we are using only Mariadb and mariabackup , I would like to understand that now and learn and then I will find out the others all by myself.
mariadb
asked Nov 12 at 6:07
SAGAR BHOOSHAN
1133
We have mariadb Galera Cluster 10.2 using mariabackup as SST. I heard that mariabackup can be used to take Consistent hotbackup of production database without locking since all dbs are innoDB. Currently using mysqldump with --single-transaction ; but this gonna take longer time to backup since DBs are biGger, snapshots like mariabackup will be pretty fast. I need the following :
1) Difference in innobackupex and mariabackup ;
Is there any different in running #> innobackupex and #> mariabackup --innobackupex
2) command to use mariabackup for consistent DB backup without locking dbs in production along with compression.
3)How to apply the latest transactions or changes while we do the backups , I mean read somewhere like --apply-log , --prepare both are different and used at different occasions.
4) Restore the backup.
5) Incremental Backups as and its process.
I am not asking to do my job or anything, instead I was pretty confused, everytime I search I end up seeing its fork of xtrabackup and then diving in seeing some --innobackupex and info out there are now confusing.
Since we are using only Mariadb and mariabackup , I would like to understand that now and learn and then I will find out the others all by myself.
mariadb
mariadb
asked Nov 12 at 6:07
SAGAR BHOOSHAN
1133
asked Nov 12 at 6:07
SAGAR BHOOSHAN
1133
asked Nov 12 at 6:07
SAGAR BHOOSHAN
1133
asked Nov 12 at 6:07
SAGAR BHOOSHAN
1133
asked Nov 12 at 6:07
SAGAR BHOOSHAN
1133
1133
add a comment |
add a comment |
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53256667%2fhotbackup-for-mariadb-using-mariabackup%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53256667%2fhotbackup-for-mariadb-using-mariabackup%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
