Season 2 Retrospective #1056

jamesbayly · 2022-05-22T21:25:17Z

jamesbayly
May 22, 2022
Maintainer

This thread is for season 2 indexers to share information about the resources they used to run their indexer. We're interested answers to the following:

Infrastructure

What cloud provider did you use (or did you run your own hardware)
How large was your compute and database instances
Did you run this in a single VM, or did you run all the services in seperate instances
Did you observe any weird behaviour with your node
What monitoring solution did you use?
Did you add any additional security settings/configuration
Did you setup HTTPS, do you know how to set this up with your own domain name?
During the load testing
- Did you change the infra size
- What CPU/Mem metrics did you record

Product

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?
What improvements can we make to the documentation? Was there anything unclear or missing
Can you please report any bugs you saw in Frontier - Bug Reporting
What is your view on the user experience of the applications, what can we improve or add in to the indexer app
Would you be willing to participate in a UX interview with our designers?

vvayffaring · 2022-05-23T01:21:43Z

vvayffaring
May 23, 2022

Hello James and all community! I'm Ambassador by Moonbeam, MantaNetwork, SubQuery and Hashnode. Also have expiriense to participant Rizon & Atolo - testnet, KiChain - testnet, Minima - Incentivecash-program

I. Infrastructure

What cloud provider did you use (or did you run your own hardware)?
Contabo CLOUD VPS S

How large was your compute and database instances?
4 vCPU Cores
8 GB RAM
200 GB SSD
32 TB Traffic
Location: Nuremberg
OS: Ubuntu 21.10 (64 Bit)

Did you run this in a single VM, or did you run all the services in seperate instances?

I run this in a single VM

Did you observe any weird behaviour with your node?

I get crached my db, because don't closed 5432 port

What monitoring solution did you use?

Grafana, Prometheus and just standard commands at terminal

Did you add any additional security settings/configuration?

Only closed 5432 port

Did you setup HTTPS, do you know how to set this up with your own domain name?

I don't setup HTTPS and own domain name

During the load testing
Did you change the infra size
What CPU/Mem metrics did you record

look at screenshot

II. Product

Thanks James for backlight code at terminal

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?

Can't answer this question now

What improvements can we make to the documentation? Was there anything unclear or missing?

In general, everything is clear, no blunders were noticed

Can you please report any bugs you saw in Frontier - Bug Reporting

WARN failed to fetch dictionary result Error: Response not successful: Received status code 404
fix please

What is your view on the user experience of the applications, what can we improve or add in to the indexer app?

Not bad in general, but I want to see how many querys we received

Would you be willing to participate in a UX interview with our designers?

Yes, sure
🚀🚀🚀🚀🚀

Discord: TonyMoon#4444
0x7C...3212

FAQ

0 replies

suntzu93 · 2022-05-23T01:34:56Z

suntzu93
May 23, 2022

What cloud provider did you use (or did you run your own hardware)

Hetzner

How large was your compute and database instances

16 vCPU Cores
64GB RAM
3TB SSD
1GB/s Unlimit
IP : 65.21.33.16

Did you run this in a single VM, or did you run all the services in seperate instances

I have run all service in single dedicated server

Did you observe any weird behaviour with your node

I got error Indexer is not healthy for polkadot few times and have to restart node. It was fixed on latest version.

What monitoring solution did you use?

I'm using netdata dashboard (monitor + alert to email )+ command line.

Did you add any additional security settings/configuration

use the UFW firewall

Did you setup HTTPS, do you know how to set this up with your own domain name?

I didnt setup but I know how to do it.

During the load testing
Did you change the infra size

No

What CPU/Mem metrics did you record

For traffic below 10req/s , I don't see my server change significantly. 1-1.5% CPU , RAM 2-3% and traffic 1-2MB/s
For last chance put as much requests through as possible. 2-2.5% CPU , RAM 3-4% and traffic 2-3MB/s

Product

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?

I can't answer now.

What improvements can we make to the documentation? Was there anything unclear or missing

clear for me.

Can you please report any bugs you saw in Frontier - Bug Reporting

Yes, reported it.

What is your view on the user experience of the applications, what can we improve or add in to the indexer app

I want to see how many queries we're receivign and received.

Would you be willing to participate in a UX interview with our designers?

yes.

0 replies

Lpaydat · 2022-05-23T03:04:06Z

Lpaydat
May 23, 2022

What cloud provider did you use (or did you run your own hardware)

AWS

How large was your compute and database instances

Southeast2 t3.medium
30 GB storage

Did you run this in a single VM, or did you run all the services in seperate instances

Single VM

Did you observe any weird behaviour with your node

In the early of testnet I got duplicated docker containers (same service but different container), maybe, due to inappropriate restart.

What monitoring solution did you use?

Grafana and normal terminal commands

Did you add any additional security settings/configuration

SSH Key with 600 permission + UFW

Did you setup HTTPS, do you know how to set this up with your own domain name?

No and Yes

During the load testing
Did you change the infra size

No

Product

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?

What improvements can we make to the documentation? Was there anything unclear or missing

documentation is really good now but some docs use full images size which make it a little bit hard to read.

Can you please report any bugs you saw in Frontier - Bug Reporting

Sure

What is your view on the user experience of the applications, what can we improve or add in to the indexer app

Some placeholder while waiting for the results
Some basic stats, for example, how many requests we got per app and can display it as a simple graph, or how many storage each project used, how many indexers that indexed that project, how many requests of that project (these can help indexer decide which project they should invest)
Improve create a plan UX #1025
We should add filters on the project plan purchase. #1026

Would you be willing to participate in a UX interview with our designers?

Yes, sure ^^

0 replies

NunoyHaxxana · 2022-05-23T07:20:47Z

NunoyHaxxana
May 23, 2022

Discord : Nunuynungning#8021

What cloud provider did you use (or did you run your own hardware)

Hetzner & Google Cloud

How large was your compute and database instances

Hetzner
AMD Ryzen 9 5950X 16-Core 32 Thread
128GB RAM
3TB SSD
1GB/s Unlimit
Google Cloud
CPU 4 Core
8GB RAM
100G SSD

Did you run this in a single VM, or did you run all the services in seperate instances

I have run all service in single dedicated server.

Did you observe any weird behaviour with your node

I got error Indexer is not healthy for polkadot. It was fixed by update latest version and restart index.

What monitoring solution did you use?

zabbix and monitor via commands line.

Did you add any additional security settings/configuration

Use the UFW firewall.

Did you setup HTTPS, do you know how to set this up with your own domain name?

I didnt setup but I know how to do it.

During the load testing
Did you change the infra size

No

What CPU/Mem metrics did you record

Disk IOPS Write :Value:6.26/s
Disk Throughput Write : 74.79KiB/s
MEM Usage 2 - 5%
CPU Usage 2 - 5%

Product
What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?

What improvements can we make to the documentation? Was there anything unclear or missing

Video guide with a step-by-step.

Can you please report any bugs you saw in Frontier - Bug Reporting

Sure.

What is your view on the user experience of the applications, what can we improve or add in to the indexer app

Interact and collaborate from anywhere with mobile. and Data Analytics that can analyze data of and display it in graphs as defined by the user. Makes choosing investments easier.

Would you be willing to participate in a UX interview with our designers?

yes.

0 replies

logosboss · 2022-05-23T08:43:37Z

logosboss
May 23, 2022

Infrastructure

What cloud provider did you use (or did you run your own hardware)
Hetzner CPX21

How large was your compute and database instances
CPU 3
RAM 4 GB
SSD 80 GB
TRAFFIC 20 TB
OS: Ubuntu 21.10 (64 Bit)

Did you run this in a single VM, or did you run all the services in seperate instances
I used a single VM

Did you observe any weird behaviour with your node
My resources were at the limit because I took a weak server.

What monitoring solution did you use?
Grafana, Prometheus.

Did you add any additional security settings/configuration
No.

Did you setup HTTPS, do you know how to set this up with your own domain name?
Yes, I used reg.ru for this.

During the load testing did you change the infra size?
No.

What CPU/Mem metrics did you record
Screenshot uploaded.
Product

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?
It was my first installation of the indexer, so no comments.

What improvements can we make to the documentation? Was there anything unclear or missing
Everything is very accessible and clearly written in the guide. The community also writes cool guides, I have nothing to add here.

Can you please report any bugs you saw in Frontier - Bug Reporting
I didn't find them.

What is your view on the user experience of the applications, what can we improve or add in to the indexer app
Navigation is quite simple and accessible for everyone.

Would you be willing to participate in a UX interview with our designers?
Can to do!
I'm just doing web design

This was my first launch of the indexer, I am an ordinary ambassador, thanks to the tightness I got new technical knowledge and understanding of how it all works.
If something didn't work out for me, then our great community immediately helped me :)
Thank you again!

Discord username:: logocrypt#2800
Indexer wallet address: 0xB22E58d1550D984b580c564E1dE7868521150988

0 replies

quasi2590 · 2022-05-23T09:30:43Z

quasi2590
May 23, 2022

Infrastructure

What cloud provider did you use (or did you run your own hardware)

AWS EC2

How large was your compute and database instances

t3.medium 2vCPU, 4 GiB Memory
30 GiB 3gp Root volume

Did you run this in a single VM, or did you run all the services in seperate instances

Single VM

Did you observe any weird behaviour with your node

Update version after found "Not Healthy" on Polkadot

What monitoring solution did you use?

AWS Monitoring and Grafana+Prometheus

Did you add any additional security settings/configuration

No

Did you setup HTTPS, do you know how to set this up with your own domain name?

No but I known how to setup

During the load testing
Did you change the infra size

No

What CPU/Mem metrics did you record

CPU During workload 20 - 39%, Normal 16 - 20%
Memory 70-80%

Product

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?

N/A

What improvements can we make to the documentation? Was there anything unclear or missing

How to set up an Indexer VM on AWS

Please add more details about theses topics
4. Select SubQuery’s AMI
7. Set network settings

Add trobuleshooting - Can not connect port 8000
Modify "Edit inbound rules"
Set source "My IP" on port 8000 and save rules

Can you please report any bugs you saw in Frontier - Bug Reporting

All founded bugs already reported.

What is your view on the user experience of the applications, what can we improve or add in to the indexer app

Withdraw took long time to update the screen, may be mention user about it.

Would you be willing to participate in a UX interview with our designers?

Yes. But I don't know about UX design..

0 replies

ptchela · 2022-05-23T09:34:49Z

ptchela
May 23, 2022

Infrastructure

What cloud provider did you use?
Hetzner Dedicated vCPU instance.

How large was your compute and database instances?
2 VCPU ( Intel® Xeon® Gold)
8 GB RAM
80 GB DISK LOCAL
Ubuntu 20.04

Did you run this in a single VM, or did you run all the services in seperate instances?
I run this in a single VM.

Did you observe any weird behaviour with your node?
There were some minor issues due to confusion with open and closed ports.

What monitoring solution did you use?

Default Hetzner "GRAPHS" in the Cloud Console.
HTOP

Did you add any additional security settings/configuration
I used firewall from hetzner Cloud Console.

Did you setup HTTPS, do you know how to set this up with your own domain name?
I haven't done it, but I know how to do it.

During the load testing
Did you change the infra size
No
What CPU/Mem metrics did you record

CPU Load - under 50% for traffic below 10req/s, up to 200% at peak loads
DISK THROUGHPUT - 200 KBps usually, short bursts up to 800 KBps
DISK IOPS - 20 iops
NETWORK TRAFFIC - 50 KBps usually
NETWORK PPS - 10-30 pps

Product

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?
Perhaps it would be nice to add auto-update.

What improvements can we make to the documentation? Was there anything unclear or missing
You can make more detailed step-by-step documents - how to set up and run a node not only on AWS but also on other popular sites, such as Hetzner, OVH, Contabo...

Can you please report any bugs you saw in [Frontier - Bug Reporting](https://github.com/subquery/subql/discussions/categories/frontier-testnet-bug-reporting)
I found two bugs: #1061 #945

_What is your view on the user experience of the applications, what can we improve or add in to the indexer app

I would add speed, reduce response time, as fast applications and sites are always nice. You can also add colors, make buttons and menus brighter, provide a clearer transition between actions. Sometimes I had to look for where a certain option or action is located. But in general, everything is pretty good.

Would you be willing to participate in a UX interview with our designers?_

No thanks, I'm not fluent in English.

0 replies

MGavrilo · 2022-05-23T11:45:31Z

MGavrilo
May 23, 2022

I. Infrastructure

What cloud provider did you use (or did you run your own hardware)?
Vultr CLOUD VPS

How large was your compute and database instances?
2 vCPUs
Ram: 2048 MB
60 GB NVMe
Bandwidth: 76.72 GB of 4000 GB
Location: Amsterdam
OS: Ubuntu 20.04 LTS x64

Did you run this in a single VM, or did you run all the services in seperate instances?

I ran this in a single VM

Did you observe any weird behaviour with your node?

For a couple of days experienced the error 'Indexer is not healthy' for polkadot. However, it was fixed upon node restart.

What monitoring solution did you use?

Grafana+ command line

Did you add any additional security settings/configuration?

No

Did you setup HTTPS, do you know how to set this up with your own domain name?

No, i didn't setup it, but i know how to do so.

During the load testing
Did you change the infra size

No

What CPU/Mem metrics did you record

CPU normal - 20%
Traffic 1-2MB/s
Memory 80%

II. Product

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?

It was my first experience with indexer, so can't elaborate more on this at the moment.

What improvements can we make to the documentation? Was there anything unclear or missing?

The documentation is very well written, everything is clear!

Can you please report any bugs you saw in Frontier - Bug Reporting

Didn't find any

What is your view on the user experience of the applications, what can we improve or add in to the indexer app?

It is user friendly, looks simple and easy for understanding, navigation is easy to use

Would you be willing to participate in a UX interview with our designers?

Yes!

Thanks a lot for the chance to participate!

0 replies

avonurt · 2022-05-23T12:02:52Z

avonurt
May 23, 2022

Indexer: Stakingcare

Discord: avonurt#7742

Infrastructure

What cloud provider did you use (or did you run your own hardware)
Answer: Hetzner Dedicated Server
How large was your compute and database instances?
Answer: AMD Ryzen 9 5950X 16 Cores (Zen3), 128 GB DDR4 ECC RAM, 2 x 3.84 TB NVMe SSD Datacenter Edition (RAID 0)
Did you run this in a single VM, or did you run all the services in seperate instances?
Answer: All infrustucture were run on one dedicated server with docker compose
Did you observe any weird behaviour with your node
Answer: We have reported following bug during the testing: Controller account config has been lost after service restarted on error #946
What monitoring solution did you use?
Answer: We used Grafana, Prometheus, Node Exporter, Cadvisor and M/MONIT
Did you add any additional security settings/configuration
Answer: We used Hetzner's built in firewall solution and UFW as a second gate to expose only needed ports
Did you setup HTTPS, do you know how to set this up with your own domain name?
Answer: We did not setup https for the testnet, but we know how to do it with nginx and ssl certificates

During the load testing

Did you change the infra size
Answer: We did not change the infra size during testing
What CPU/Mem metrics did you record

Answer:
Our metrics could be splitted in 3 dashboards:

General dashboard:
- CPU usage
- Memory usage
- Load average
- Filesystem: read [bytes/s]
- Filesystem: read [operations/s]
- Filesystem: write [bytes/s]
- Filesystem: write [operations/s]
- Network: incoming [bytes/s]
- Network: outgoing [bytes/s]
- Network: incoming [packets/s]
- Network: outgoing [packets/s]

Docker monitoring:
- Received network trafic by container
- Sent network trafic by container
- CPU usage per container
- Memory usage per container

PostgreSQL Database monitoring:
- Transactions
- Update data
- Fetch data (Select)
- Insert data
- Lock tables
- Return data
- Delete data
- Cache Hit Rate
- Conflicts/Deadlocks

Product

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?
Answer: We can not provide answers for this question at the current stage. TBD
What improvements can we make to the documentation? Was there anything unclear or missing?
Answer: It would be great to add different architecture views (deployment view, workflow view) to the documentation and cover different use-cases for the scaling possibilities, fault tolerance and backup for each service in the stack. It could be a joint effort of the team and experienced indexers. We want to be a part of this activity if needed.
Can you please report any bugs you saw in Frontier - Bug Reporting

Answer:
This bug was reported by our team: #946
We also experienced bugs that already reported by another indexers:

Register indexer after unregister #1045
Indexing status #976
Status Bug in SubQuery Indexer Admin #1003
Projects status #1021
What is your view on the user experience of the applications, what can we improve or add in to the indexer app
Answer: It would be good to reflect changes on the UI just after transaction confirmed. So, the user will see the results of the interaction very quickly.
Would you be willing to participate in a UX interview with our designers?
Answer: Yes, we would like to participate.

1 reply

vvayffaring May 24, 2022

WayneWayner · 2022-05-23T12:29:18Z

WayneWayner
May 23, 2022

Infrastructure

What cloud provider did you use (or did you run your own hardware)
- Dedicated Hetzner AX101 with Proxmox as hypervisor
How large was your compute and database instances
- Host: 32VCPU (Ryzen 9 5950X) || 128GB DDR4 ECC RAM || 2x 3.84TB Nvme DC SSD ZFS Raid 0 || 1 GBit/s bandwidth
- Subquery LXC container: 4VCPU || 8GB RAM || 100GB ZFS storage pool
Did you run this in a single VM, or did you run all the services in seperate instances
- All in one LXC container
Did you observe any weird behaviour with your node
- No
What monitoring solution did you use?
- Prometheus + Node exporter + Grafana & Proxmox monitoring
Did you add any additional security settings/configuration
- The entire subquery stack is isolated in the LXC container. A ip tables entry & the proxmox firewall must always allow communication from outside first. This means that unwanted attacks on Postgres or other accidentally exposed ports are unlikely to occur because everything is isolated by default
Did you setup HTTPS, do you know how to set this up with your own domain name?
- No I have not, but have done it many times. E.g. for my Graph Indexer
During the load testing
- Did you change the infra size
  - No. Load was very low.
- What CPU/Mem metrics did you record
  - I have recorded the full season 2. I gave Michael already access but I think there is no big deal to make this public:
  - User: subquery
  - PW: subquery
  - http://65.108.120.21:3000/d/rYdddlPWk/node-exporter-full?orgId=1&from=1652864443745&to=1652873615556

Product

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?
- Add prometheus endpoints with some metrics
What improvements can we make to the documentation? Was there anything unclear or missing
- The Notion docs are pretty good. Must be transferred to the SubQuery University
Can you please report any bugs you saw in Frontier - Bug Reporting
What is your view on the user experience of the applications, what can we improve or add in to the indexer app
Would you be willing to participate in a UX interview with our designers?
- Yes

0 replies

zhephirothz · 2022-05-23T12:38:20Z

zhephirothz
May 23, 2022

Infrastructure

What cloud provider did you use (or did you run your own hardware)

AWS

How large was your compute and database instances

Compute instance: t3.medium (Sydney)
2 vCPUs
4 GB Memory

Database instance: 30GB storage

Did you run this in a single VM, or did you run all the services in seperate instances

single VM

Did you observe any weird behaviour with your node

My node can't do delegate by the others
Try to restart many times but it didn't work.
So I do the following step
--> Add new controller (The same account identity but just newly add)
--> restart the services (docker-compose stop && docker-compose up)
"Not Healthy" on polkadot so I update the version and restart

What monitoring solution did you use?

Basic command in terminal and AWS monitoring.

Did you add any additional security settings/configuration

No

Did you setup HTTPS, do you know how to set this up with your own domain name?

Didn't setup but I know how to setup on domain

During the load testing
- Did you change the infra size
  
  No
- What CPU/Mem metrics did you record
  
  CPU
  Peak: 47.2%
  Normal: 12-17%
  Memory usage: 60% - 80%

Product

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?

N/A

What improvements can we make to the documentation? Was there anything unclear or missing

Video guide and the step for any operating system.

Can you please report any bugs you saw in [Frontier - Bug Reporting]

Reported
#1051
#1017
#1018
#1052

What is your view on the user experience of the applications, what can we improve or add in to the indexer app

It's better to have an info for any step that indexer was doing.
I found some error that occured it's just an easy to explain step but there is no info and show some weird error data.
related to this -> #1051

Would you be willing to participate in a UX interview with our designers?

Yes okay ^^

0 replies

ppraveen123 · 2022-05-23T13:23:16Z

ppraveen123
May 23, 2022

Infrastructure

What cloud provider did you use (or did you run your own hardware)

Hetzner

How large was your compute and database instances

16 VCPU
32 GB RAM
360 GB DISK LOCAL
0/20 TB TRAFFIC OUT
3TB SSD
1GB/s Unlimit
IP : 65.21.148.50

Did you run this in a single VM, or did you run all the services in seperate instances

I have run all service in single dedicated server

Did you observe any weird behaviour with your node

I got error Indexer is unhealthy for polkadot few times and restarting the node fixed the issue.

What monitoring solution did you use?

Grafana, Prometheus, Node exporter and netdata

Did you add any additional security settings/configuration

UFW Firewall and default securities provided by Service provider

Did you setup HTTPS, do you know how to set this up with your own domain name?

I did not setup but I know how to do it.

During the load testing
Did you change the infra size

No

What CPU/Mem metrics did you record

For Queries 1/sec, 2/sec, 10/sec , I see CPU Utilization between 40 - 65 %, Memory Utilization around 20 - 25 %.
Please find attached the screenshot for more details.

Product

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?

I cant think off any improvements that I can advise right now. I felt happy with the way setup its very easy and documentation. If any thing comes in the future I will surely let the Subquery team know.

What improvements can we make to the documentation? Was there anything unclear or missing

Documentation was really good. I don't feel any improvements required for the Documentation. If any thing comes in the future I will surely let the Subquery team know.

Can you please report any bugs you saw in [Frontier - Bug Reporting]
(https://github.com/subquery/subql/discussions/categories/frontier-testnet-bug-reporting)

I have opened few issues but not in the above path. Opened the below ones.

     https://github.com/subquery/subql/issues/918

     https://github.com/subquery/subql/issues/948

     https://github.com/subquery/subql/issues/950

     https://github.com/subquery/subql/issues/951

What is your view on the user experience of the applications, what can we improve or add in to the indexer app

Excellent. Very simple and easy User experience. But one suggestion : Search Indexer name also can be added apart from Indexer address in the below screen (at this page - https://frontier.subquery.network/explorer/project/0x00/indexers).

Would you be willing to participate in a UX interview with our designers?

Sorry I cant. Because I am not a seasoned UX experienced person who can give advises / give creative suggestions.

1 reply

vvayffaring May 24, 2022

ivankhrenkov777 · 2022-05-23T13:39:30Z

ivankhrenkov777
May 23, 2022

Infrastructure
What cloud provider did you use (or did you run your own hardware)
Hetzner

How large was your compute and database instances
Firstly I took the light server, then I upgraged it before load tests
First configuration:
CPU 3
RAM 4 GB
SSD 80 GB
TRAFFIC 20 TB
OS: Ubuntu 20.04

Second configuration used during load tests
CPU 8
RAM 16 GB
SSD 80 GB
TRAFFIC 20 TB
OS: Ubuntu 20.04

Did you run this in a single VM, or did you run all the services in seperate instances
I used a single VM

Did you observe any weird behaviour with your node
Everything was fine during loadtests, and load wasn't critical. There were some issues with UI, I reported about it on github and they were fixed really fast

What monitoring solution did you use?
Grafana+Prometheus+NodeExporter

Did you add any additional security settings/configuration
Yes, I have configured the firewall settings (UFW) manually and created the special section in my guide about it.

Did you setup HTTPS, do you know how to set this up with your own domain name?
No, because it wasn't required but I know how to do it

During the load testing did you change the infra size?
No. As I said, I didn't do it during the tests, but I did it before them

What CPU/Mem metrics did you record
Screenshot uploaded.

Product

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?
In fact, I was impressed with the work of the testnet in general, and all of the above, because in all the time I did not encounter serious bugs and errors. Therefore, I cannot suggest any improvements.

What improvements can we make to the documentation? Was there anything unclear or missing
As for me, everything is clearly described in the official guide, but I know that some newcomers faced with some troubles that's why I created the extended guide.
https://teletype.in/@crypto_combine/SubQuery-Frontier-Testnet

Can you please report any bugs you saw in Frontier - Bug Reporting

#997
#998

What is your view on the user experience of the applications, what can we improve or add in to the indexer app
I think that Navigation is pretty simple and native, so I have nothing to suggest

Would you be willing to participate in a UX interview with our designers?
Yes

ivankhrenkov#7691
0x431AB2f983436421247e4Ea537911C6FAD8e792C

1 reply

vvayffaring May 24, 2022

lizayarankina · 2022-05-23T14:03:44Z

lizayarankina
May 23, 2022

Infrastructure
What cloud provider did you use (or did you run your own hardware)
Hetzner

CPU 4
RAM 8 GB
SSD 40 GB
TRAFFIC 20 TB
OS: Ubuntu 20.04

Did you run this in a single VM, or did you run all the services in seperate instances
I used a single VM

Did you observe any weird behaviour with your node
No, everything was okay

What monitoring solution did you use?
Grafana, Prometheus, Node Exporter

Did you add any additional security settings/configuration
yes, I used UFW Firewall

Did you setup HTTPS, do you know how to set this up with your own domain name?
No, because it wasn't required but I know how to do it

During the load testing did you change the infra size?
No. I didn't change the infra size during all the load testing

What CPU/Mem metrics did you record
Screenshot uploaded.

Product

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?
Everything was excellent, nothing to add

What improvements can we make to the documentation? Was there anything unclear or missing
Everything was clear

Can you please report any bugs you saw in Frontier - Bug Reporting

Haven't found any bugs

What is your view on the user experience of the applications, what can we improve or add in to the indexer app
Ux is great, everything was fine

Would you be willing to participate in a UX interview with our designers?
Yes

discord- lizayarankina#5031
moniker-lizayarankina

0 replies

Ryabina-io · 2022-05-26T10:46:44Z

Ryabina-io
May 26, 2022

Indexer: 0xfEE776471B7c921Ce40a8e71C965cF126bd44788

Infrastructure

What cloud provider did you use (or did you run your own hardware)

OVH bare metal server.

How large was your compute and database instances

32GB/ 4 cores Intel(R) Xeon(R) E-2274G CPU @ 4.00GHz

Did you run this in a single VM, or did you run all the services in seperate instances

Everything was on one instance

Did you observe any weird behaviour with your node

node, and query containers opened ports to 0.0.0.0 by default

What monitoring solution did you use?

Cadvisor + Prometheus + grafana

Did you add any additional security settings/configuration

We used Cloudflare to hide server real ip

Did you setup HTTPS, do you know how to set this up with your own domain name?

Yes, we used cloudflare

During the load testing

Did you change the infra size

No

What CPU/Mem metrics did you record

CPU:

MEMORY:

Product

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?

Give indexers more control over node/query container setup.

What improvements can we make to the documentation? Was there anything unclear or missing

We want more information about indexing internals - for example, what is purpose of dictionaries?

What is your view on the user experience of the applications, what can we improve or add in to the indexer app

Everything is fine, but I wish to setup subgraphs not only with UI, but with some cli/configuration file too.

Would you be willing to participate in a UX interview with our designers?

No

0 replies

nikgrego · 2022-05-26T19:19:36Z

nikgrego
May 26, 2022

Discord: Gregory#6997
Moniker: Gregory

Infrastructure

What cloud provider did you use (or did you run your own hardware):
Hetzner

How large was your compute and database instances:
Intel(R) Core(TM) i7-7700 CPU @ 3.60GHz 8x 4200.00 MHz
2x SSD SATA 512 GB
4x RAM 16384 MB DDR4
NIC 1 Gbit - Intel I219-LM

Did you run this in a single VM, or did you run all the services in separate instances:
Single

Did you observe any weird behaviour with your node:
Were some problems with postgres pass while running with root, but all runs smoothly after creating and running all via postgres user.

What monitoring solution did you use?
Grafana, Prometheus

Did you add any additional security settings/configuration:
Only UFW

Did you setup HTTPS, do you know how to set this up with your own domain name?
I know how to setup it, but don't think it was necessary.

During the load testing

Did you change the infra size
Nope

What CPU/Mem metrics did you record
CPU min ~3% and max ~12%.

Product

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?
All runs smoothly for me, nothing to improve.

What improvements can we make to the documentation? Was there anything unclear or missing
Nope

Can you please report any bugs you saw in Frontier - Bug Reporting
I didn't observe any unknown bugs.

What is your view on the user experience of the applications, what can we improve or add in to the indexer app
I like it, all is awesome. 🔥

Would you be willing to participate in a UX interview with our designers?
Of course. I've already participated many times in such interviews + I'm designer on my own.

0 replies

vnas4you · 2022-05-26T23:46:28Z

vnas4you
May 26, 2022

Discord: Alexandr | vnas#3854
indexer ID: vnas

Infrastructure

What cloud provider did you use (or did you run your own hardware)

Hetzner Dedicated Server AX101

How large was your compute and database instances?

AMD Ryzen 9 5950X 16 Cores (Zen3),
128 GB DDR4 ECC RAM,
2 x 3.84 TB NVMe SSD Datacenter Edition (Software-RAID 1),
1 Gbit/s bandwidth

Did you run this in a single VM, or did you run all the services in separate instances?

Single VM

Did you observe any weird behaviour with your node

nothing significant

What monitoring solution did you use?

I used Grafana, Prometheus, Node Exporter

Did you add any additional security settings/configuration

I used Hetzner's built in firewall solution

Did you setup HTTPS, do you know how to set this up with your own domain name?

I didn't, but I know how to

During the load testing did you change the infra size

No I didn't

What CPU/Mem metrics did you record

1.5-3% CPU, RAM 2-4%
Due to the high power, even under loads there were no significant changes on metrics, Can provide more detailed with graphics

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?

nothing significant to add

What improvements can we make to the documentation? Was there anything unclear or missing?

As for me documentation seems fully complete

Can you please report any bugs you saw in [Frontier - Bug Reporting]

#983

#1003

#1021

What is your view on the user experience of the applications, what can we improve or add in to the indexer app

Good to have searching indexer by name,
the ability to see all indexes on one page (ability to sort them)
viewing every 10 indexers was poorly displayed

Would you be willing to participate in a UX interview with our designers?

Yes, I would like to

0 replies

PlanemoMaxim · 2022-05-27T11:00:40Z

PlanemoMaxim
May 27, 2022

Infrastructure

What cloud provider did you use (or did you run your own hardware)
Vultr Optimized Cloud (Dedicated vCPU)
How large was your compute and database instances
4 vCPUs
Ram: 16384 MB RAM
80 GB NVMe
Bandwidth Usage: 193.78 GB of 6000 GB
Location: Seattle
OS: CentOS 9 Stream x64
Did you run this in a single VM, or did you run all the services in separate instances
All in one single VM.
Did you observe any weird behaviour with your node
Nope, nothing weird was found.
What monitoring solution did you use?
I have used Prometheus, Grafana to record the usage statistics.
Did you add any additional security settings/configuratio
No.
Did you setup HTTPS, do you know how to set this up with your own domain name?
No, i didn't setup HTTPS, but i know how to do so.

During the load testing Did you change the infra size
We did not change the infra during the load test as the existing infra was enough to serve both indexers in the same machine

What CPU/Mem metrics did you record

Product

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?

Maybe RPC endpoint, more advanced logging.

What improvements can we make to the documentation? Was there anything unclear or missing
Nice detailed docs, I found it very clear.
Can you please report any bugs you saw in [Frontier - Bug Reporting](https://github.com/subquery/subql/discussions/categories/frontier-testnet-bug-reporting)
Didn't report any bugs.
What is your view on the user experience of the applications, what can we improve or add in to the indexer app
I like the UI, maybe more advanced search (cannot find my indexer by name), some filters to better selection of indexers.
Would you be willing to participate in a UX interview with our designers?
Nope, thanks.

0 replies

Hacker-web-Vi · 2022-05-27T18:48:04Z

Hacker-web-Vi
May 27, 2022

Infrastructure

What cloud provider did you use (or did you run your own hardware)?

Hetzner

How large was your compute and database instances?

4 Cores
8 GB RAM
80 NVME SSD

Did you run this in a single VM, or did you run all the services in seperate instances?

Single VM

Did you observe any weird behaviour with your node?

No, everything worked fine

What monitoring solution did you use?

Grafana+Prometheus, Hetzner monitoring

Did you add any additional security settings/configuration?

UFW firewall + SSH keys

Did you setup HTTPS, do you know how to set this up with your own domain name?

I didn't, but I know how to set up

During the load testing did you change the infra size?

No I didn't

What CPU/Mem metrics did you record?

Attached sreenshots

CPU 4-5%
RAM 20-30%

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?

Everything looks good for me

What improvements can we make to the documentation? Was there anything unclear or missing?

Documentation is clear

Can you please report any bugs you saw in Frontier - Bug Reporting?

I faced following bugs:

What is your view on the user experience of the applications, what can we improve or add in to the indexer app?

It's easy to use? I've made a few suggestions here:

UI suggestion #1022

Would you be willing to participate in a UX interview with our designers?

For sure!

Thank you for the opportunity to participate and help you in making SubQuery better!

Best regards, DanielMoon#9292

0 replies

razumv · 2022-05-28T08:13:08Z

razumv
May 28, 2022

Hey guys!

### Infrastructure

- What cloud provider did you use (or did you run your own hardware)

Hetzner

- How large was your compute and database instances

AX41:
AMD Ryzen 5 3600 Hexa-Core "Matisse" (Zen2)
64 GB DDR4 RAM
2 x 512 GB NVMe SSD (Software-RAID 1)
1 Gbit/s bandwidth

- Did you run this in a single VM, or did you run all the services in seperate instances

All in one single VM

- Did you observe any weird behaviour with your node

No, everything worked fine

- What monitoring solution did you use?

VMagent for scraping metrics => VictoriaMetrics => Grafana(+Alerts into telegram)

- Did you add any additional security settings/configuration

Firewall on CloudProvider + ufw

- Did you setup HTTPS, do you know how to set this up with your own domain name?

I'm used a domain name https://subquery-indexer.razumv.tech:8443, https via CloudFlare

- During the load testing
Did you change the infra size?

No

What CPU/Mem metrics did you record?

Cpu only 100% for all cores

### Product

- What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?

Everything looks good for me

- What improvements can we make to the documentation? Was there anything unclear or missing

Documentation is clear

- Can you please report any bugs you saw in [Frontier - Bug Reporting](https://github.com/subquery/subql/discussions/categories/frontier-testnet-bug-reporting)

Bug reported:
Small UI Bug

- What is your view on the user experience of the applications, what can we improve or add in to the indexer app

I only changed the docker-compose file so that CloudFlare proxying through port 8443 works more correctly, more familiar

version: "3"

services:
  postgres:
    image: postgres:12-alpine
    container_name: coordinator_db
    ports:
      - 5432:5432
    volumes:
      - .data/postgres:/var/lib/postgresql/data
    environment:
      POSTGRES_PASSWORD: postgres
    healthcheck:
      test: [ "CMD-SHELL", "pg_isready -U postgres" ]
      interval: 5s
      timeout: 5s
      retries: 5

  coordinator-service:
    image: onfinality/subql-coordinator:v0.1.10
    container_name: coordinator_service
    ports:
      - 8443:8443
    depends_on:
      "postgres":
        condition: service_healthy
    restart: always
    environment:
      DOCKER_DB: coordinator_db
    volumes:
      - /var/tmp/composeFiles:/var/tmp/composeFiles
      - /var/run/docker.sock:/var/run/docker.sock
    command:
      - --network=testnet
      - --ws-endpoint=https://sqtn.api.onfinality.io/public
      - --postgres-host=postgres
      - --postgres-database=postgres
      - --postgres-port=5432
      - --port=8443
    healthcheck:
      test:
        [
          "CMD",
          "curl",
          "-i",
          "-X POST",
          "http://coordinator-service:8443/graphql",
          "-H 'Content-Type: application/json'",
          "-d '{ \"query\": \"query { accountMetadata { network } }\" }'"
        ]
      interval: 5s
      timeout: 5s
      retries: 5
  proxy-server:
    image: onfinality/subql-indexer-proxy:v0.1.7
    container_name: coordinator_proxy
    ports:
      - 80:80
    depends_on:
      "coordinator-service":
        condition: service_healthy
    restart: always
    command:
      - --port=80
      - --host=0.0.0.0
      - --secret-key=qmbyd5hwac2jdcu
      - --service-url=http://coordinator-service:8443/graphql
networks:
  default:
    name: cooridnator-service

- Would you be willing to participate in a UX interview with our designers?

Sure

Thank you for the opportunity to participate and help you in making SubQuery better!

Best regards, razumv | DOUBLE TOP 🇺🇦#4876

0 replies

hitesh23k · 2022-05-28T08:16:39Z

hitesh23k
May 28, 2022

Hey! I'm from team DappLooker. Please find our answers below:

Infrastructure

What cloud provider did you use (or did you run your own hardware)

We used Hetzner Dedicated Server: https://www.hetzner.com/dedicated-rootserver/ax51-nvme

How large was your compute and database instances

1TB Storage, 64GB RAM, AMD Ryzen™ 7 3700X Octa-Core

Did you run this in a single VM, or did you run all the services in separate instances

Running on single dedicated server where multiple docker containers are running

Did you observe any weird behaviour with your node

We didn’t observe any significant load. 20% - 30% resource was used even at peak of load testing

What monitoring solution did you use?

Grafana + Prometheus + Node Exporter

Did you add any additional security settings/configuration

We firewalled ports which were not needed
Ran the docker containers without root user

Did you setup HTTPS, do you know how to set this up with your own domain name?

Yes, we have set up the domain name http://sqt-testnet.dapplooker.com:8000/
We didn’t setup https but we know how to set this up using letsencrypt ssl certificates.

During the load testing, Did you change the infra size

No

What CPU/Mem metrics did you record

20% - 30% load was observed

Product

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?

Inbuilt docker support for monitoring and alerting.
Add support to update Postgres password.

What improvements can we make to the documentation? Was there anything unclear or missing.

Documentation can be more detailed.
Sometimes announcements to upgrade versions was not proactively updated in documentation.
Teletype Documentation: https://teletype.in/@crypto_combine/SubQuery-Frontier-Testnet, This is a good example of detailed documentation.

Can you please report any bugs you saw in Frontier - Bug Reporting

Few issues were faced in early part of season2. I was not able to stake/unstake.
Withdraw unstake amount was not reflecting even after approving metamask transaction. .
There was also a bug related with commission. Commission is not reflecting after transaction
In some cases metamask confirmation dialogue does not open.

What is your view on the user experience of the applications, what can we improve or add in to the indexer app

Overall user experience is nice. Steps were clear to understand.
State change from one state to another state takes time to reflect.

Would you be willing to participate in a UX interview with our designers?

Yes, we will love to participate in UX interview.

0 replies

oniks68 · 2022-05-28T09:19:51Z

oniks68
May 28, 2022

Hello from Germany!

Infrastructure

What cloud provider did you use (or did you run your own hardware)
MIRholding B.V
Zwolle, Holland
How large was your compute and database instances

Did you run this in a single VM, or did you run all the services in seperate instances
One single VM
Did you observe any weird behaviour with your node
I would say NO! Everything worked fine!
What monitoring solution did you use?
Grafana + Prometheus
Did you add any additional security settings/configuration
Firewall on CloudProvider & ufw
Did you setup HTTPS, do you know how to set this up with your own domain name?
I'm used a domain name http://dussel.fun:8443/
During the load testing did you change the infra size?
No

What CPU/Mem metrics did you record?

Product

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?
Everything worked very well!
What improvements can we make to the documentation? Was there anything unclear or missing
I don't have much experience, but anyway the documentation was clear!
Can you please report any bugs you saw in [Frontier - Bug Reporting]

Small bugs in user interface
There was also a bug related with commission. Commission is not reflecting after transaction

Would you be willing to participate in a UX interview with our designers?
Of course, gladly

Best regards, Oli#1731

0 replies

1winning1 · 2022-05-28T11:11:47Z

1winning1
May 28, 2022

Hi everyone!

Infrastructure

What cloud provider did you use (or did you run your own hardware)
Dedicated Hetzner AX101 -> Proxmox as hypervisor
How large was your compute and database instances
Host: 32VCPU (Ryzen 9 5950X), 128GB DDR4 ECC RAM, 2x 3.84TB Nvme DC SSD ZFS Raid 0, 1 GBit/s bandwidth, Location: Helsinki -- Subquery container: Started with: 16vCores,32GB Ram,800GB NVMe SSD then reduced for testing with lower specs to: 5vCores and tested with 5GB RAM
Did you run this in a single VM, or did you run all the services in seperate instances
All in one LXC container
Did you observe any weird behaviour with your node
No
What monitoring solution did you use?
Proxmox monitoring tools
Did you add any additional security settings/configuration
Through the LXC container subquery was isolated in one environment. NATting ensure that only the ports which are really needed are reachable. Everything else is closed per default.
Did you setup HTTPS, do you know how to set this up with your own domain name?
No, but I am aware how to do it ;)
During the load testing, Did you change the infra size
Played around with lowering the specs, because the load was very low overall.
What CPU/Mem metrics did you record
The whole season was recorded through Proxmox. Never experienced any kind of bottleneck.

Product

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?
Beside the small bug everything worked very well
What improvements can we make to the documentation? Was there anything unclear or missing
The Notion docs are very detailed. Had no problems in setting up and running the indexer.
Can you please report any bugs you saw in Frontier - Bug Reporting
Had only a small bug with commission -> Commission is not reflecting after transaction
What is your view on the user experience of the applications, what can we improve or add in to the indexer app
Love the clear and simple UI.
Would you be willing to participate in a UX interview with our designers?
Yes

Best regards
Moinker: blockonaut
Discord: 1winning1#0322

0 replies

maksympanchyshyn · 2022-05-28T17:17:14Z

maksympanchyshyn
May 28, 2022

This thread is for season 2 indexers to share information about the resources they used to run their indexer. We're interested answers to the following:

Infrastructure

What cloud provider did you use (or did you run your own hardware)
Hetzner
How large was your compute and database instances
3VCPU, 4 GB RAM, 80 GB SSD
Did you run this in a single VM, or did you run all the services in seperate instances
In a single VM
Did you observe any weird behaviour with your node
No weird behaviour was observed
What monitoring solution did you use?
Default Hetzner cloud server dashboard
Did you add any additional security settings/configuration
Only firewall rules as mentioned in the docs
Did you setup HTTPS, do you know how to set this up with your own domain name?
Haven't set it up, but know how to do it.

During the load testing

Did you change the infra size
No
What CPU/Mem metrics did you record

Product

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?
Seems that they are working quite well, really enjoyed how it easy was to install and run those services. Everything is already packed in the docker, good job!
What improvements can we make to the documentation? Was there anything unclear or missing
Actually for me personally docs were quite good. Everything is clear, good job guys!
Can you please report any bugs you saw in [Frontier - Bug Reporting](https://github.com/subquery/subql/discussions/categories/frontier-testnet-bug-reporting)
Haven't noticed any new bugs which are not mentioned here already 😉
What is your view on the user experience of the applications, what can we improve or add in to the indexer app
UX is great actually. Regarding suggestions - dark mode is quite a good thing nowadays
Would you be willing to participate in a UX interview with our designers?
No, but thanks for an invitation :)

Discord: Maksym Panchyshyn#5408

0 replies

maina75 · 2022-05-29T08:22:44Z

maina75
May 29, 2022

Hi, people!

Infrastructure

What cloud provider did you use (or did you run your own hardware)
Hetzner/Germany

How large was your compute and database instances
AMD Ryzen 5 3600 Hexa-Core "Matisse" (Zen2)
64 GB DDR4 RAM
2 x 512 GB NVMe
SSD (Software-RAID 1)
1 Gbit/s Anbindung

Did you run this in a single VM, or did you run all the services in seperate instances
All in one single VM

Did you observe any weird behaviour with your node_What CPU/Mem metrics did you record?
everything worked very well

What monitoring solution did you use?
I used Grafana + Prometheus

Did you add any additional security settings/configuration?
Firewall on CloudProvider and ufw

Did you setup HTTPS, do you know how to set this up with your own domain name?
http://oniks.space:8443/

During the load testing did you change the infra size?
Nope

What CPU/Mem metrics did you record?

Product

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?
Everything went perfectly

What improvements can we make to the documentation? Was there anything unclear or missing
All documentation is written clearly and legibly. Discord has also helped me.

Can you please report any bugs you saw in [Frontier - Bug Reporting]
Small bugs in the interface surface. For example Indexing process is not always shown correctly.

Would you be willing to participate in a UX interview with our designers?
gladly! I'm waiting impatiently!

Best regards, Maina#0023

0 replies

Hamad-m · 2022-05-31T21:27:56Z

Hamad-m
May 31, 2022

Discord: shepest40#5824
moniker: shepest40

Infrastructure

What cloud provider did you use (or did you run your own hardware)

Contabo

How large was your compute and database instances?

-CPU 4
-RAM 8 GB
-200 GB
-32 TB Traffic

Did you run this in a single VM, or did you run all the services in separate instances?
-I used a single VM.
Did you observe any weird behaviour with your node

-No.
What monitoring solution did you use?

-I used Grafana.
Did you add any additional security settings/configuration

-firewall
Did you setup HTTPS, do you know how to set this up with your own domain name?

-I didn't, but I know how to do it.
During the load testing did you change the infra size

-No.
What CPU/Mem metrics did you record

-CPU 3-5%,
-RAM 2-5%

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?
-nothing so far
What improvements can we make to the documentation? Was there anything unclear or missing?

-clearer guides in different languages, video instructions
Can you please report any bugs you saw in [Frontier - Bug Reporting]

#945
#1021

What is your view on the user experience of the applications, what can we improve or add in to the indexer app

-language adaptation button,
-search by moniker,
-video/gif tips with short text

Would you be willing to participate in a UX interview with our designers?

-No, thanks)

0 replies

bobyD · 2022-06-01T17:16:12Z

bobyD
Jun 1, 2022

Hey! I'm from QuantNode team. Sorry for the delay.

Infrastructure

What cloud provider did you use (or did you run your own hardware)
Hetzner
How large was your compute and database instances
CPX41 server with 8 vCPU, 16GB RAM, 160 GB SSD Storage
Did you run this in a single VM, or did you run all the services in seperate instances
Single VM
Did you observe any weird behavior with your node
Kusuma indexing was very slow
Besides, from time to time, there were errors related to receiving indexing status for projects at logs
It would be useful for the indexer maintenance to add the possibility using of custom RPC endpoints at the next testnet phase
What monitoring solution did you use?
Hetzner Cloud Monitoring
Prometheus + Grafana
Alerting through Telegram bot
Did you add any additional security settings/configuration
I used the Hetzner Cloud Console firewall
Did you setup HTTPS, do you know how to set this up with your own domain name?
I haven't done it, but I know how to do it
During the load testing
Did you change the infra size
Yes
The performance metrics were as follows: average CPU usage - 2%, memory usage has started from 1GB and grown to 2GB

Product

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?
Our team didn't face any serious bugs and errors. But, I think, it’ll be great later on to add official docker container images to the Docker Hub
What improvements can we make to the documentation? Was there anything unclear or missing
No infrastructure requirements depending on different network workloads
I thinkFAQcreation with much more fine points for indexer running was an excellent idea. We are ready to support this initiative
Can you please report any bugs you saw in Frontier - Bug Reporting
Withdraw unstaked amount bug #1048
Undelegation bug after Indexer Unregister #1055
Collection for Failed Transaction Cases in Coordinator Service comment
What is your view on the user experience of the applications, what can we improve or add in to the indexer app
• There is no searching by indexer moniker only by wallet address, it seems not so convenient for users
• No aggregated information about plans that were proposed by indexers. Also, I think, it’ll be useful for customers to add search and sorting features among this information.
• No aggregated information about network status (current era, time left to the next one, how many queries were proceeded, inflation and queries rewards, etc)
Would you be willing to participate in a UX interview with our designers?
Yes

QuantNode team

0 replies

BrainKiller-Crypto · 2022-06-03T14:44:42Z

BrainKiller-Crypto
Jun 3, 2022

HI James and all SUBQUERY TEAM and community ! I'm Ambassador by Moonbeam and Firefly !

What cloud provider did you use (or did you run your own hardware)
RuVDS VPS
Linxdatacenter: Russia, Saint-Petersburg
How large was your compute and database instances
Ubuntu 20.04 LTS (ENG)
2x2.2GHz vCPU Core
2GB RAM
20GB HDD RAID
Internet stats:

Did you run this in a single VM, or did you run all the services in seperate instances
I run this in a single VM.
Did you observe any weird behaviour with your node
I have problem with coordinator_proxy service.
What monitoring solution did you use?
Grafana, Prometheus, Node exporter and standard hoster utility.
Did you add any additional security settings/configuration
Use the UFW firewall.
Did you setup HTTPS, do you know how to set this up with your own domain name?
I didn’t setup HTTPS.
During the load testing
Did you change the infra size
No
What CPU/Mem metrics did you record
Metrics on screenshot:

*Standart load

Peak load

Product
What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?
In my opinion, everything works fine!) However, here was one problem that I described in github #1053.
What improvements can we make to the documentation? Was there anything unclear or missing
I would like to see a separate page in the documentation where all the ports used by each service or service are briefly described.
Can you please report any bugs you saw in [Frontier - Bug Reporting](https://github.com/subquery/subql/discussions/categories/frontier-testnet-bug-reporting)
Sure
What is your view on the user experience of the applications, what can we improve or add in to the indexer app
I like the minimalistic design of the application.
It may be worth optimizing the display on mobile devices.
Would you be willing to participate in a UX interview with our designers?
Yes Sure

Discord : w124eth#5224

0xF767351d2378ffF20632409E55CCdf38021a8a5b

0 replies

skyman-dev · 2022-06-03T23:05:57Z

skyman-dev
Jun 3, 2022

Infrastructure

What cloud provider did you use (or did you run your own hardware)
Hetzner
How large was your compute and database instances
4 cpu, 160 gb NVME, 8gb RAM
Did you run this in a single VM, or did you run all the services in seperate instances
single vm using docker
What was your CPU, Memory and storage usage over season 1, did you observe any weird behaviour with your node
`90% of time used I had ~8% of CPU, 2 gb RAM, 12 gb Disk usage;
What monitoring solution did you use?
InfluxDB + Telegraf + Grafana + htop
Did you add any additional security settings/configuration
Yes, I used usfw and close all except: 22, 80, 8000, 3000, 3001, 3002, 9090, 9100
Did you setup HTTPS, do you know how to set this up with your own domain name?
No, for this testphase I don't. But I know how to setup https,
During the load testing
Did you change the infra size
No
What CPU/Mem metrics did you record

Product

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?
Seems it works fine. I had no issue, except of security in yaml with ports
What improvements can we make to the documentation? Was there anything unclear or missing
Some security how to
Can you please report any bugs you saw in [Frontier - Bug Reporting]
No bugs found, except some visual in UI
What is your view on the user experience of the applications, what can we improve or add in to the indexer app
It seems nice to have more details on some of the tabs, buttons and actions. Tooltips and/or other types of descriptions are appreciated.
Would you be willing to participate in a UX interview with our designers?
Sure, any time

0 replies

Season 2 Retrospective #1056

jamesbayly May 22, 2022 Maintainer

Replies: 79 comments · 13 replies

Product

Infrastructure

Product

What improvements can we make to the documentation? Was there anything unclear or missing?

Can you please report any bugs you saw in Frontier - Bug Reporting

What is your view on the user experience of the applications, what can we improve or add in to the indexer app?

Infrastructure

Product

Infrastructure

What cloud provider did you use (or did you run your own hardware)

How large was your compute and database instances

Did you run this in a single VM, or did you run all the services in seperate instances

Did you observe any weird behaviour with your node

What monitoring solution did you use?

Did you add any additional security settings/configuration

Did you setup HTTPS, do you know how to set this up with your own domain name?

During the load testing

Did you change the infra size

What CPU/Mem metrics did you record

Product

What improvements can we make to the @subql/node, @subql/query, @subql/indexer, @subql/subql-coordinator, or @subql/subql-indexer-proxy services?

What improvements can we make to the documentation? Was there anything unclear or missing

What is your view on the user experience of the applications, what can we improve or add in to the indexer app

Would you be willing to participate in a UX interview with our designers?

Infrastructure

Product

Infrastructure

Infrastructure

Product

Infrastructure

During the load testing

Product

jamesbayly
May 22, 2022
Maintainer

Replies: 79 comments 13 replies