$ xtrabackup --help | grep "binlog-info"
xtrabackup: recognized server arguments: --datadir=/var/lib/mysql/
xtrabackup: recognized client arguments: --socket=/var/lib/mysql/mysql.sock
xtrabackup version 8.0.13 based on MySQL server 8.0.20 Linux (x86_64) (revision id: fdf0f4c)
Test:
$ xtrabackup --defaults-file=/home/lalit/sandboxes/msb_8_0_20/my.sandbox.cnf --datadir=/home/lalit/sandboxes/msb_8_0_20/data --user=msandbox --password=msandbox --socket=/tmp/mysql_sandbox8020.sock --backup --target-dir=./backup --binlog-info=ON
xtrabackup: recognized server arguments: --datadir=/home/lalit/sandboxes/msb_8_0_20/data --tmpdir=/home/lalit/sandboxes/msb_8_0_20/tmp --datadir=/home/lalit/sandboxes/msb_8_0_20/data
xtrabackup: recognized client arguments: --user=msandbox --password=* --port=8020 --socket=/tmp/mysql_sandbox8020.sock --user=msandbox --password=* --socket=/tmp/mysql_sandbox8020.sock --backup=1 --target-dir=./backup
xtrabackup version 8.0.13 based on MySQL server 8.0.20 Linux (x86_64) (revision id: fdf0f4c)
200804 18:28:27 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=8020;mysql_socket=/tmp/mysql_sandbox8020.sock' as 'msandbox' (using password: YES).
200804 18:28:27 version_check Connected to MySQL server
200804 18:28:27 version_check Executing a version check against the server...
200804 18:28:27 version_check Done.
200804 18:28:27 Connecting to MySQL server host: localhost, user: msandbox, password: set, port: 8020, socket: /tmp/mysql_sandbox8020.sock
Using server version 8.0.20-11
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /home/lalit/sandboxes/msb_8_0_20/data
xtrabackup: open files limit requested 0, set to 1024
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_data_home_dir = .
xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 50331648
Number of pools: 1
WARNING: unknown option --binlog-info=ON
Same option available in xtrabackup-24
# xtrabackup --help | grep "binlog-info"
xtrabackup: recognized server arguments:
xtrabackup: recognized client arguments: --user=aeou --socket=/path/to/socket/mysql.sock
xtrabackup version 2.4.20 based on MySQL server 5.7.26 Linux (x86_64) (revision id: c8b4056)
--binlog-info[=name]
binlog-info auto
Environment
None
AFFECTED CS IDs
276991
Smart Checklist
Activity
Lalit Choudhary October 1, 2021 at 7:46 AM
@Marcelo Altmann
The link I provided is for --binlog-info option no more exists in 8.0 so looks like it was removed.
Yes If no doc I assume that option is not for 8.0. Closing it.
Marcelo Altmann September 30, 2021 at 11:59 AM
@Lalit Choudhary can you please double-check this one. For 8.0 we always gather binlog information from ps.log_status table.
As per the latest xtrabackup documentation --binlog-file should be in xtrabackup 8.0 but it's missing.
https://www.percona.com/doc/percona-xtrabackup/8.0/advanced/lockless_bin-log.html
$ xtrabackup --help | grep "binlog-info" xtrabackup: recognized server arguments: --datadir=/var/lib/mysql/ xtrabackup: recognized client arguments: --socket=/var/lib/mysql/mysql.sock xtrabackup version 8.0.13 based on MySQL server 8.0.20 Linux (x86_64) (revision id: fdf0f4c)Test:
$ xtrabackup --defaults-file=/home/lalit/sandboxes/msb_8_0_20/my.sandbox.cnf --datadir=/home/lalit/sandboxes/msb_8_0_20/data --user=msandbox --password=msandbox --socket=/tmp/mysql_sandbox8020.sock --backup --target-dir=./backup --binlog-info=ON xtrabackup: recognized server arguments: --datadir=/home/lalit/sandboxes/msb_8_0_20/data --tmpdir=/home/lalit/sandboxes/msb_8_0_20/tmp --datadir=/home/lalit/sandboxes/msb_8_0_20/data xtrabackup: recognized client arguments: --user=msandbox --password=* --port=8020 --socket=/tmp/mysql_sandbox8020.sock --user=msandbox --password=* --socket=/tmp/mysql_sandbox8020.sock --backup=1 --target-dir=./backup xtrabackup version 8.0.13 based on MySQL server 8.0.20 Linux (x86_64) (revision id: fdf0f4c) 200804 18:28:27 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=8020;mysql_socket=/tmp/mysql_sandbox8020.sock' as 'msandbox' (using password: YES). 200804 18:28:27 version_check Connected to MySQL server 200804 18:28:27 version_check Executing a version check against the server... 200804 18:28:27 version_check Done. 200804 18:28:27 Connecting to MySQL server host: localhost, user: msandbox, password: set, port: 8020, socket: /tmp/mysql_sandbox8020.sock Using server version 8.0.20-11 xtrabackup: uses posix_fadvise(). xtrabackup: cd to /home/lalit/sandboxes/msb_8_0_20/data xtrabackup: open files limit requested 0, set to 1024 xtrabackup: using the following InnoDB configuration: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 50331648 Number of pools: 1 WARNING: unknown option --binlog-info=ONSame option available in xtrabackup-24
# xtrabackup --help | grep "binlog-info" xtrabackup: recognized server arguments: xtrabackup: recognized client arguments: --user=aeou --socket=/path/to/socket/mysql.sock xtrabackup version 2.4.20 based on MySQL server 5.7.26 Linux (x86_64) (revision id: c8b4056) --binlog-info[=name] binlog-info auto