[pgpool-hackers: 3605] Re: add a feature: dml object level load balance

[sunbiao at highgo.com]

Hi, Usama

I have made a new patch.
I make disable_load_balance_on_write to accept new value.
Set disable_load_balance_on_write = 'dml_load_balance' to enable this feature.

This new patch contains a test script in path ‘src/test/dml-load-balance-test’.
If pg installed by default in /usr/local/pgsql, just execute test.sh.
If pg is in other dir, execute  ‘test.sh -p /path_to_pg_dir/’.
It will show “success: dml load balance test pass.” , when test pass.

this script will test below sql:

show pool_nodes;

-- test DML
begin ;
insert into tb_dml_insert values (1);
select * from tb_dml_insert ;
commit ;

begin ;
update tb_dml_update SET a = 2;
select * from tb_dml_update ;
commit ;

begin ;
delete from tb_dml_delete;
select * from tb_dml_delete;
commit ;

-- test trigger
begin ;
insert into tb_t1 values (1);
select * from tb_t2 ;
commit ;

-- test function
begin ;
select insert_tb_f_func(6);
select * from tb_f ;
commit ;

-- test view
begin ;
insert into tb_v values (8);
select * from tb_v_view ;
commit ;


Thanks
Best Regards


sunbiao at highgo.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20200429/1a86be31/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0001-dml-load-balance-patch-v2.patch
Type: application/octet-stream
Size: 27590 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20200429/1a86be31/attachment-0001.obj>