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 replicated tables? 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
