The following options can be set as part of the Galera wsrep_provider_options variable. Dynamic options can be changed while the server is running.
Options need to be provided as a semicolon (;) separated list on a single line.
Note that before Galera 3, the repl tag was named replicator.
base_dirbase_host127.0.0.1 (detected network address) base_port4567 cert.log_conflictsno debugno evs.auto_evict0, the default, the Auto Eviction protocol is disabled for this node. 0 evs.causal_keepalive_periodevs.debug_log_mask0x1 evs.delay_marginPT1S evs.delayed_keep_periodPT30S evs.evictevs.inactive_check_period PT0.5S evs.inactive_timeoutPT30S evs.info_log_mask 0 evs.install_timeoutPT15S evs.join_retrans_periodPT1S evs.keepalive_periodPT1S evs.max_install_timeouts3 evs.send_window512. 4 evs.stats_report_periodPT1M evs.suspect_timeoutPT5S evs.use_aggregatetrue (the default), small packets will be aggregated into one where possible. true evs.user_send_window512. 2 evs.version0 evs.view_forget_timeoutP1D gcache.dirgcache.keep_pages_size0 gcache.mem_size0 gcache.namegalera.cache --- gcache.page_sizegcache.page. Can be set to as large as the disk can handle. 128M gcache.recoverno gcache.size10M gcomm.thread_priopolicy:priority. Priority is an integer, while policy can be one of: fifo: First-in, first-out scheduling. Always preempt other, batch or idle threads and can only be preempted by other fifo threads of a higher priority or blocked by an I/O request. rr: Round-robin scheduling. Always preempt other, batch or idle threads. Runs for a fixed period of time after which the thread is stopped and moved to the end of the list, being replaced by another round-robin thread with the same priority. Otherwise runs until preempted by other rr threads of a higher priority or blocked by an I/O request. other: Default scheduling on Linux. Threads run until preempted by a thread of a higher priority or a superior scheduling designation, or blocked by an I/O request. gcs.fc_debug0 gcs.fc_factor1.0 gcs.fc_limit16 gcs.fc_master_slaveNO gcs.max_packet_size64500 gcs.max_throttle0.25 gcs.recv_q_hard_limitgcs.recv_q_soft_limitcsrecv_q_soft_limit to one (full throttling) at gcs.recv_q_hard_limit 0.25 gcs.sync_donorYES (NO is default), if the donor is blocked by state transfer, the whole cluster is also blocked. NO gmcast.listen_addrtcp:0.0.0.0:4567 gmcast.mcast_addrgmcast.mcast_addr=239.192.0.11 gmcast.mcast_ttl1 gmcast.peer_timeoutPT3S gmcast.segment0). Usually, you would place all nodes in the same datacenter in the same segment. Galera protocol traffic is only redirected to one node in each segment, and then relayed to other nodes in that same segment, which saves cross-datacenter network traffic at the expense of some extra latency. State transfers are also, preferably but not exclusively, taken from the same segment. If there are no nodes available in the same segment, state transfer will be taken from a node in another segment. 0 0 to 255 gmcast.time_waitPT5S gmcast.version0 ist.recv_addrist.recv_bindpc.announce_timeoutPT3S pc.checksumfalse (true in earlier releases), indicates whether to checksum replicated messages on PC level. Safe to turn off. false pc.ignore_quorumtrue (false is default). Use with care however, as in master-slave setups, slaves will not automatically reconnect to the master if set. false pc.ignore_sbfalse pc.lingerPT20S pc.npvotrue (false is default), when there are primary component conficts, the most recent component will override the older. false pc.recoverytrue (the default), the Primary Component state is stored on disk and in the case of a full cluster crash (e.g power outages), automatic recovery is then possible. Subsequent graceful full cluster restarts will require explicit bootstrapping for a new Primary Component. true pc.version0 pc.wait_primtrue, the default, the node will wait for a primary component for the period of time specified by pc.wait_prim_timeout. Used to bring up non-primary components and make them primary using pc.bootstrap. true pc.wait_prim_timeoutPT30S pc.weight1 protonet.backend asio protonet.version0 repl.causal_read_timeoutPT90S repl.commit_order0 BYPASS: No commit order monitoring is done (useful for measuring the performance penalty). 1 OOOC: Out-of-order committing is permitted for all transactions. 2 LOCAL_OOOC: Out-of-order committing is permitted for local transactions only. 3 NO_OOOC: Out-of-order committing is not permitted at all. 3 repl.key_formatFLAT8 - shorter key with a higher probability of false positives when matching FLAT16 - longer key with a lower probability of false positives when matching FLAT8A - shorter key with a higher probability of false positives when matching, includes annotations for debug purposes FLAT16A - longer key with a lower probability of false positives when matching, includes annotations for debug purposes FLAT8 repl.max_ws_size2147483647 repl.proto_max5 socket.checksumwsrep_provider_options='socket.checksum=1' in order to make it backward compatible with Galera v2. Galera wsrep providers other than 25.3.x or 25.2.x are not supported. 2 socket.recv_buf_size212992 socket.sslNO socket.ssl_casocket.ssl option. socket.ssl_certsocket.ssl option. socket.ssl_ciphersocket.ssl option. Since MariaDB 10.2.18 defaults to the value of the ssl_cipher system variable. AES128-SHA. socket.ssl_compressionsocket.ssl option. socket.ssl_keysocket.ssl option. socket.ssl_password_filesocket.ssl option.
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/wsrep_provider_options/