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
