[pgpool-general: 945] Re: pgpool and OTRS

[Tatsuo Ishii]

Please do not post feature requests to bug tracker.
Feature requests/proposals should be posted to pgpool-hackers.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Hi Tatsuo,
> thanks for this info.
> 
> Do i have to submit this feature request on pgpoll bug tracker ?
> 
> Regards,
> Adrian Videanu
> 
> 
> --- On Mon, 9/3/12, Tatsuo Ishii <ishii at postgresql.org> wrote:
> 
>> From: Tatsuo Ishii <ishii at postgresql.org>
>> Subject: Re: [pgpool-general: 941] pgpool and OTRS
>> To: videanuadrian at yahoo.com
>> Cc: pgpool-general at pgpool.net
>> Date: Monday, September 3, 2012, 10:17 AM
>> > Hi all, 
>> > 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.
>> 
>> 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
>>