[MDEV-27465] FR: allow to split wsrep_provider_options across multiple option file lines Created: 2022-01-10  Updated: 2022-09-01  Resolved: 2022-09-01

Status: Closed
Project: MariaDB Server
Component/s: Configuration, Galera
Fix Version/s: N/A

Type: Task Priority: Minor
Reporter: Hartmut Holzgraefe Assignee: Ralf Gebhardt
Resolution: Won't Do Votes: 1
Labels: None

Issue Links:
Relates
relates to MDEV-22570 Split wsrep_provider_options in sever... Closed

 Description   

With e.g. optimizer_switch it is possible to change different parameters in that variable on separate option file lines, without overwriting previous changes. E.g.

[mysqld]
optimizer_switch=rowid_filter=off
optimizer_switch=condition_pushdown_from_having=off

changes both the rowid_filter and condition_pushdown_from_having settings to OFF.

With wsrep_provider_options on the other hand each assignments voids the previous one, so e.g.

[mysqld]
wsrep_provider_options=gcs.fc_factor=0.5
wsrep_provider_options=gcs.fc_debug=1

only changes the debug setting, not the factor one.

This makes setting different options rather inconvenient.

For one the assignment line may become rather long when multiple provider options are changed.

Also it is not possible to split settings across multiple option files, e.g. it is not possible this way to put all TLS related settings into a separate option file of its own if both socket options, and other provider options need to be changed.



 Comments   
Comment by Juan [ 2022-01-10 ]

Add to this that it is an inconsistent interface: some wsrep_provider_options can be individually changed dynamically in a running server with "set global", while trying to set individual elements of wsrep_provider_options in a configuration file results in each invocation of wsrep_provider_options completely voiding values set in previous invocations.

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