Re: [Sqlrelay-discussion] Can sqlrelay connect to pgpool?

[David M. <dav...@fi...>]

Hello,

Honestly, I've never tried to connect SQL Relay to pgpool.  As I 
understand it, pgpool is allegedly transparent to a postgresql 
application, so I would expect it to "just work" but I don't know for 
sure.  By default, pgpool runs on a different socket and port than 
postgresql, so you would need to be sure to configure sqlrelay to use 
the correct socket/port.

I'll try it out when I get a chance and let you know what I find.  I'm 
not sure when I'll have the chance though.

Dave
dav...@fi...

On 01/11/2012 01:32 AM, Chung-Wen Cho wrote:
>
> Hi,
> I have a project using mysql cluster + sqlrelay. Now, I want to 
> replace mysql by postgresql and use pgpool for data replication. 
> However, I have alrealy some APIs embedded some sqlrelay-library 
> codes. I don't want to rewrite these APIs. Therefore, I have to keep 
> sqlrelay and the connection steam from a query to postgresql may look 
> like this:
> An API (query) --------> sqlrelay  ---------> pgpool -----------> 
> postgresqls.
> My question is that can sqlrealy directly (or indirectly) connect to 
> pgpool?
> I have tried the connection between sqlrelay and pgpool but I failed.
> Thank you for your kindly response
>
>
>
> ------------------------------------------------------------------------------
> Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
> infrastructure or vast IT resources to deliver seamless, secure access to
> virtual desktops. With this all-in-one solution, easily deploy virtual
> desktops for less than the cost of PCs and save 60% on VDI infrastructure
> costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
>
>
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion



_______________________________________________________
Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
              http://www.doteasy.com