Commit3190eba

committed

automate tests

1 parente9491d8 commit3190ebaCopy full SHA for 3190eba

File tree

+96

-3

lines changed

+96

-3

lines changed

Lines changed: 6 additions & 0 deletions

Lines changed: 38 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,38 @@`
	`1`	`+---`
	`2`	`+`
	`3`	`+-hosts:nodes`
	`4`	`+`
	`5`	`+roles:`
	`6`	`+`
	`7`	`+ -role:postgres`
	`8`	`+pg_port:15432`
	`9`	`+pg_repo:https://github.com/kelvich/postgresql.git`
	`10`	`+pg_version_tag:xtm_patched`
	`11`	`+pg_destroy_and_init:true`
	`12`	`+pg_datadir:./postgrespro-data`
	`13`	`+`
	`14`	`+tasks:`
	`15`	`+`
	`16`	`+ -name:clone dtm sources`
	`17`	`+git:repo=https://github.com/kelvich/pg_tsdtm.git`
	`18`	`+dest=./pg_tsdtm`
	`19`	`+accept_hostkey=yes`
	`20`	`+update=yes`
	`21`	`+force=yes`
	`22`	`+register:dtm_sources`
	`23`	`+`
	`24`	`+ -name:build dtm`
	`25`	`+shell:"PG_CONFIG={{pg_dst}}/bin/pg_config make clean && PG_CONFIG={{pg_dst}}/bin/pg_config make -j {{makejobs}} install"`
	`26`	`+args:`
	`27`	`+chdir:./pg_tsdtm`
	`28`	`+when:dtm_sources.changed`
	`29`	`+`
	`30`	`+ -name:enable dtm extension on datanodes`
	`31`	`+lineinfile:`
	`32`	`+dest:"{{pg_datadir}}/postgresql.conf"`
	`33`	`+regexp:"^shared_preload_libraries"`
	`34`	`+line:"shared_preload_libraries = 'pg_dtm'"`
	`35`	`+state:present`
	`36`	`+`
	`37`	`+ -name:restart postgrespro`
	`38`	`+command:"{{pg_dst}}/bin/pg_ctl restart -w -D ./postgrespro-data -l ./postgrespro-data/pg.log"`

Lines changed: 8 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,8 +1,13 @@`
`1`	`1`	`[clients]`
`2`		`-localhost`
	`2`	`+158.250.29.4ansible_ssh_user=clusteroffset=6001`
	`3`	`+158.250.29.7ansible_ssh_user=clusteransible_ssh_port=2299offset=3001`
`3`	`4`
`4`	`5`	`[nodes]`
`5`		`-localhost`
	`6`	`+158.250.29.5ansible_ssh_user=clusteroffset=5001`
	`7`	`+158.250.29.6ansible_ssh_user=clusteroffset=4001`
	`8`	`+158.250.29.8ansible_ssh_user=clusteroffset=2001`
	`9`	`+158.250.29.9ansible_ssh_user=clusteroffset=1001`
	`10`	`+158.250.29.10ansible_ssh_user=clusteroffset=1`
`6`	`11`
`7`	`12`	`[master]`
`8`		`-localhost`
	`13`	`+158.250.29.10ansible_ssh_user=clusteroffset=1`

Lines changed: 8 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,8 @@`
	`1`	`+[clients]`
	`2`	`+client1 ansible_ssh_user=cluster offset=6001`
	`3`	`+`
	`4`	`+[nodes]`
	`5`	`+nodes1 ansible_ssh_user=cluster offset=2001`
	`6`	`+`
	`7`	`+[master]`
	`8`	`+master1 ansible_ssh_user=cluster offset=1`

Lines changed: 36 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,36 @@`
	`1`	`+---`
	`2`	`+`
	`3`	`+-hosts:clients`
	`4`	`+gather_facts:no`
	`5`	`+tasks:`
	`6`	`+`
	`7`	`+ -name:generate connstrings`
	`8`	`+set_fact:`
	`9`	`+connstr:"-C 'host={{item}} user=cluster port=15432 dbname=postgres'"`
	`10`	`+with_items:`
	`11`	`+groups['nodes'] \| reverse \| batch(nnodes \| d(2) \| int) \| first`
	`12`	`+register:connstrs`
	`13`	`+`
	`14`	`+ -name:make a list`
	`15`	`+set_fact:`
	`16`	`+connections:"{{ connstrs.results \| map(attribute='ansible_facts.connstr') \| join }}"`
	`17`	`+`
	`18`	`+ -name:copy transfers binary`
	`19`	`+copy:src=perf/perf.linux dest=~/perf mode=a+x`
	`20`	`+`
	`21`	`+-hosts:clients[0]`
	`22`	`+gather_facts:no`
	`23`	`+tasks:`
	`24`	`+ -name:fill the databases`
	`25`	`+shell:"./perf {{connections}} -g -i"`
	`26`	`+register:transfers_result`
	`27`	`+ -debug:"var=transfers_result"`
	`28`	`+`
	`29`	`+-hosts:clients[0]`
	`30`	`+gather_facts:no`
	`31`	`+tasks:`
	`32`	`+ -name:run transfers`
	`33`	`+shell:"./perf {{connections}} {{runkeys \| d('-g -w 64 -r 1 -n 1000 -a 10000')}}"`
	`34`	`+register:transfers_result`
	`35`	`+ -debug:var=transfers_result`
	`36`	`+`

Comments

(0)