Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7205

Galera cluster & sql_log_bin = off don't work

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 10.0.13-galera, 10.0.14-galera
    • Fix Version/s: 10.1.7
    • Component/s: Galera
    • Labels:

      Description

      my servers:

      https://farm8.staticflickr.com/7544/15874745401_d3975432f6_b.jpg

      configuration on each node : (except server-id ofc)

      [mysqld]
      #mysql settings
       
      log-slave-updates=1
      default-storage-engine=innodb
      query_cache_size=0
      query_cache_type=0
      bind-address=0.0.0.0
       
      server-id=1746717299
       
      skip-slave-start
       
      datadir = /data/mysql/data
      #galera settings
      wsrep_provider=/usr/lib/galera/libgalera_smm.so
      wsrep_cluster_name="iways_cluster"
      wsrep_cluster_address="gcomm://10.7.20.3,10.7.20.4,10.7.20.6"
      wsrep_sst_method=rsync
      wsrep_provider_options="gcache.size=20G"
       
      #innoDB
      innodb_file_per_table
      connect_timeout         = 60
      wait_timeout            = 3600
      innodb_buffer_pool_size = 16G
      innodb_flush_method     = O_DIRECT
       
      innodb_log_file_size = 64M
      innodb_log_buffer_size = 8M
      innodb_flush_log_at_trx_commit = 1
      innodb_autoinc_lock_mode=2
       
      #for master
       
      binlog_format=ROW
      log_bin                 = /data/mysql/binlog/mariadb-bin
      log_bin_index           = /data/mysql/binlog/mariadb-bin.index
       
      max_binlog_size         = 1G
      expire_logs_days        = 10
       
      sync_binlog=1
       
      sort_buffer_size        = 10M
      bulk_insert_buffer_size = 16M
      tmp_table_size          = 64M
      max_heap_table_size     = 64M
       
      #log
      slow_query_log_file     = /data/mysql/log/mariadb-slow.log
      long_query_time = 1
       
      performance_schema = 'ON'
       
      collation-server = utf8_unicode_ci
      character-set-server = utf8
      init-connect = 'SET NAMES utf8'
       
      max_connections = 500
      open_files_limit =  65535
       
      log-error=/data/mysql/log/error.log

      on node 1 :

      use PRODUCTION;
      CREATE TABLE `test` (
       `id` int(11) NOT NULL AUTO_INCREMENT,
       PRIMARY KEY (`id`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8
       
      INSERT INTO `PRODUCTION`.`test` (`id`) VALUES ('1'), ('2');

      After on each node (1 at once)

      SET sql_log_bin = OFF;
      delete from test where id =1;

      successfull on the node where it's executed and the DELETE is not applied on other node of cluster ....

      The problem here the cluster is desynchronized.

      My goal, got a cluster and a server of history behind. (where delete not executed on slave)

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              nirbhay_c Nirbhay Choubey (Inactive)
              Reporter:
              Aurelien_LEQUOY Aurélien LEQUOY
              Votes:
              1 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Due:
                Created:
                Updated:
                Resolved: