> On 2012-10-08 18:41, Oleksandr Drach wrote:
> > Dear Community!
> > I have setup 5-node MySQL-Server-Wsrep+Galera cluster using rsync_wan
> > SST
> > method. And replications comes *only for databases and tables
> > changes*, but
> > not the *tables contents*.
> Please post SHOW CREATE TABLE for one of the tables in question. Most
> likely it is MyISAM.
> > *
> > *
> > *My questions:*
> > 1. How to fix it and get full replication including tables data?
> > 2. How to properly set wsrep_notify_cmd parameter to log changes only
> > to
> > /var/log/syslog file without using of any external commands?
> > *Software versions:*
> > - OS: Ubuntu 12.04.01 LTS Server 64 bit
> > - mysql-server-wsrep-5.5.23-23.6-amd64
> > - galera-23.2.1
> > - libaio1 0.3.109-2ubuntu1
> > - psmisc 22.15-2ubuntu1.1
> > - libssl0.9.8 0.9.8o-7ubuntu3.1
> > *Apparmor* exclusion has been already applied for mysqld as
> > recommended in
> > Ubuntu.
> > No *firewall* restrictions set at the moment.
> > Nodes configurations:
> > */etc/mysql/my.cnf*
> > ...
> > bind-address = 8.8.8.8 #external IP of node here, of
> > course
> > there's my addressess in real configs :)
> > ...
> > */etc/mysql/conf.d/wsrep.cnf*
> > [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=8.8.8.8 # Node's IP there
> > ##
> > ## WSREP options
> > ##
> > # Full path to wsrep provider library or 'none'
> > wsrep_provider=/usr/lib/galera/libgalera_smm.so
> > # Provider specific configuration options
> > #wsrep_provider_options=
> > wsrep_provider_options="gmcast.listen_addr = tcp://8.8.8.8:4567;" #
> > Node's
> > IP there
> > # Logical cluster name. Should be the same for all nodes.
> > wsrep_cluster_name="cmi_wsrep_cluster"
> > # Group communication system handle
> > wsrep_cluster_address="gcomm://8.8.4.4"# 1st node's IP there
> > # 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=8.8.8.8 # Node's IP there
> > # Address for incoming client connections. Autodetect by default.
> > wsrep_node_incoming_address=8.8.8.8 # Node's IP there
> > # How many threads will process writesets from other nodes
> > wsrep_slave_threads=3
> > # 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=yes
> > ##
> > ## WSREP State Transfer options
> > ##
> > # State Snapshot Transfer method
> > wsrep_sst_method=rsync_wan
> > # 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=8.8.8.8 # Node's IP there
> > # 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_user:wsrep_password
> > # Desired SST donor name.
> > #wsrep_sst_donor=
> > # Protocol version to use
> > # wsrep_protocol_version=
> > Thanks in advance for your help!
> > If additional information is required please let me know!
> --
> Alexey Yurchenko,
> Codership Oy, www.codership.com
> Skype: alexey.yurchenko, Phone: +358-400-516-011
