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

replicate_events_marked_for_skip didn't work on Galera cluster

Details

    Description

      the cluster & replication :

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

      my galera.ini

      [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');

      ====
      two rows are present on all servers (and on slave)

      slave have configuration :
      replicate-events-marked-for-skip = filter_on_slave

      =========
      if i run on node 2 :
      SET @@skip_replication = ON;
      delete from test where id =1;

      it's work perfectly, i still got the line on slave

      ========

      if i run on node 1 or 3 :
      SET @@skip_replication = ON;
      delete from test where id =1;

      it's didn't work, I lost the line on the slave.

      -I saw this problem has been fixed on 10.0.14, I would to know if it was knowed.-

      Attachments

        Activity

          Aurelien_LEQUOY Aurélien LEQUOY created issue -
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Affects Version/s 10.0.13-galera [ 16800 ]
          Affects Version/s 10.0.13 [ 16300 ]
          elenst Elena Stepanova made changes -
          Component/s Galera [ 10124 ]
          elenst Elena Stepanova made changes -
          Labels galera
          elenst Elena Stepanova made changes -
          Assignee Nirbhay Choubey [ nirbhay_c ]
          Aurelien_LEQUOY Aurélien LEQUOY made changes -
          Affects Version/s 10.0.14-galera [ 17000 ]
          Aurelien_LEQUOY Aurélien LEQUOY made changes -
          Description the cluster & replication :

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

          my galera.ini

          [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');

          ====
          two rows are present on all servers (and on slave)

          slave have configuration :
          replicate-events-marked-for-skip = filter_on_slave

          =========
          if i run on node 2 :
           SET @@skip_replication = ON;
           delete from test where id =1;

          it's work perfectly, i still got the line on slave

          ========

          if i run on node 1 or 3 :
           SET @@skip_replication = ON;
           delete from test where id =1;

          it's didn't work, I lost the line on the slave.


          I saw this problem has been fixed on 10.0.14, I would to know if it was knowed.
          the cluster & replication :

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

          my galera.ini

          [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');

          ====
          two rows are present on all servers (and on slave)

          slave have configuration :
          replicate-events-marked-for-skip = filter_on_slave

          =========
          if i run on node 2 :
           SET @@skip_replication = ON;
           delete from test where id =1;

          it's work perfectly, i still got the line on slave

          ========

          if i run on node 1 or 3 :
           SET @@skip_replication = ON;
           delete from test where id =1;

          it's didn't work, I lost the line on the slave.


          -I saw this problem has been fixed on 10.0.14, I would to know if it was knowed.-
          Aurelien_LEQUOY Aurélien LEQUOY made changes -
          Description the cluster & replication :

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

          my galera.ini

          [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');

          ====
          two rows are present on all servers (and on slave)

          slave have configuration :
          replicate-events-marked-for-skip = filter_on_slave

          =========
          if i run on node 2 :
           SET @@skip_replication = ON;
           delete from test where id =1;

          it's work perfectly, i still got the line on slave

          ========

          if i run on node 1 or 3 :
           SET @@skip_replication = ON;
           delete from test where id =1;

          it's didn't work, I lost the line on the slave.


          -I saw this problem has been fixed on 10.0.14, I would to know if it was knowed.-
          the cluster & replication :

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

          my galera.ini

          [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');

          ====
          two rows are present on all servers (and on slave)

          slave have configuration :
          replicate-events-marked-for-skip = filter_on_slave

          =========
          if i run on node 2 :
           SET @@skip_replication = ON;
           delete from test where id =1;

          it's work perfectly, i still got the line on slave

          ========

          if i run on node 1 or 3 :
           SET @@skip_replication = ON;
           delete from test where id =1;

          it's didn't work, I lost the line on the slave.


          --I saw this problem has been fixed on 10.0.14, I would to know if it was knowed.--
          nirbhay_c Nirbhay Choubey (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          nirbhay_c Nirbhay Choubey (Inactive) made changes -
          Status In Progress [ 3 ] In Review [ 10002 ]
          nirbhay_c Nirbhay Choubey (Inactive) made changes -
          Assignee Nirbhay Choubey [ nirbhay_c ] Jan Lindström [ jplindst ]
          jplindst Jan Lindström (Inactive) made changes -
          Assignee Jan Lindström [ jplindst ] Nirbhay Choubey [ nirbhay_c ]
          Status In Review [ 10002 ] Stalled [ 10000 ]
          nirbhay_c Nirbhay Choubey (Inactive) made changes -
          Fix Version/s 10.0.17-galera [ 18701 ]
          Resolution Fixed [ 1 ]
          Status Stalled [ 10000 ] Closed [ 6 ]
          nirbhay_c Nirbhay Choubey (Inactive) made changes -
          Fix Version/s 5.5.43-galera [ 18819 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 58723 ] MariaDB v3 [ 62489 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 62489 ] MariaDB v4 [ 148542 ]

          People

            nirbhay_c Nirbhay Choubey (Inactive)
            Aurelien_LEQUOY Aurélien LEQUOY
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.