Which version of xtrabackup to use with MySQL 5.5?
I've just installed a copy of Percona xtrabackup onto my Debian (jessie) server, but when I run it it says that it is:
innobackupex version 2.3.5 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 45cda89)
But I am using MySQL 5.5. Is this the correct version of innobackupex to use with my databases, and if not which version should I use? The documentation isn't very clear.
I installed it using the following process:
apt-key adv --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A
sudo pico /etc/apt/sources.list
then add the following two lines
deb http://repo.percona.com/apt jessie main
deb-src http://repo.percona.com/apt jessie main
apt-get update
apt-get install percona-xtrabackup
mysql mysql-5.5 xtrabackup
edited Oct 27 '16 at 8:49
Philᵀᴹ
25.4k65489
asked Oct 26 '16 at 15:15
IGGtIGGt
9821026
add a comment |
I've just installed a copy of Percona xtrabackup onto my Debian (jessie) server, but when I run it it says that it is:
innobackupex version 2.3.5 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 45cda89)
But I am using MySQL 5.5. Is this the correct version of innobackupex to use with my databases, and if not which version should I use? The documentation isn't very clear.
I installed it using the following process:
apt-key adv --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A
sudo pico /etc/apt/sources.list
then add the following two lines
deb http://repo.percona.com/apt jessie main
deb-src http://repo.percona.com/apt jessie main
apt-get update
apt-get install percona-xtrabackup
mysql mysql-5.5 xtrabackup
edited Oct 27 '16 at 8:49
Philᵀᴹ
25.4k65489
asked Oct 26 '16 at 15:15
IGGtIGGt
9821026
Does it work without error? If so...
– Philᵀᴹ
Oct 26 '16 at 15:22
initially it seems ok, but I didn't want to spend the next few weeks testing it only to find there is some reason that it doesn't work because it is the wrong version.
– IGGt
Oct 26 '16 at 15:47
percona.com/doc/percona-xtrabackup/2.2/index.html says it supports 5.1 5.5 and 5.6
– Philᵀᴹ
Oct 26 '16 at 16:05
So does 2.3 and 2.4. But I'm guessing there's a difference, and that not all features are compatible. If they are, should I therefore be using 2.4?
– IGGt
Oct 27 '16 at 7:46
add a comment |
I've just installed a copy of Percona xtrabackup onto my Debian (jessie) server, but when I run it it says that it is:
innobackupex version 2.3.5 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 45cda89)
But I am using MySQL 5.5. Is this the correct version of innobackupex to use with my databases, and if not which version should I use? The documentation isn't very clear.
I installed it using the following process:
apt-key adv --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A
sudo pico /etc/apt/sources.list
then add the following two lines
deb http://repo.percona.com/apt jessie main
deb-src http://repo.percona.com/apt jessie main
apt-get update
apt-get install percona-xtrabackup
mysql mysql-5.5 xtrabackup
edited Oct 27 '16 at 8:49
Philᵀᴹ
25.4k65489
asked Oct 26 '16 at 15:15
IGGtIGGt
9821026
I've just installed a copy of Percona xtrabackup onto my Debian (jessie) server, but when I run it it says that it is:
innobackupex version 2.3.5 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 45cda89)
But I am using MySQL 5.5. Is this the correct version of innobackupex to use with my databases, and if not which version should I use? The documentation isn't very clear.
I installed it using the following process:
apt-key adv --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A
sudo pico /etc/apt/sources.list
then add the following two lines
deb http://repo.percona.com/apt jessie main
deb-src http://repo.percona.com/apt jessie main
apt-get update
apt-get install percona-xtrabackup
mysql mysql-5.5 xtrabackup
mysql mysql-5.5 xtrabackup
edited Oct 27 '16 at 8:49
Philᵀᴹ
25.4k65489
asked Oct 26 '16 at 15:15
IGGtIGGt
9821026
edited Oct 27 '16 at 8:49
Philᵀᴹ
25.4k65489
asked Oct 26 '16 at 15:15
IGGtIGGt
9821026
edited Oct 27 '16 at 8:49
Philᵀᴹ
25.4k65489
edited Oct 27 '16 at 8:49
Philᵀᴹ
25.4k65489
edited Oct 27 '16 at 8:49
Philᵀᴹ
25.4k65489
25.4k65489
asked Oct 26 '16 at 15:15
IGGtIGGt
9821026
asked Oct 26 '16 at 15:15
IGGtIGGt
9821026
asked Oct 26 '16 at 15:15
IGGtIGGt
9821026
9821026
Does it work without error? If so...
– Philᵀᴹ
Oct 26 '16 at 15:22
initially it seems ok, but I didn't want to spend the next few weeks testing it only to find there is some reason that it doesn't work because it is the wrong version.
– IGGt
Oct 26 '16 at 15:47
percona.com/doc/percona-xtrabackup/2.2/index.html says it supports 5.1 5.5 and 5.6
– Philᵀᴹ
Oct 26 '16 at 16:05
So does 2.3 and 2.4. But I'm guessing there's a difference, and that not all features are compatible. If they are, should I therefore be using 2.4?
– IGGt
Oct 27 '16 at 7:46
add a comment |
Does it work without error? If so...
– Philᵀᴹ
Oct 26 '16 at 15:22
initially it seems ok, but I didn't want to spend the next few weeks testing it only to find there is some reason that it doesn't work because it is the wrong version.
– IGGt
Oct 26 '16 at 15:47
percona.com/doc/percona-xtrabackup/2.2/index.html says it supports 5.1 5.5 and 5.6
– Philᵀᴹ
Oct 26 '16 at 16:05
So does 2.3 and 2.4. But I'm guessing there's a difference, and that not all features are compatible. If they are, should I therefore be using 2.4?
– IGGt
Oct 27 '16 at 7:46
Does it work without error? If so...
– Philᵀᴹ
Oct 26 '16 at 15:22
Does it work without error? If so...
– Philᵀᴹ
Oct 26 '16 at 15:22
initially it seems ok, but I didn't want to spend the next few weeks testing it only to find there is some reason that it doesn't work because it is the wrong version.
– IGGt
Oct 26 '16 at 15:47
initially it seems ok, but I didn't want to spend the next few weeks testing it only to find there is some reason that it doesn't work because it is the wrong version.
– IGGt
Oct 26 '16 at 15:47
percona.com/doc/percona-xtrabackup/2.2/index.html says it supports 5.1 5.5 and 5.6
– Philᵀᴹ
Oct 26 '16 at 16:05
percona.com/doc/percona-xtrabackup/2.2/index.html says it supports 5.1 5.5 and 5.6
– Philᵀᴹ
Oct 26 '16 at 16:05
So does 2.3 and 2.4. But I'm guessing there's a difference, and that not all features are compatible. If they are, should I therefore be using 2.4?
– IGGt
Oct 27 '16 at 7:46
So does 2.3 and 2.4. But I'm guessing there's a difference, and that not all features are compatible. If they are, should I therefore be using 2.4?
– IGGt
Oct 27 '16 at 7:46
add a comment |
2 Answers
2
active
oldest
votes
Percona XtraBackup 2.3 should be backward compatible, so you should be able to use PXB 2.3 with MySQL/Percona Server 5.5. There are some edge cases where you will need to use PXB 2.2 or even 2.1 but it is rarely needed if PXB 2.3 works.
PXB 2.4 is recommended to be used on MySQL/Percona Server 5.7.
In any case, you should always test your backups so backup using PXB 2.3 and restore it on another instance to see if everything works.
answered Oct 27 '16 at 10:40
jerichoriverajerichorivera
61745
add a comment |
I'm checking this, too. I put the same question in the Percona forum:
https://www.percona.com/forums/questions-discussions/percona-xtrabackup/53523-percona-xtrabackup-2-3-9-%C3%A9-compat%C3%ADvel-com-o-mariadb-10-0-37-mysql-5-5-32
answered 13 mins ago
CESAR MURILO DA SILVA JUNIORCESAR MURILO DA SILVA JUNIOR
11
New contributor
CESAR MURILO DA SILVA JUNIOR is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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%2fdba.stackexchange.com%2fquestions%2f153386%2fwhich-version-of-xtrabackup-to-use-with-mysql-5-5%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Percona XtraBackup 2.3 should be backward compatible, so you should be able to use PXB 2.3 with MySQL/Percona Server 5.5. There are some edge cases where you will need to use PXB 2.2 or even 2.1 but it is rarely needed if PXB 2.3 works.
PXB 2.4 is recommended to be used on MySQL/Percona Server 5.7.
In any case, you should always test your backups so backup using PXB 2.3 and restore it on another instance to see if everything works.
answered Oct 27 '16 at 10:40
jerichoriverajerichorivera
61745
add a comment |
Percona XtraBackup 2.3 should be backward compatible, so you should be able to use PXB 2.3 with MySQL/Percona Server 5.5. There are some edge cases where you will need to use PXB 2.2 or even 2.1 but it is rarely needed if PXB 2.3 works.
PXB 2.4 is recommended to be used on MySQL/Percona Server 5.7.
In any case, you should always test your backups so backup using PXB 2.3 and restore it on another instance to see if everything works.
answered Oct 27 '16 at 10:40
jerichoriverajerichorivera
61745
add a comment |
Percona XtraBackup 2.3 should be backward compatible, so you should be able to use PXB 2.3 with MySQL/Percona Server 5.5. There are some edge cases where you will need to use PXB 2.2 or even 2.1 but it is rarely needed if PXB 2.3 works.
PXB 2.4 is recommended to be used on MySQL/Percona Server 5.7.
In any case, you should always test your backups so backup using PXB 2.3 and restore it on another instance to see if everything works.
answered Oct 27 '16 at 10:40
jerichoriverajerichorivera
61745
Percona XtraBackup 2.3 should be backward compatible, so you should be able to use PXB 2.3 with MySQL/Percona Server 5.5. There are some edge cases where you will need to use PXB 2.2 or even 2.1 but it is rarely needed if PXB 2.3 works.
PXB 2.4 is recommended to be used on MySQL/Percona Server 5.7.
In any case, you should always test your backups so backup using PXB 2.3 and restore it on another instance to see if everything works.
answered Oct 27 '16 at 10:40
jerichoriverajerichorivera
61745
answered Oct 27 '16 at 10:40
jerichoriverajerichorivera
61745
answered Oct 27 '16 at 10:40
jerichoriverajerichorivera
61745
answered Oct 27 '16 at 10:40
jerichoriverajerichorivera
61745
61745
add a comment |
add a comment |
I'm checking this, too. I put the same question in the Percona forum:
https://www.percona.com/forums/questions-discussions/percona-xtrabackup/53523-percona-xtrabackup-2-3-9-%C3%A9-compat%C3%ADvel-com-o-mariadb-10-0-37-mysql-5-5-32
answered 13 mins ago
CESAR MURILO DA SILVA JUNIORCESAR MURILO DA SILVA JUNIOR
11
New contributor
CESAR MURILO DA SILVA JUNIOR is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I'm checking this, too. I put the same question in the Percona forum:
https://www.percona.com/forums/questions-discussions/percona-xtrabackup/53523-percona-xtrabackup-2-3-9-%C3%A9-compat%C3%ADvel-com-o-mariadb-10-0-37-mysql-5-5-32
answered 13 mins ago
CESAR MURILO DA SILVA JUNIORCESAR MURILO DA SILVA JUNIOR
11
New contributor
CESAR MURILO DA SILVA JUNIOR is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I'm checking this, too. I put the same question in the Percona forum:
https://www.percona.com/forums/questions-discussions/percona-xtrabackup/53523-percona-xtrabackup-2-3-9-%C3%A9-compat%C3%ADvel-com-o-mariadb-10-0-37-mysql-5-5-32
answered 13 mins ago
CESAR MURILO DA SILVA JUNIORCESAR MURILO DA SILVA JUNIOR
11
New contributor
CESAR MURILO DA SILVA JUNIOR is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I'm checking this, too. I put the same question in the Percona forum:
https://www.percona.com/forums/questions-discussions/percona-xtrabackup/53523-percona-xtrabackup-2-3-9-%C3%A9-compat%C3%ADvel-com-o-mariadb-10-0-37-mysql-5-5-32
answered 13 mins ago
CESAR MURILO DA SILVA JUNIORCESAR MURILO DA SILVA JUNIOR
11
New contributor
CESAR MURILO DA SILVA JUNIOR is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 13 mins ago
CESAR MURILO DA SILVA JUNIORCESAR MURILO DA SILVA JUNIOR
11
New contributor
CESAR MURILO DA SILVA JUNIOR is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 13 mins ago
CESAR MURILO DA SILVA JUNIORCESAR MURILO DA SILVA JUNIOR
11
answered 13 mins ago
CESAR MURILO DA SILVA JUNIORCESAR MURILO DA SILVA JUNIOR
11
11
New contributor
CESAR MURILO DA SILVA JUNIOR is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
CESAR MURILO DA SILVA JUNIOR is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
CESAR MURILO DA SILVA JUNIOR is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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%2fdba.stackexchange.com%2fquestions%2f153386%2fwhich-version-of-xtrabackup-to-use-with-mysql-5-5%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
Does it work without error? If so...
– Philᵀᴹ
Oct 26 '16 at 15:22
initially it seems ok, but I didn't want to spend the next few weeks testing it only to find there is some reason that it doesn't work because it is the wrong version.
– IGGt
Oct 26 '16 at 15:47
percona.com/doc/percona-xtrabackup/2.2/index.html says it supports 5.1 5.5 and 5.6
– Philᵀᴹ
Oct 26 '16 at 16:05
So does 2.3 and 2.4. But I'm guessing there's a difference, and that not all features are compatible. If they are, should I therefore be using 2.4?
– IGGt
Oct 27 '16 at 7:46