Re: restrict mysql replication ?

2010-12-15 Thread Per Jessen
Johan De Meersman wrote: > On Wed, Dec 15, 2010 at 10:08 AM, Per Jessen wrote: > >> Per Jessen wrote: >> >> > Is there a way of limiting that? Alternatively, is there a way of >> > doing "replication-on-demand", perhaps triggered by cron? >> >> Ignore this, problem solved. I'll let the slaves

Re: restrict mysql replication ?

2010-12-15 Thread Johan De Meersman
On Wed, Dec 15, 2010 at 10:08 AM, Per Jessen wrote: > Per Jessen wrote: > > > Is there a way of limiting that? Alternatively, is there a way of > > doing "replication-on-demand", perhaps triggered by cron? > > Ignore this, problem solved. I'll let the slaves query the master > regularly and jus

Re: restrict mysql replication ?

2010-12-15 Thread Per Jessen
Per Jessen wrote: > Is there a way of limiting that? Alternatively, is there a way of > doing "replication-on-demand", perhaps triggered by cron? Ignore this, problem solved. I'll let the slaves query the master regularly and just reload the entire table. /Per Jessen, Zürich -- MySQL Gener

restrict mysql replication ?

2010-12-15 Thread Per Jessen
I have a need to have a number of small tables (perhaps up to 1 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 hav