[rt-users] Read only db for select (cluster on the cheap)

[Dmitri Tikhonov]

On Thu, 2006-10-26 at 17:20 +0100, Roy El-Hames wrote:
> Not sure what you mean;I did not need to touch RT::Record .. do you mean 
> 2 handles same db .. It'll have little or no benefit??

No, different databases.  Two databases, two handles -- one read-write,
the other read-only.

> I understand what you mean about the speed of replication, in our case 
> its set to near enough real time, however with Create.html a/Update.html 
> and also Display.html I kept them reading from RW db in case of any 
> delay in replication, so basically anything that require to see the 
> changes immediately it will read from RW db.

Yes, that's what I was wondering -- would it be OK to read from the
read-only slave right after updating read-write master?  If not, what
are the cases, and can we abstract it in such manner that GUI code does
not have to be modified?

  - Dmitri.