0000026: ability to load balance query based on host ip - Pgpool-II Bug Tracker

ID	Project	Category	View Status	Date Submitted	Last Update

0000026	Pgpool-II	New feature	public	2012-09-04 15:51	2012-09-04 17:27

Reporter	videanuadrian	Assigned To	t-ishii
Priority	normal	Severity	feature	Reproducibility	always
Status	closed	Resolution	open

Summary	0000026: ability to load balance query based on host ip
Description	i have recently moved a database from Mysql to postgresql 9.1.5 which is behind a pgpool-II-3.1.4 . Everything went fine until i observed that some "tickets" are not created correctly by the application (OTRS) that populate the database. After some debugging i found/guess that the problem is the following: when a cron job wants to create a ticket he has to insert info in abut 10 tables, and i guess that the 2-nd, 3-rd ... inserts depends on the first. The problem was that this operation is not performed transactionally so after the first insert, when the app tries to perform the other inserts, first tries to select "the first insert", but this first insert is still not propagated to all nodes, and the error occurs. I`m aware of the fact that if this entire operation would be performed transactionally (only on master) the issue is solved, but unfortunately i cannot modify the app. So i want to know if there is any way that i can tell to pgpool something like : any request from this ip do not load balance. PS. temporary i have set the weight factor to 0 to the 2-nd and 3-rd postgresql slaves and it behaves ok, because reads and writes only from master.
Additional Information	Controlling behavior of load balance based on client IP is not too difficult. However since it's a completely new functionilty, it might be be added to 3.3 in the nearest future. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp
Tags	No tags attached.

Date Modified	Username	Field	Change
2012-09-04 15:51	videanuadrian	New Issue
2012-09-04 17:27	t-ishii	Note Added: 0000073
2012-09-04 17:27	t-ishii	Assigned To	=> t-ishii
2012-09-04 17:27	t-ishii	Status	new => closed