[MDEV-12025] xtrabackup configuration parser Created: 2017-02-08  Updated: 2017-02-25

Status: Open
Project: MariaDB Server
Component/s: Backup
Fix Version/s: None

Type: Task Priority: Major
Reporter: Michaël de groot Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-12118 Change config defaults in innobackupe... Open

 Description   

Hi,

There is an inconsistency in how MariaDB Server reads the configuration and xtrabackup reads the configuration. This results in to many quirks:

  1. For xtrabackup --move-back or --copy-back, datadir needs to be present in /etc/my.cnf - no other configuration file works at all. This results in SST not working if it it not present or in /etc/my.cnf.d/server.cnf.
  2. If innodb_log_files_in_group is present in 2 configuration files, creating the backup fails (some times, I assume when 1 value is lower then the other and the server is writing to higher redo log files then xtrabackup knows about).
  3. For some operations (I don't remember which exactly), socket needs to be present in configuration file. This also needs to be present in /etc/my.cnf.

wlad mentioned it would be great if xtrabackup logs in to MariaDB and gets the configuration file from mariadb. I can imagine this works for most configurations but not all configurations (such as how to connect to the server).

The latter is needed for --copy-back and --move-back to work. To avoid double work I think it might be best to have the same mechanism of configuration file parsing in xtrabackup as MariaDB has. We can also make the target data directory a required argument when --move-back is used, and only read configurations from the running server.

Cheers,



 Comments   
Comment by Vladislav Vaintroub [ 2017-02-08 ]

I'm not sure where the actual problem lies, in xtrabackup, in SST scripts, or elsewhere.. I'm not even sure if our fork exposes the same problem

Generated at Thu Feb 08 07:54:32 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.