Skip to main content
Share Your Experience: Take the 2024 Developer Survey
2 votes

Should I increase my key_buffer_size?

The answer is no. Why ??? key_buffer_size is a buffer used for MyISAM table index caching. Since you have a 75G buffer pool, you can leave all MyISAM related settings in their default settings. You ...
RolandoMySQLDBA's user avatar
1 vote

MariaDB Galera Cluster (10.6.12) and Laravel WSREP issue

If there are only 3 nodes and 2 of the nodes (2 & 3) were in an ERROR state then the remaining node will not accept any transaction since it does not know the current state of the cluster. See ...
jerichorivera's user avatar
1 vote

MariaDB Galera Cluster galera.cache file getting bigger than specified gcache.size

Solved after upgrading Galera library to 26.4.9 version. The galera.cache does not grow over the specified 128MB gcache.size, using MariaDB 10.4.12 and that Galera version.
Alex Núñez's user avatar
1 vote

How to Prevent the Connections for MariaDB Galera-Cluster When There is Only One Active Node?

Changing the wsrep_sst_method does not change this behaviour - it all depends on whether the remaining node thinks it's the primary partition or not. A partition is the segment of cluster members that ...
Phil Sumner's user avatar
  • 1,877
1 vote

Mariadb 10.1 / Galera - bootstrap node always doesn't lose quorum

I don't think this is a bug. Its an expected behaviour interms of normal shutdown scenario. If you are practicing split-brain testcases then it makes sense for it to loose its Primary status. In your ...
Mannoj's user avatar
  • 1,561
1 vote

WSREP: Writeset deserialization failed: Unsupported RecordSet version: 2: 71 (Protocol error)

You have different versions of the Galera plugin, not the MariaDB server. I had the same issue during deployment, one node was updated and the other two not. Please check on all nodes: (none)> ...
Sybil's user avatar
  • 2,508

Only top scored, non community-wiki answers of a minimum length are eligible