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 <[EMAIL PROTECTED]> wrote: > 2008/7/25 Duncan McQueen <[EMAIL PROTECTED]>: >> 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: [EMAIL PROTECTED] > 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 > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general > _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
