MySQL Slave Replication – Ignoring Temporary Tables

Since i have found same error in my database server slave replication, there is some changes in master databases that created some temporary tables for reporting, I get my slave database got error in doing replication.

To avoid and not include temporary tables to be replicated to slave database

Edit mysql database config ==> /etc/my.conf

# Ignoring temporary tables
replicate-do-db                 = DAY1_Log
replicate-wild-ignore-table     = DAY1_Log.RevisitYesterday%
replicate-wild-ignore-table     = DAY1_Log.UserPool%

1479975761610

Ketika di Query di running berikut: SHOW SLAVE STATUS\G

1479975761610

Semoga server ku tak ada masalah lagi, terima kasih

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.