<commit_before># This file contains wsrep-related mysqld options. It should be included
# in the main MySQL configuration file.
#
# Options that need to be customized:
#  - wsrep_provider
#  - wsrep_cluster_address
#  - wsrep_sst_auth
# The rest of defaults should work out of the box.

##
## mysqld options _MANDATORY_ for correct opration of the cluster
##
[mysqld]

# (This must be substituted by wsrep_format)
binlog_format=ROW

# Currently only InnoDB storage engine is supported
default-storage-engine=innodb

# to avoid issues with 'bulk mode inserts' using autoinc
innodb_autoinc_lock_mode=2

# This is a must for paralell applying
innodb_locks_unsafe_for_binlog=1

# Query Cache is not supported with wsrep
query_cache_size=0
query_cache_type=0

# Override bind-address
# In some systems bind-address defaults to 127.0.0.1, and with mysqldump SST
# it will have (most likely) disastrous consequences on donor node
bind-address=0.0.0.0
port=3307

##
## WSREP options
##

# Full path to wsrep provider library or 'none'
wsrep_provider=<%= libgalera_prefix %>/galera/libgalera_smm.so

# Provider specific configuration options

# See http://www.codership.com/wiki/doku.php?id=faq



wsrep_provider_options="pc.ignore_sb = no;ist.recv_addr=<%= node_address %>"

# Logical cluster name. Should be the same for all nodes.
wsrep_cluster_name="<%= cluster_name -%>"
<% if galera_gcomm_empty -%>
<% if setup_multiple_gcomm -%>
    <% if master_ip -%>
wsrep_cluster_address="gcomm://<%= @node_addresses.collect {|ip| ip + ':' + 4567.to_s }.join ',' %>"
    <% else -%>
        wsrep_cluster_address="gcomm://"
    <% end -%>
<% else -%>
    <% if master_ip -%>
wsrep_cluster_address="gcomm://<%= master_ip %>:4567"
    <% else -%>
wsrep_cluster_address="gcomm://"
    <% end -%>
<% end -%>
<% end -%>


# Human-readable node name (non-unique). Hostname by default.
#wsrep_node_name=

# Base replication <address|hostname>[:port] of the node.
# The values supplied will be used as defaults for state transfer receiving,
# listening ports and so on. Default: address of the first network interface.
wsrep_node_address=<%= node_address %>

# Address for incoming client connections. Autodetect by default.
#wsrep_node_incoming_address=

# How many threads will process writesets from other nodes
wsrep_slave_threads=2

# DBUG options for wsrep provider
#wsrep_dbug_option

# Generate fake primary keys for non-PK tables (required for multi-master
# and parallel applying operation)
wsrep_certify_nonPK=1

# Maximum number of rows in write set
wsrep_max_ws_rows=131072

# Maximum size of write set
wsrep_max_ws_size=1073741824

# to enable debug level logging, set this to 1
wsrep_debug=0
<commit_msg>Reduced slave threads to 1 for safety.<commit_after># This file contains wsrep-related mysqld options. It should be included
# in the main MySQL configuration file.
#
# Options that need to be customized:
#  - wsrep_provider
#  - wsrep_cluster_address
#  - wsrep_sst_auth
# The rest of defaults should work out of the box.

##
## mysqld options _MANDATORY_ for correct opration of the cluster
##
[mysqld]

# (This must be substituted by wsrep_format)
binlog_format=ROW

# Currently only InnoDB storage engine is supported
default-storage-engine=innodb

# to avoid issues with 'bulk mode inserts' using autoinc
innodb_autoinc_lock_mode=2

# This is a must for paralell applying
innodb_locks_unsafe_for_binlog=1

# Query Cache is not supported with wsrep
query_cache_size=0
query_cache_type=0

# Override bind-address
# In some systems bind-address defaults to 127.0.0.1, and with mysqldump SST
# it will have (most likely) disastrous consequences on donor node
bind-address=0.0.0.0
port=3307

##
## WSREP options
##

# Full path to wsrep provider library or 'none'
wsrep_provider=<%= libgalera_prefix %>/galera/libgalera_smm.so

# Provider specific configuration options

# See http://www.codership.com/wiki/doku.php?id=faq



wsrep_provider_options="pc.ignore_sb = no;ist.recv_addr=<%= node_address %>"

# Logical cluster name. Should be the same for all nodes.
wsrep_cluster_name="<%= cluster_name -%>"
<% if galera_gcomm_empty -%>
<% if setup_multiple_gcomm -%>
    <% if master_ip -%>
wsrep_cluster_address="gcomm://<%= @node_addresses.collect {|ip| ip + ':' + 4567.to_s }.join ',' %>"
    <% else -%>
        wsrep_cluster_address="gcomm://"
    <% end -%>
<% else -%>
    <% if master_ip -%>
wsrep_cluster_address="gcomm://<%= master_ip %>:4567"
    <% else -%>
wsrep_cluster_address="gcomm://"
    <% end -%>
<% end -%>
<% end -%>


# Human-readable node name (non-unique). Hostname by default.
#wsrep_node_name=

# Base replication <address|hostname>[:port] of the node.
# The values supplied will be used as defaults for state transfer receiving,
# listening ports and so on. Default: address of the first network interface.
wsrep_node_address=<%= node_address %>

# Address for incoming client connections. Autodetect by default.
#wsrep_node_incoming_address=

# How many threads will process writesets from other nodes
wsrep_slave_threads=1

# DBUG options for wsrep provider
#wsrep_dbug_option

# Generate fake primary keys for non-PK tables (required for multi-master
# and parallel applying operation)
wsrep_certify_nonPK=1

# Maximum number of rows in write set
wsrep_max_ws_rows=131072

# Maximum size of write set
wsrep_max_ws_size=1073741824

# to enable debug level logging, set this to 1
wsrep_debug=0

{'fraction_non_alphanumeric': 0.10134760937788444, 'fraction_numerical': 0.017168174266199, 'mean_word_length': 4.667364016736402, 'pattern_counts': {'":': 0, '<': 39, '<?xml version=': 0, '>': 39, 'https://': 0, 'lorem ipsum': 0, 'www.': 2, 'xml': 0}, 'pii_count': 4, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3741688', 'n_tokens_mistral': 1925, 'n_tokens_neox': 1779, 'n_words': 560}