# Temporal tables and slave replication

**URL:** <https://forums.percona.com/t/temporal-tables-and-slave-replication/1847>\
**Category:** Other MySQL® Questions\
**Created:** [July 14, 2012, 7:22am UTC](https://forums.percona.com/t/temporal-tables-and-slave-replication/1847 "2012-07-14T07:22:37Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![alv4ro](https://avatars.discourse-cdn.com/v4/letter/a/df788c/32.png) [@alv4ro](https://forums.percona.com/u/alv4ro)\
**Post date:** [July 14, 2012, 7:22am UTC](https://forums.percona.com/t/temporal-tables-and-slave-replication/1847/1 "2012-07-14T07:22:37Z")

</div>

.Hello,

I’m using a master based in Percona 5.1 and two slaves.

One of them use percona 5.1 too and replication has no problem, but in the other one which uses percona 5.5 has a problem during temp tables replication.

In percona 5.1 using:

binlog\_format = ROW

there’s no problem, but in percona 5.5 I must set it to:

binlog\_format = MIXED

In my.cnf I setted two innodb replication options for the slave:

replicate-ignore-table = powersystem.temp%  
replicate-wild-do-table = powersystem.%

and I triyed so with:

replicate-wild-ignore-table = powersystem.temp%  
replicate-wild-do-table = powersystem.%

but both ignore that options and doesn’t apply, and the slave try temporal tables that doesn’t exist.

I don’t know what I’m doing wrong. If you can help me. There’s an other way to sync an slave avoiding temp tables?

Thanks!

---

<div class="post-metadata">

**Author:** ![niljoshi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/niljoshi/32/16889_2.png) [@niljoshi](https://forums.percona.com/u/niljoshi)\
**Post date:** [July 17, 2012, 4:23am UTC](https://forums.percona.com/t/temporal-tables-and-slave-replication/1847/2 "2012-07-17T04:23:09Z")

</div>

Hi,

When you will use replicate-do-table with replicate-ignore-table, mysql will always first read replicate-do-table and it will execute the statement as per that. Check below link for how exactly it works on slave side.  
[http://dev.mysql.com/doc/refman/5.5/en/replication-rules-db-](http://dev.mysql.com/doc/refman/5.5/en/replication-rules-db-) options.html

So In your case, it looks like first its checking replicate-do-table and its getting green signal for powerststem DB and executing that statement without checking replicate-ignore-table option.

Try below replication options for the slave and I hope it will work.

replicate-wild-ignore-table = powersystem.temp%  
replicate-do-db = powersystem
