[rt-users] RT to go? Dependency graphs?

[Johan Ihren]

Patrik Wallstrom <pawal at blipp.com> writes:

> On Tue, 16 Apr 2002, Johan Ihren wrote:
> 
> > > >    So what I would like to do is run RT on top of a replicated MySQL
> > > >    db with slave replicas in our laptops. 
> > > [...]
> > > >    Is this idea a strong indication of someone either finally going
> > > >    bonkers or at least trying to fit a square nail into a triangular
> > > >    hole? 
> > > 
> > > Yes, to both questions.  That's craaazy.  Or at least way too much work
> > > for the reward.  
> > 
> > Thank you, sir. I will not deny that you are most probably right here ;-)
> > 
> > I *realise* this, and I want to make that clear. Also, I am not
> > experienced with real databases. So I have to ask: way too much work
> > to *whom*? To me to make it work? To the master db keeping update
> > logs? To the client (my laptop) trying to stay in sync?
> 
> A simple solution would be to mysqldump the database on the server,
> and rsync the data over to your laptop, and then make an import on
> your local setup.

Yes, that would do it. However, that would lead to all of the data
being brought over the network (and imported) each time, while using
replication would bring this down to just deltas. Yes, with
sufficiently infrequent deltas the update log may actually be larger
than the end result, but that is not the environment I'm interested in
and not typical of a ticketing system with thousands of old (hopefully
resolved) tickets laying around in the database.

Regards,

Johan Ihrén
Autonomica