Re: Selecting backend based on the user connecting
> This is similar to the keepalive tutorial where we show read/write splitting.
>
> The idea is:
>
> * connect_server() builds a pool of connections to all backends and maintains it
> * read_query() picks a backend based on the user, query, ...
Doing things this way means I'd have to do a lookup for every single query to find the proper backend for a given user. If instead I can do that lookup only once at connect time and then assign a specific connection for each user to their specific backend server, wouldn't this scale a lot better?
Subject
Views
Written By
Posted
3626
August 13, 2007 03:42AM
2809
August 13, 2007 04:05AM
2635
August 13, 2007 04:11AM
2539
August 13, 2007 04:27AM
2558
August 13, 2007 05:29AM
2510
August 13, 2007 06:17AM
2703
August 20, 2007 05:47AM
2644
August 20, 2007 09:06AM
2676
August 22, 2007 07:45AM
Re: Selecting backend based on the user connecting
2587
August 13, 2007 04:16AM
2573
August 13, 2007 04:25AM
2377
August 13, 2007 05:57AM
2459
August 13, 2007 06:20AM
2636
August 13, 2007 09:03AM
2389
October 11, 2007 02:31AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.