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 <[EMAIL PROTECTED]>: > 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
