Announcement

Announcement Module
Collapse
No announcement yet.

sync problem

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • sync problem

    Hi,
    I have 3 nodes

    node1
    [mysqld]
    server_id=1
    log_bin=mysql-bin
    datadir=/var/lib/mysql
    wsrep_node_name=node1db
    #log_slaves_updates
    wsrep_provider=/usr/lib64/libgalera_smm.so
    wsrep_cluster_address=gcomm://node2db,node3db
    wsrep_slave_threads=8
    wsrep_sst_method=rsync
    wsrep_causal_reads=ON
    wsrep_cluster_name=percona_cluster
    binlog_format=ROW
    default_storage_engine=InnoDB
    innodb_autoinc_lock_mode=2
    innodb_locks_unsafe_for_binlog=1

    node 2 e 3 similar the only difference are on wsrep_claster_address and wsrep_node_name and server_id

    My problem is when I write something in the database from my CMS of the website, the data is written correctly on the server where I connect but is not propagaded on the other nodes.
    Is this normal or is an issue of a bad config? Sorry I'm a newbie.

  • #2
    I resolved. Thanks.

    Comment

    Working...
    X