# Replicate\_Ignore\_Table row based, statement based

**URL:** <https://forums.percona.com/t/replicate-ignore-table-row-based-statement-based/6527>\
**Category:** Other MySQL® Questions\
**Created:** [August 22, 2018, 6:13am UTC](https://forums.percona.com/t/replicate-ignore-table-row-based-statement-based/6527 "2018-08-22T06:13:33Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![yctn](https://avatars.discourse-cdn.com/v4/letter/y/97f17d/32.png) [@yctn](https://forums.percona.com/u/yctn)\
**Post date:** [August 22, 2018, 6:13am UTC](https://forums.percona.com/t/replicate-ignore-table-row-based-statement-based/6527/1 "2018-08-22T06:13:33Z")

</div>

Hello,

im in the proces of moving a single master(mariadb 10.0.15) to a multi node galera cluster(10.3.9)  
so i currently have one galera node replicating from the current master.  
i also have a 3th slave that is currently replicating from the current master.  
so i did a change master on the 3th slave to check if i can replicate from the galera node.

and the following happened:

this is while replicating from the current master. everything is fine here:  
\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 1. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
Slave\_IO\_State: Queueing master event to the relay log  
Master\_Host: 10.1.214.101  
Master\_User: root  
Master\_Port: 3306  
Connect\_Retry: 60  
Master\_Log\_File: mysql-bin.041929  
Read\_Master\_Log\_Pos: 336868991  
Relay\_Log\_File: relay.000609  
Relay\_Log\_Pos: 336869248  
Relay\_Master\_Log\_File: mysql-bin.041929  
Slave\_IO\_Running: Yes  
Slave\_SQL\_Running: Yes  
Replicate\_Do\_DB: test,mysql  
Replicate\_Ignore\_DB:  
Replicate\_Do\_Table:  
Replicate\_Ignore\_Table: test.admoney,test.campaigndaybudgeds,test.campaigndaybudgeds\_pops,test.campaigndaybudgeds\_speed,test.loginattempts  
Replicate\_Wild\_Do\_Table:  
Replicate\_Wild\_Ignore\_Table:  
Last\_Errno: 0  
Last\_Error:  
Skip\_Counter: 0  
Exec\_Master\_Log\_Pos: 336868953  
Relay\_Log\_Space: 336869624  
Until\_Condition: None  
Until\_Log\_File:  
Until\_Log\_Pos: 0  
Master\_SSL\_Allowed: No  
Master\_SSL\_CA\_File:  
Master\_SSL\_CA\_Path:  
Master\_SSL\_Cert:  
Master\_SSL\_Cipher:  
Master\_SSL\_Key:  
Seconds\_Behind\_Master: 0  
Master\_SSL\_Verify\_Server\_Cert: No  
Last\_IO\_Errno: 0  
Last\_IO\_Error:  
Last\_SQL\_Errno: 0  
Last\_SQL\_Error:  
Replicate\_Ignore\_Server\_Ids:  
Master\_Server\_Id: 101  
Master\_SSL\_Crl:  
Master\_SSL\_Crlpath:  
Using\_Gtid: Current\_Pos  
Gtid\_IO\_Pos: 0-101-152368736455  
Replicate\_Do\_Domain\_Ids:  
Replicate\_Ignore\_Domain\_Ids:  
Parallel\_Mode: conservative  
SQL\_Delay: 0  
SQL\_Remaining\_Delay: NULL  
Slave\_SQL\_Running\_State: Slave has read all relay log; waiting for the slave I/O thread to update it  
Slave\_DDL\_Groups: 0  
Slave\_Non\_Transactional\_Groups: 35173761  
Slave\_Transactional\_Groups: 12

but when i change to the new master i get the following error:

\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 1. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
Slave\_IO\_State: Waiting for master to send event  
Master\_Host: 10.1.214.100  
Master\_User: root  
Master\_Port: 3306  
Connect\_Retry: 60  
Master\_Log\_File: mysql-bin.000573  
Read\_Master\_Log\_Pos: 406381234  
Relay\_Log\_File: relay.000586  
Relay\_Log\_Pos: 172156660  
Relay\_Master\_Log\_File: mysql-bin.000573  
Slave\_IO\_Running: Yes  
Slave\_SQL\_Running: No  
Replicate\_Do\_DB: test,mysql  
Replicate\_Ignore\_DB:  
Replicate\_Do\_Table:  
Replicate\_Ignore\_Table: test.admoney,test.campaigndaybudgeds,test.campaigndaybudgeds\_pops,test.campaigndaybudgeds\_speed,test.loginattempts  
Replicate\_Wild\_Do\_Table:  
Replicate\_Wild\_Ignore\_Table:  
Last\_Errno: 1146  
Last\_Error: Error executing row event: ‘Table ‘test.loginattempts’ doesn’t exist’  
Skip\_Counter: 0  
Exec\_Master\_Log\_Pos: 401792970  
Relay\_Log\_Space: 176745219  
Until\_Condition: None  
Until\_Log\_File:  
Until\_Log\_Pos: 0  
Master\_SSL\_Allowed: No  
Master\_SSL\_CA\_File:  
Master\_SSL\_CA\_Path:  
Master\_SSL\_Cert:  
Master\_SSL\_Cipher:  
Master\_SSL\_Key:  
Seconds\_Behind\_Master: NULL  
Master\_SSL\_Verify\_Server\_Cert: No  
Last\_IO\_Errno: 0  
Last\_IO\_Error:  
Last\_SQL\_Errno: 1146  
Last\_SQL\_Error: Error executing row event: ‘Table ‘test.loginattempts’ doesn’t exist’  
Replicate\_Ignore\_Server\_Ids:  
Master\_Server\_Id: 100  
Master\_SSL\_Crl:  
Master\_SSL\_Crlpath:  
Using\_Gtid: Current\_Pos  
Gtid\_IO\_Pos: 0-101-152368802207  
Replicate\_Do\_Domain\_Ids:  
Replicate\_Ignore\_Domain\_Ids:  
Parallel\_Mode: conservative  
SQL\_Delay: 0  
SQL\_Remaining\_Delay: NULL  
Slave\_SQL\_Running\_State:  
Slave\_DDL\_Groups: 0  
Slave\_Non\_Transactional\_Groups: 35230746  
Slave\_Transactional\_Groups: 24

i already have slave-skip-errors = all

i just state that test.loginattempts should be ignored so why it fails on that one?

the only difference i can think of is that the current master uses statement based replication. and the new master uses row based replication.  
it seems to me that Replicate\_Ignore\_Table simply is not working when using row based replication.

i hope someone can clear this up cause i dont understand why this is happening.