I have a need to have a number of small tables (perhaps up to 10000 rows
each) replicated to a number of mysql slaves. Frequency of change is
very low, and they need not be replicated within seconds, an hour is
fine. The master server has a lot more and bigger tables, but each
slave will only have a small subset of those. I've held off setting up
proper replication, thinking it was too much effort, but I've now just
yesterday set up one such replication.
I've got the slave only replicating two tiny, mostly static tables, so I
had kind of expected not to see a lot of network traffic. Instead I
see lots and lots of replication traffic? I'm guessing the master
notifies the slave(s) of all changes, not just changes to the
Is there a way of limiting that? Alternatively, is there a way of
doing "replication-on-demand", perhaps triggered by cron?
/Per Jessen, Zürich