[Pgpool-general] pgpool-II and Amazon EC2

[Duncan McQueen]

Hello,

is there not a way to have pgpool (or pgpool-II) recognize the new
backends without restarting?

Would you be willing to share part of the scripts?

2008/7/26 Duncan McQueen <dwmcqueen at gmail.com>:
> Hello,
>
> That sounds about what I am exactly looking for.  All scripted then?
>
> On Sat, Jul 26, 2008 at 5:41 AM, Łukasz Jagiełło
> <lukasz.jagiello at gforces.pl> wrote:
>> 2008/7/25 Duncan McQueen <dwmcqueen at gmail.com>:
>>> Hello,
>>>
>>> We are looking at implementing pgpool-II for its replication and load
>>> balancing features.  One of the points of our system is we have a
>>> defined time period during the day when the query level is higher than
>>> another.  We are exploring using Amazon's EC2 computing service to
>>> help out with the load (using pgpool-II's load balancer) during those
>>> defined times.
>>>
>>> Has anyone developed or worked on a similar idea?
>>
>> Yeah. Got such working env. Got one proxy with static external IP, and
>> keep there pgpool/haproxy. Other instance are blind www/db backends.
>> When backend get up check at 'ec2-describe-instances' internal IP of
>> proxy and put in config files. Proxy once per 5-10min check what
>> backends got and add/del it from own config files. Atm I just quick
>> restart pgpool if notice there is new backend.
>>
>> That env still new some features but it's working.
>>
>> --
>> Łukasz Jagiełło
>> G-Forces Web Management Polska
>>
>> T: +44 (0) 845 055 9040
>> F: +44 (0) 845 055 9038
>> E: lukasz.jagiello at gforces.pl
>> W: www.gforces.co.uk
>>
>> This e-mail is confidential and intended solely for the use of the
>> individual to whom it is addressed. If you are not the intended
>> recipient, please notify the sender immediately. Do not disclose the
>> contents of this e-mail to any other person, use it for any purpose,
>> print, copy, store, or distribute it. This e-mail should then be
>> destroyed. Any views expressed in this message are those of the
>> individual sender except where the sender specifically states them to
>> be the views of G-Forces Web Management Ltd. Registered Office: 4 & 5
>> Kings Row, Armstrong Road, Maidstone, Kent. ME15 6AQ. Registered
>> Company No. 3863609. VAT Registration No. 7250 384 50
>> _______________________________________________
>> Pgpool-general mailing list
>> Pgpool-general at pgfoundry.org
>> http://pgfoundry.org/mailman/listinfo/pgpool-general
>>
>