[rt-users] Multi-tier RT

[Andrew Pollock]

On Fri, Jan 17, 2003 at 03:29:22PM +0100, Bruce Campbell wrote:
> On Fri, 17 Jan 2003, A BIT of an Andrew Pollock wrote something about
> splitting RT:
> 
> > On Fri, Jan 17, 2003 at 02:56:31PM +1000, Phil Homewood wrote:
> > >
> > > The attachments are all thrown into the DB, no filesystem access
> > > should be required (but, I haven't done it, so I could be wrong.)
> >
> > I didn't see any evidence that the attachments were in the database with
> > 2.0.14 on PostgreSQL, but I'll toddle off and reinspect the schema.

I stand corrected, they go into the attachments table, just not as BLOBs 
like I expected...
 
> In our setup, we have 4 distinct machines, and a plethora of desktops that
> are able to directly access the SQL servers.  The maintainance of this is
> eased by having our install directory, /home/rt2, NFS shared across the
> machines.

NFS is evil and can't be used in the environment that I'm looking at 
deploying RT2 into.

>        /----------\
>       | mailserver |-----\
>        \----------/       \
>                            \
>        /----------\         \                      /-----------\
>       |  webserver |----------> MySQL access -----| MySQL-grunt |
>        \----------/    \    /                      \-----------/
>                         \--/-\                           |
>        /----------\       /   \                    /-----------\
>       |  desktops  |-->--*----- Intended Query ---| Backup Serv |
>        \----------/             Only Access        \-----------/
> 
> I haven't gotten around to the 'Intended Query Only Access' functionality,
> but one day, one day.  The connection between the MySQL grunt machine and
> the Backup Serv(er) is standard MySQL replication.

What are you sharing via NFS anyway, just the RT (config) files and 
whatnot to keep them all in sync?

Andrew