2014-08-12 10:23:16 |
melon |
bug |
|
|
added bug |
2014-08-13 00:20:45 |
melon |
description |
I'm testing percona-xtrabackup-2.2.3 to backup our databases based on mysql-5.1.63. It's awesome. I'm preparing to use it in our production environment. But today when i do my backup test i notice that there is a warning such like following:
"innobackupex: Warning: FLUSH ENGINE LOGS is not supported by the server. Data may be inconsistent with binary log coordinates!
Wil the backup have very less chance to be inconsistent when we don't use "FLUSH ENGINE LOGS"? If not, will it be better if we use "FLUSH LOGS" rather than just give a warning when we backup the databases based on mysql-5.1.x?
please give me some advice
best regards!
melon |
I'm testing percona-xtrabackup-2.2.3 to backup our databases based on mysql-5.1.63. It's awesome. I'm preparing to use it in our production environment. But today when i do my backup test i noticed that there is a warning such like following:
"innobackupex: Warning: FLUSH ENGINE LOGS is not supported by the server. Data may be inconsistent with binary log coordinates!
Wil the backup have very less chance to be inconsistent when we don't use "FLUSH ENGINE LOGS"? If not, will it be better if we use "FLUSH LOGS" rather than just give a warning when we backup the databases based on mysql-5.1.x?
please give me some advice
best regards!
melon |
|
2014-08-13 00:38:42 |
melon |
description |
I'm testing percona-xtrabackup-2.2.3 to backup our databases based on mysql-5.1.63. It's awesome. I'm preparing to use it in our production environment. But today when i do my backup test i noticed that there is a warning such like following:
"innobackupex: Warning: FLUSH ENGINE LOGS is not supported by the server. Data may be inconsistent with binary log coordinates!
Wil the backup have very less chance to be inconsistent when we don't use "FLUSH ENGINE LOGS"? If not, will it be better if we use "FLUSH LOGS" rather than just give a warning when we backup the databases based on mysql-5.1.x?
please give me some advice
best regards!
melon |
I'm testing percona-xtrabackup-2.2.3 to backup our databases based on mysql-5.1.63. It's awesome. I'm preparing to use it in our production environment. But today when i do my backup test i noticed that there is a warning such like following:
"innobackupex: Warning: FLUSH ENGINE LOGS is not supported by the server. Data may be inconsistent with binary log coordinates!
Wil the backup have very less chance to be inconsistent when we don't use "FLUSH ENGINE LOGS"? If not, will it be better if we use "FLUSH LOGS" rather than just give a warning when we backup the databases based on mysql-5.1.x?
please give me some advice
BTW,I found that the following source which check the condition to eject the warning is not very correct.
4857 if ($mysql{vars}->{version}->{Value} =~ m/5.[123]\.\d/) {
should be
4857 if ($mysql{vars}->{version}->{Value} =~ m/5\.[123]\.\d/) {
best regards!
melon |
|
2014-08-15 15:02:21 |
Alexey Kopytov |
percona-xtrabackup: status |
New |
Invalid |
|