Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # 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=192.168.0.3
- port=3307
- max_connections=2048
- ##
- ## WSREP options
- ##
- # Full path to wsrep provider library or 'none'
- wsrep_provider=/usr/lib64/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=192.168.0.3;gmcast.listen_addr=tcp://192.168.0.3:4567"
- # Logical cluster name. Should be the same for all nodes.
- wsrep_cluster_name="openstack"
- wsrep_cluster_address="gcomm://192.168.0.4:4567,192.168.0.5:4567?pc.wait_prim=no"
- # 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=192.168.0.3
- # Address for incoming client connections. Autodetect by default.
- #wsrep_node_incoming_address=
- # How many threads will process writesets from other nodes
- wsrep_slave_threads=32
- # 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
- # convert locking sessions into transactions
- wsrep_convert_LOCK_to_trx=0
- # how many times to retry deadlocked autocommits
- wsrep_retry_autocommit=1
- # change auto_increment_increment and auto_increment_offset automatically
- wsrep_auto_increment_control=1
- # retry autoinc insert, which failed for duplicate key error
- wsrep_drupal_282555_workaround=0
- # enable "strictly synchronous" semantics for read operations
- wsrep_causal_reads=0
- # Command to call when node status or cluster membership changes.
- # Will be passed all or some of the following options:
- # --status - new status of this node
- # --uuid - UUID of the cluster
- # --primary - whether the component is primary or not ("yes"/"no")
- # --members - comma-separated list of members
- # --index - index of this node in the list
- wsrep_notify_cmd=
- ##
- ## WSREP State Transfer options
- ##
- # State Snapshot Transfer method
- wsrep_sst_method=mysqldump
- # Address on THIS node to receive SST at. DON'T SET IT TO DONOR ADDRESS!!!
- # (SST method dependent. Defaults to the first IP of the first interface)
- wsrep_sst_receive_address=192.168.0.3:3307
- # SST authentication string. This will be used to send SST to joining nodes.
- # Depends on SST method. For mysqldump method it is root:<root password>
- wsrep_sst_auth=wsrep_sst:password
- # Desired SST donor name.
- #wsrep_sst_donor=
- # Protocol version to use
- # wsrep_protocol_version=
- skip-name-resolve
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement