[MXS-4748] Add functionality so that rebuild-server will work with non default configuration of datadir and binlogs Created: 2023-09-08  Updated: 2024-02-05  Resolved: 2024-01-15

Status: Closed
Project: MariaDB MaxScale
Component/s: mariadbmon
Affects Version/s: 22.08.4
Fix Version/s: 24.02.0

Type: New Feature Priority: Major
Reporter: Maria M Pflaum Assignee: Esa Korhonen
Resolution: Fixed Votes: 0
Labels: None

Sprint: MXS-SPRINT-199

 Description   

Is there anyway to use MariaDB monitor's rebuild-server option but have the data go to a different directory than /var/lib/mysql? Can it read the datadir and binlog directories from the target server before it stops MariaDB-server on the target machine. Maybe also clear out the temp directory.



 Comments   
Comment by Maria M Pflaum [ 2023-09-13 ]

More comments regarding this functionality:
May want to consider using "mariabackup --prepare" and "mariabackup --move-back" if possible. This follows the directory setup as specified in my.cnf and my.cnf.d.

This customer would need the --use-memory flag to be configurable on the maxctrl side for "mariabackup --prepare". The default 1GB isn't sufficient for their database size and the command tends to fail. They have their restore script set to 8G.

Generated at Thu Feb 08 04:30:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.