List:General Discussion« Previous MessageNext Message »
From:Per Jessen Date:December 15 2010 8:45am
Subject: restrict mysql replication ?
View as plain text  
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

Thread
restrict mysql replication ?Per Jessen15 Dec
  • Re: restrict mysql replication ?Per Jessen15 Dec
    • Re: restrict mysql replication ?Johan De Meersman15 Dec
  • Re: restrict mysql replication ?Per Jessen15 Dec