[MDEV-15075] mariabackup with specified --host option does not backup data from remote MariaDB Server - Jira

Details

Type: Bug
Status: Open (View Workflow)
Priority: Minor
Resolution: Unresolved
Affects Version/s: 10.2.12
Fix Version/s: 10.2(EOL)
Component/s: Backup, Documentation
Labels:
- foundation
- upstream
Environment:
CentOS 7.4

Description

mariabackup with specified --host option does not backup data from remote MariaDB Server

expected :
backup data from remote MariaDB Server via mariabackup --host option

how to repeat :
1.backup data of remote MariaDB Server t4w6 using mariabackup --host option
2.check the content of the backup-ed data – although the backup started with message
"Connecting to MySQL server host: t4w6" , it's done local backup

note: the same occurs if specify the ip address of the remote MariaDB Server,
backup is starting with message " Connecting to MySQL server host: 192.168.104.196, user: root, passwor..." , but it's done local backup

1
[root@t4w3 mariadb]# mariabackup --host=t4w6 -u root --backup --history=ccc --target-dir=/var/mariadb/backupRw6
180125 19:19:27 Connecting to MySQL server host: t4w6, user: root, password: not set, port: not set, socket: not set
Using server version 10.2.12-MariaDB
mariabackup based on MariaDB server 10.2.12-MariaDB Linux (x86_64)
mariabackup: uses posix_fadvise().
mariabackup: cd to /var/lib/mysql/
mariabackup: open files limit requested 0, set to 1024
mariabackup: using the following InnoDB configuration:
mariabackup: innodb_data_home_dir = .
mariabackup: innodb_data_file_path = ibdata1:12M:autoextend
mariabackup: innodb_log_group_home_dir = ./
2018-01-25 19:19:27 139836746336384 [Note] InnoDB: Number of pools: 1
mariabackup: Can't create/write to file '/var/mariadb/backupRw6/ib_logfile0' (Errcode: 17 "File exists")
mariabackup: error: failed to open the target stream for 'ib_logfile0'.
[root@t4w3 mariadb]# mariabackup --host=t4w6 -u root --backup --history=ccc --target-dir=/var/mariadb/backupR4w6
180125 19:19:45 Connecting to MySQL server host: t4w6, user: root, password: not set, port: not set, socket: not set
Using server version 10.2.12-MariaDB
mariabackup based on MariaDB server 10.2.12-MariaDB Linux (x86_64)
mariabackup: uses posix_fadvise().
mariabackup: cd to /var/lib/mysql/
mariabackup: open files limit requested 0, set to 1024
mariabackup: using the following InnoDB configuration:
mariabackup: innodb_data_home_dir = .
mariabackup: innodb_data_file_path = ibdata1:12M:autoextend
mariabackup: innodb_log_group_home_dir = ./
2018-01-25 19:19:45 140481951557760 [Note] InnoDB: Number of pools: 1
180125 19:19:45 >> log scanned up to (1041449671)
mariabackup: Generating a list of tablespaces
2018-01-25 19:19:45 140481951557760 [Warning] InnoDB: Allocated tablespace ID 3 for mysql/gtid_slave_pos, old maximum was 0
180125 19:19:46 [01] Copying ./ibdata1 to /var/mariadb/backupR4w6/ibdata1
180125 19:19:46 >> log scanned up to (1041449671)
180125 19:19:48 [01] ...done
180125 19:19:48 [01] Copying ./mysql/gtid_slave_pos.ibd to /var/mariadb/backupR4w6/mysql/gtid_slave_pos.ibd
180125 19:19:48 [01] ...done
180125 19:19:48 [01] Copying ./mysql/innodb_index_stats.ibd to /var/mariadb/backupR4w6/mysql/innodb_index_stats.ibd
180125 19:19:48 [01] ...done
180125 19:19:48 [01] Copying ./mysql/innodb_table_stats.ibd to /var/mariadb/backupR4w6/mysql/innodb_table_stats.ibd
180125 19:19:48 [01] ...done
180125 19:19:48 [01] Copying ./boxoffice_mdb/dim_showtime.ibd to /var/mariadb/backupR4w6/boxoffice_mdb/dim_showtime.ibd
180125 19:19:50 [01] ...done
180125 19:19:50 [01] Copying ./boxoffice_mdb/fact_tickets.ibd to /var/mariadb/backupR4w6/boxoffice_mdb/fact_tickets.ibd
180125 19:19:56 [01] ...done
180125 19:19:56 [01] Copying ./PERCONA_SCHEMA/xtrabackup_history.ibd to /var/mariadb/backupR4w6/PERCONA_SCHEMA/xtrabackup_history.ibd
180125 19:19:56 [01] ...done
180125 19:19:57 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...
180125 19:19:57 Executing FLUSH TABLES WITH READ LOCK...
180125 19:19:57 Starting to backup non-InnoDB tables and files
180125 19:19:57 [01] Copying ./mysql/roles_mapping.MYI to /var/mariadb/backupR4w6/mysql/roles_mapping.MYI
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/column_stats.MYD to /var/mariadb/backupR4w6/mysql/column_stats.MYD
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/table_stats.MYI to /var/mariadb/backupR4w6/mysql/table_stats.MYI
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/column_stats.MYI to /var/mariadb/backupR4w6/mysql/column_stats.MYI
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/table_stats.frm to /var/mariadb/backupR4w6/mysql/table_stats.frm
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/column_stats.frm to /var/mariadb/backupR4w6/mysql/column_stats.frm
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/procs_priv.MYI to /var/mariadb/backupR4w6/mysql/procs_priv.MYI
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/func.MYD to /var/mariadb/backupR4w6/mysql/func.MYD
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/columns_priv.MYI to /var/mariadb/backupR4w6/mysql/columns_priv.MYI
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/func.frm to /var/mariadb/backupR4w6/mysql/func.frm
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/db.frm to /var/mariadb/backupR4w6/mysql/db.frm
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/event.frm to /var/mariadb/backupR4w6/mysql/event.frm
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/host.MYD to /var/mariadb/backupR4w6/mysql/host.MYD
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/user.MYI to /var/mariadb/backupR4w6/mysql/user.MYI
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/procs_priv.frm to /var/mariadb/backupR4w6/mysql/procs_priv.frm
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/user.MYD to /var/mariadb/backupR4w6/mysql/user.MYD
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/time_zone.MYD to /var/mariadb/backupR4w6/mysql/time_zone.MYD
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/general_log.CSM to /var/mariadb/backupR4w6/mysql/general_log.CSM
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/time_zone.MYI to /var/mariadb/backupR4w6/mysql/time_zone.MYI
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/general_log.CSV to /var/mariadb/backupR4w6/mysql/general_log.CSV
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/time_zone.frm to /var/mariadb/backupR4w6/mysql/time_zone.frm
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/general_log.frm to /var/mariadb/backupR4w6/mysql/general_log.frm
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/time_zone_leap_second.MYD to /var/mariadb/backupR4w6/mysql/time_zone_leap_second.MYD
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/gtid_slave_pos.frm to /var/mariadb/backupR4w6/mysql/gtid_slave_pos.frm
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/time_zone_leap_second.MYI to /var/mariadb/backupR4w6/mysql/time_zone_leap_second.MYI
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/time_zone_leap_second.frm to /var/mariadb/backupR4w6/mysql/time_zone_leap_second.frm
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/help_category.MYD to /var/mariadb/backupR4w6/mysql/help_category.MYD
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/time_zone_name.MYD to /var/mariadb/backupR4w6/mysql/time_zone_name.MYD
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/help_category.MYI to /var/mariadb/backupR4w6/mysql/help_category.MYI
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/time_zone_name.MYI to /var/mariadb/backupR4w6/mysql/time_zone_name.MYI
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/help_category.frm to /var/mariadb/backupR4w6/mysql/help_category.frm
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/time_zone_name.frm to /var/mariadb/backupR4w6/mysql/time_zone_name.frm
180125 19:19:57 [01] ...done
180125 19:19:57 [01] Copying ./mysql/help_keyword.MYD to /var/mariadb/backupR4w6/mysql/help_keyword.MYD
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/time_zone_transition.MYD to /var/mariadb/backupR4w6/mysql/time_zone_transition.MYD
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/help_keyword.MYI to /var/mariadb/backupR4w6/mysql/help_keyword.MYI
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/time_zone_transition.MYI to /var/mariadb/backupR4w6/mysql/time_zone_transition.MYI
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/help_keyword.frm to /var/mariadb/backupR4w6/mysql/help_keyword.frm
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/time_zone_transition.frm to /var/mariadb/backupR4w6/mysql/time_zone_transition.frm
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/help_relation.MYD to /var/mariadb/backupR4w6/mysql/help_relation.MYD
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/help_relation.MYI to /var/mariadb/backupR4w6/mysql/help_relation.MYI
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/help_relation.frm to /var/mariadb/backupR4w6/mysql/help_relation.frm
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/help_topic.MYD to /var/mariadb/backupR4w6/mysql/help_topic.MYD
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/help_topic.MYI to /var/mariadb/backupR4w6/mysql/help_topic.MYI
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/help_topic.frm to /var/mariadb/backupR4w6/mysql/help_topic.frm
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/user.frm to /var/mariadb/backupR4w6/mysql/user.frm
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/host.frm to /var/mariadb/backupR4w6/mysql/host.frm
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/index_stats.MYD to /var/mariadb/backupR4w6/mysql/index_stats.MYD
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/index_stats.MYI to /var/mariadb/backupR4w6/mysql/index_stats.MYI
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/index_stats.frm to /var/mariadb/backupR4w6/mysql/index_stats.frm
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/time_zone_transition_type.MYD to /var/mariadb/backupR4w6/mysql/time_zone_transition_type.MYD
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/innodb_index_stats.frm to /var/mariadb/backupR4w6/mysql/innodb_index_stats.frm
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/proxies_priv.MYI to /var/mariadb/backupR4w6/mysql/proxies_priv.MYI
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/proxies_priv.frm to /var/mariadb/backupR4w6/mysql/proxies_priv.frm
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/innodb_table_stats.frm to /var/mariadb/backupR4w6/mysql/innodb_table_stats.frm
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/roles_mapping.MYD to /var/mariadb/backupR4w6/mysql/roles_mapping.MYD
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/plugin.MYI to /var/mariadb/backupR4w6/mysql/plugin.MYI
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/proc.MYD to /var/mariadb/backupR4w6/mysql/proc.MYD
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/proc.MYI to /var/mariadb/backupR4w6/mysql/proc.MYI
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/proc.frm to /var/mariadb/backupR4w6/mysql/proc.frm
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/proxies_priv.MYD to /var/mariadb/backupR4w6/mysql/proxies_priv.MYD
180125 19:19:58 [01] ...done
180125 19:19:58 [01] Copying ./mysql/roles_mapping.frm to /var/mariadb/backupR4w6/mysql/roles_mapping.frm
180125 19:19:58 [01] ...done
180125 19:19:59 [01] Copying ./mysql/servers.MYD to /var/mariadb/backupR4w6/mysql/servers.MYD
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./mysql/servers.MYI to /var/mariadb/backupR4w6/mysql/servers.MYI
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./mysql/servers.frm to /var/mariadb/backupR4w6/mysql/servers.frm
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./mysql/slow_log.CSM to /var/mariadb/backupR4w6/mysql/slow_log.CSM
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./mysql/slow_log.CSV to /var/mariadb/backupR4w6/mysql/slow_log.CSV
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./mysql/slow_log.frm to /var/mariadb/backupR4w6/mysql/slow_log.frm
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./mysql/table_stats.MYD to /var/mariadb/backupR4w6/mysql/table_stats.MYD
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./mysql/time_zone_transition_type.MYI to /var/mariadb/backupR4w6/mysql/time_zone_transition_type.MYI
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./mysql/time_zone_transition_type.frm to /var/mariadb/backupR4w6/mysql/time_zone_transition_type.frm
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./mysql/tables_priv.MYD to /var/mariadb/backupR4w6/mysql/tables_priv.MYD
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./mysql/tables_priv.frm to /var/mariadb/backupR4w6/mysql/tables_priv.frm
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./mysql/columns_priv.MYD to /var/mariadb/backupR4w6/mysql/columns_priv.MYD
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./mysql/plugin.MYD to /var/mariadb/backupR4w6/mysql/plugin.MYD
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./mysql/event.MYD to /var/mariadb/backupR4w6/mysql/event.MYD
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./mysql/host.MYI to /var/mariadb/backupR4w6/mysql/host.MYI
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./mysql/columns_priv.frm to /var/mariadb/backupR4w6/mysql/columns_priv.frm
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./mysql/plugin.frm to /var/mariadb/backupR4w6/mysql/plugin.frm
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./mysql/event.MYI to /var/mariadb/backupR4w6/mysql/event.MYI
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./mysql/tables_priv.MYI to /var/mariadb/backupR4w6/mysql/tables_priv.MYI
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./mysql/procs_priv.MYD to /var/mariadb/backupR4w6/mysql/procs_priv.MYD
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./mysql/db.MYI to /var/mariadb/backupR4w6/mysql/db.MYI
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./mysql/db.MYD to /var/mariadb/backupR4w6/mysql/db.MYD
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./mysql/func.MYI to /var/mariadb/backupR4w6/mysql/func.MYI
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./boxoffice_mdb/db.opt to /var/mariadb/backupR4w6/boxoffice_mdb/db.opt
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./boxoffice_mdb/dim_showtime.frm to /var/mariadb/backupR4w6/boxoffice_mdb/dim_showtime.frm
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./boxoffice_mdb/fact_tickets.frm to /var/mariadb/backupR4w6/boxoffice_mdb/fact_tickets.frm
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./test/db.opt to /var/mariadb/backupR4w6/test/db.opt
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./performance_schema/db.opt to /var/mariadb/backupR4w6/performance_schema/db.opt
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./PERCONA_SCHEMA/db.opt to /var/mariadb/backupR4w6/PERCONA_SCHEMA/db.opt
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying ./PERCONA_SCHEMA/xtrabackup_history.frm to /var/mariadb/backupR4w6/PERCONA_SCHEMA/xtrabackup_history.frm
180125 19:19:59 [01] ...done
180125 19:19:59 Finished backing up non-InnoDB tables and files
180125 19:19:59 [01] Copying aria_log.00000001 to /var/mariadb/backupR4w6/aria_log.00000001
180125 19:19:59 [01] ...done
180125 19:19:59 [01] Copying aria_log_control to /var/mariadb/backupR4w6/aria_log_control
180125 19:19:59 [01] ...done
180125 19:19:59 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
mariabackup: The latest check point (for incremental): '1041449608'
mariabackup: Stopping log copying thread.

180125 19:19:59 >> log scanned up to (1041449671)
180125 19:19:59 Executing UNLOCK TABLES
180125 19:19:59 All tables unlocked
180125 19:19:59 [00] Copying ib_buffer_pool to /var/mariadb/backupR4w6/ib_buffer_pool
180125 19:19:59 [00] ...done
180125 19:20:00 Backup created in directory '/var/mariadb/backupR4w6/'
180125 19:20:00 [00] Writing backup-my.cnf
180125 19:20:00 [00] ...done
180125 19:20:00 [00] Writing xtrabackup_info
180125 19:20:00 [00] ...done
mariabackup: Redo log (from LSN 1041449662 to 1041449671) was copied.
180125 19:20:00 completed OK!

[root@t4w3 mariadb]# ls /var/mariadb/backupR4w6

aria_log.00000001  backup-my.cnf  ib_buffer_pool  ib_logfile0  PERCONA_SCHEMA      test                    xtrabackup_info

aria_log_control   boxoffice_mdb  ibdata1         mysql        performance_schema  xtrabackup_checkpoints

[root@t4w3 mariadb]# ls /var/mariadb/backupR4w6/boxoffice_mdb/

db.opt  dim_showtime.frm  dim_showtime.ibd  fact_tickets.frm  fact_tickets.ibd

2 .check the content of the backuped data – although the backup started with message
"Connecting to MySQL server host: t4w6" , it's done local backup

2
[root@t4w3 mariadb]# ls /var/mariadb/backupR4w6/boxoffice_mdb/
db.opt dim_showtime.frm dim_showtime.ibd fact_tickets.frm fact_tickets.ibd

[root@t4w3 mariadb]# mysql -h t4w6 -u root

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 339

Server version: 10.2.12-MariaDB MariaDB Server

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show tables from boxoffice_mdb  ;

+-------------------------+

| Tables_in_boxoffice_mdb |

+-------------------------+

| dim_showtime            |

| dim_theater             |

| dim_theater_mdc         |

| dim_ticket_type         |

| dim_title               |

| fact_tickets            |

+-------------------------+

6 rows in set (0.00 sec)

note: the same occurs of specify the ip address of the MariaDB Server,
backup is starting with message " Connecting to MySQL server host: 192.168.104.196, user: root, passwor..." , but it's done local backup

mariabackup --host=192.168.104.196 -u root --backup --history=ccc   --target-dir=/var/mariadb/backupRt4w6

180125 19:21:26 Connecting to MySQL server host: 192.168.104.196, user: root, password: not set, port: not set, socket: not set

Using server version 10.2.12-MariaDB

mariabackup based on MariaDB server 10.2.12-MariaDB Linux (x86_64)

~~~~~~

[root@t4w3 mariadb]# ls /var/mariadb/backupRt4w6/boxoffice_mdb/

db.opt  dim_showtime.frm  dim_showtime.ibd  fact_tickets.frm  fact_tickets.ibd

Attachments

Activity

Ascending order - Click to sort in descending order

Zdravelina Sokolovska (Inactive) added a comment - 2018-01-25 18:01

the same occurs of specify the ip address of the remote MariaDB Server instaed of domain name :
backup is starting with message " Connecting to MySQL server host: 192.168.104.196, user: root, passwor..." , but it's done local backup

Zdravelina Sokolovska (Inactive) added a comment - 2018-01-25 18:01 the same occurs of specify the ip address of the remote MariaDB Server instaed of domain name : backup is starting with message " Connecting to MySQL server host: 192.168.104.196, user: root, passwor..." , but it's done local backup

Vladislav Vaintroub added a comment - 2018-01-26 17:52

mariabackup, just like its predecessor xtrabackup, was not designed to work on remote boxes.
It copies files physically, from datadirectory it reads from the server, to backup directory (or stream)
mariabackup still need to issue some SQL commands,(including reading Innodb's Information schema tables, "FLUSH TABLES WITH READ LOCK" etc), so it needs to connect to the server.

Now, there are couple of technicalities to consider

User identity in MariaDB is user name and IP address. Thus you might have to connect specifying IP addresses (in case you have several network interface cards, you can choose via which address you connect), or (one of) DNS names, or 127.0.0.1, or ::1 . You can also connect via unix domain socket, windows named pipe or even shared memory. It is a bit cumbersome to check whether it is a local connection, but it can be done.
Even if not designed to work on remote boxes, one can imagine a situation where is works and is valid. Imagine 2 machines, one with the server, another one with mariabackup, that share data directory, and it is mapped to the same place on both machines. Backup is possible in this case, and one could argue, not exactly illegal.

Vladislav Vaintroub added a comment - 2018-01-26 17:52 mariabackup, just like its predecessor xtrabackup, was not designed to work on remote boxes. It copies files physically, from datadirectory it reads from the server, to backup directory (or stream) mariabackup still need to issue some SQL commands,(including reading Innodb's Information schema tables, "FLUSH TABLES WITH READ LOCK" etc), so it needs to connect to the server. Now, there are couple of technicalities to consider User identity in MariaDB is user name and IP address. Thus you might have to connect specifying IP addresses (in case you have several network interface cards, you can choose via which address you connect), or (one of) DNS names, or 127.0.0.1, or ::1 . You can also connect via unix domain socket, windows named pipe or even shared memory. It is a bit cumbersome to check whether it is a local connection, but it can be done. Even if not designed to work on remote boxes, one can imagine a situation where is works and is valid. Imagine 2 machines, one with the server, another one with mariabackup, that share data directory, and it is mapped to the same place on both machines. Backup is possible in this case, and one could argue, not exactly illegal.

Zdravelina Sokolovska (Inactive) added a comment - 2018-01-26 18:13

RE Vladislav Vaintroub >>mariabackup, just like its predecessor xtrabackup, was not designed to work on remote boxes.
wlad Vladislav Vaintroub
then what's the option --host stands for ?
]# mariabackup | grep host
mariabackup based on MariaDB server 10.2.12-MariaDB Linux (x86_64)
-H, --host=name This option specifies the host to use when connecting to
host (No default value)

&& from user guide:
-H, --host
Defines the host for the MariaDB Server you want to backup.
--host=name
Using this option, you can define the host to use when connecting to a MariaDB Server over TCP/IP.

that issue in that case should be even set with critical severity because user may figure out that it is backpacking
any Remote MariaDB Server, but actually the it get something different ;

Zdravelina Sokolovska (Inactive) added a comment - 2018-01-26 18:13 RE Vladislav Vaintroub >>mariabackup, just like its predecessor xtrabackup, was not designed to work on remote boxes. wlad Vladislav Vaintroub then what's the option --host stands for ? ]# mariabackup | grep host mariabackup based on MariaDB server 10.2.12-MariaDB Linux (x86_64) -H, --host=name This option specifies the host to use when connecting to host (No default value) && from user guide: -H, --host Defines the host for the MariaDB Server you want to backup. --host=name Using this option, you can define the host to use when connecting to a MariaDB Server over TCP/IP. that issue in that case should be even set with critical severity because user may figure out that it is backpacking any Remote MariaDB Server, but actually the it get something different ;

Vladislav Vaintroub added a comment - 2018-01-26 18:30 - edited

--host stands for this

it can be 127.0.0.1 if you want to connect over TCPv4-localhost(and your backup user has the form 'user'@'127.0.0.1')
it can be ::1 if you want to connect connect over TCPv6-localhost(you backup user has the form 'user'@'::1')
it can be one of the fully qualified DNS names of your computer, or one of your IP addresses (if you have several network interface cards, you may have both IPv4 and IPv6 addresses for each if them)
it can be localhost, in which case the connection on Unixes is done via unix domain socket

mariabackup needs to connect to server, thus it uses "host". mariabackup is a (special) client utility. Every client utility uses --host , Most importantly, dependent on how what you write in --host, you may connect with entirely different user, or not be able to connect at all. Even from the same local machine. User in MariaDB server is generally a combination of name and IP, and --host lets you control the IP.

Feel free to fix "user guide ( if you mean Knowlegde base article), or file a documentation bug if you think this is more appropriate

Vladislav Vaintroub added a comment - 2018-01-26 18:30 - edited --host stands for this it can be 127.0.0.1 if you want to connect over TCPv4-localhost(and your backup user has the form 'user'@'127.0.0.1') it can be ::1 if you want to connect connect over TCPv6-localhost(you backup user has the form 'user'@'::1') it can be one of the fully qualified DNS names of your computer, or one of your IP addresses (if you have several network interface cards, you may have both IPv4 and IPv6 addresses for each if them) it can be localhost, in which case the connection on Unixes is done via unix domain socket mariabackup needs to connect to server, thus it uses "host". mariabackup is a (special) client utility. Every client utility uses --host , Most importantly, dependent on how what you write in --host, you may connect with entirely different user, or not be able to connect at all. Even from the same local machine. User in MariaDB server is generally a combination of name and IP, and --host lets you control the IP. Feel free to fix "user guide ( if you mean Knowlegde base article), or file a documentation bug if you think this is more appropriate

Vladislav Vaintroub added a comment - 2018-01-26 18:37 - edited

That mariabackup does not work remotely, is common knowlegde. Xtrabackup never worked remotely, and it exists since 2009. I agree that it might be confusing, for a first time user, but it is what it is, it is a clone a another thing they worked like this for almost a decade.

Vladislav Vaintroub added a comment - 2018-01-26 18:37 - edited That mariabackup does not work remotely, is common knowlegde. Xtrabackup never worked remotely, and it exists since 2009. I agree that it might be confusing, for a first time user, but it is what it is, it is a clone a another thing they worked like this for almost a decade.

vigneshkumar added a comment - 2022-08-30 18:19 - edited

Is there a way to have the remote server data called in from host where your'e calling mariabackup. Eventually this is taking backup from local which doesn't make sense to have a broken cluster data and run into seamlessly running log consistency checks.
So are we having any option to deal this locally? i see a -h directory but its not helping my requirement.

Problem is we are routing the connection to --host=remote host and its complaining on local server. for which you will lead up to errors like open files and open os files error issues. which is misleading the engineers.

Please let us know if there is a workaround or fix to it in the near future.

Thanks & Regards,
Viggu

vigneshkumar added a comment - 2022-08-30 18:19 - edited Is there a way to have the remote server data called in from host where your'e calling mariabackup. Eventually this is taking backup from local which doesn't make sense to have a broken cluster data and run into seamlessly running log consistency checks. So are we having any option to deal this locally? i see a -h directory but its not helping my requirement. Problem is we are routing the connection to --host=remote host and its complaining on local server. for which you will lead up to errors like open files and open os files error issues. which is misleading the engineers. Please let us know if there is a workaround or fix to it in the near future. Thanks & Regards, Viggu

Vladislav Lesin added a comment - 2023-05-03 07:22

I would close is as "won't fix" as we have xbstream, which can stream backup, and that stream can be redirected to network with standard GNU tools like nc.

Vladislav Lesin added a comment - 2023-05-03 07:22 I would close is as "won't fix" as we have xbstream, which can stream backup, and that stream can be redirected to network with standard GNU tools like nc.

People

Assignee:: Ian Gilfillan

Reporter:: Zdravelina Sokolovska (Inactive)

Votes:: 4 Vote for this issue

Watchers:: 8 Start watching this issue

Dates

Created:: 2018-01-25 17:43

Updated:: 2025-02-06 07:19

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.