[MDEV-21079] Increase innodb_buffer_pool_size on MariaDB Galera 10.2.25 Created: 2019-11-19  Updated: 2019-12-01

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

Type: Bug Priority: Minor
Reporter: Ras Tarun Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

10.2.25-MariaDB, for Linux (x86_64)



 Description   

We have planned to increase innodb_buffer_pool size from 120 GB to 180 GB on 3 node MariaDB Galera Cluster.

Recently we changed value of innodb_buffer_pool dynamically on ONLY first node and stopped all Nodes.

After restart of all Nodes , we found new value didn't reflect .

We have changed the execution steps , Kindly guide on the steps

1) Stop MariaDB Galera on all three Nodes.

2) Edit my.cnf configuration file on all three Nodes with new value of innodb_buffer_pool
( No need to dynamically change innodb_buffer_pool value on all 3 nodes )

3) Start MariaDB Galera Cluster on all three Nodes in proper sequence.

Kindly advise on the steps prepared.


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