Tag1 Consulting

Performance and Scalability Experts

MySQL Replication Tips And Tricks

Comments

Excluding some SQL statements from replication

Submitted by Dimitar (not verified) on Sun, 09/14/2008 - 00:45.

The main table in the master database is truncated every 48 hours. Is it possible to exclude the truncate statement from the replication process?

I mean by this this statement should be either excluded from the binary logs or the slave should be configured to ignore it.

Thanks,

Dimitar

Cacti

Submitted by Ryan Lowe (not verified) on Wed, 07/30/2008 - 23:42.

Don't forget to use Cacti as a monitoring tool (good templates at http://code.google.com/p/mysql-cacti-templates/), which can monitor binary & relay log stats, network traffic, and replication (among many other things).

quick correction

Submitted by Anonymous (not verified) on Thu, 07/31/2008 - 08:27.

quick correction: it is mk-table-checksum not mysql-table-checksum

Thanks

Submitted by nnewton on Thu, 07/31/2008 - 13:51.

Good point, thanks. I really dislike that they renamed everything.