Jira (PDB-5167) Obtain performance information for Estate Reporting

[Bogdan Irimie (Jira)]

Bogdan Irimie created an issue

PuppetDB / PDB-5167 Obtain performance information for Estate Reporting Issue Type: Task Assignee: Unassigned Created: 2021/06/30 12:51 AM Priority: Normal Reporter: Bogdan Irimie Add Comment

This message was sent by Atlassian Jira (v8.13.2#813002-sha1:c495a97)

[Bogdan Irimie (Jira)]

Bogdan Irimie updated an issue

PuppetDB / PDB-5167 Obtain performance information for Estate Reporting

Change By: Bogdan Irimie Epic Link: PDB-5166

Add Comment

[Bogdan Irimie (Jira)]

Bogdan Irimie updated an issue

PuppetDB / PDB-5167 Obtain performance information for Estate Reporting

Change By: Bogdan Irimie Sprint: ghost-14.07.2021

Add Comment

[Bogdan Irimie (Jira)]

Bogdan Irimie updated an issue

PuppetDB / PDB-5167 Obtain performance information for Estate Reporting Change By: Bogdan Irimie

* generate results for 10 000 up to 500 000 nodes and identify slow queries  or possible errors. Initially we should use n1/n2 servers and if they can't handle the load consider using EC2 instances form AWS. * The deployment will be composed of 1 postgresql and 1 PDB. if PDB becomes a bottleneck, we should scale to multiple PDB and add a load balancer in front of them. If PostgreSql becomes the bottleneck we should: ** identify the queries that are slow ** scale PostgreSQL horizontally ** tweak PostgreSQL settings or PDB settings

Add Comment

[Bogdan Irimie (Jira)]

Bogdan Irimie updated an issue

PuppetDB / PDB-5167 Obtain performance information for Estate Reporting Change By: Bogdan Irimie

* generate results for 10 000 up to 500 000 nodes and identify slow queries  or possible errors. Initially we should use n1/n2 servers and if they can't handle the load consider using EC2 instances form AWS.

* (optional, might require another ticket) The deployment will be composed of 1 postgresql and 1 PDB. if PDB becomes a bottleneck, we should scale to multiple PDB and add a load balancer in front of them. If PostgreSql becomes the bottleneck we should:

** identify the queries that are slow ** scale PostgreSQL horizontally ** tweak PostgreSQL settings or PDB settings

Add Comment

[Bogdan Irimie (Jira)]

Bogdan Irimie updated an issue

PuppetDB / PDB-5167 Obtain performance information for Estate Reporting

Change By: Bogdan Irimie Sprint: ghost-14.07.2021

Add Comment

[Bogdan Irimie (Jira)]

[Bogdan Irimie (Jira)]

[Andrei Filipovici (Jira)]

Andrei Filipovici commented on PDB-5167

Re: Obtain performance information for Estate Reporting Run the scenario presented in PDB-5183 on this sandbox. Upload the results in https://docs.google.com/spreadsheets/d/1eaOZhSoTyZ3k_0905_3BSDZpViz3WbTTJGQzGdoTsnI/edit#gid=0.

Add Comment

[Oana Tanasoiu (Jira)]

Oana Tanasoiu updated an issue

PuppetDB / PDB-5167

Obtain performance information for Estate Reporting

Change By: Oana Tanasoiu Story Points: 1

Add Comment

[Bogdan Irimie (Jira)]

Bogdan Irimie updated an issue

PuppetDB / PDB-5167 Obtain performance information for Estate Reporting

Change By: Bogdan Irimie * generate results for 10 000 up to 500 100 000 nodes and identify slow queries  or possible errors. Initially we should use n1/n2 servers and if they can't handle the load consider using EC2 instances form AWS. * (optional, might require another ticket)The deployment will be composed of 1 postgresql and 1 PDB. if PDB becomes a bottleneck, we should scale to multiple PDB and add a load balancer in front of them. If PostgreSql becomes the bottleneck we should:

** identify the queries that are slow ** scale PostgreSQL horizontally ** tweak PostgreSQL settings or PDB settings

Add Comment

[Bogdan Irimie (Jira)]

Bogdan Irimie updated an issue

PuppetDB / PDB-5167 Obtain performance information for Estate Reporting

Change By: Bogdan Irimie Sprint: ghost-28.07.2021

Add Comment

[Andrei Filipovici (Jira)]

Andrei Filipovici assigned an issue to Andrei Filipovici

PuppetDB / PDB-5167 Obtain performance information for Estate Reporting

Change By: Andrei Filipovici Assignee: Andrei Filipovici

Add Comment