[rt-users] Multi-tier RT

Andrew Pollock andrew-rt at andrew.net.au
Fri Jan 17 16:42:50 EST 2003


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



More information about the rt-users mailing list