pmm VS sish

For ongoing monitoring of query performance, I use Percona Monitoring & Management - it's query log provides an easy way to spot frequent queries that may need optimizing.

I cannot recommend PMM highly enough - it's free. You'll get a ton of insight into your DB's bottlenecks, and can use it to validate changes made.

I use the free, open-source tool Percona Monitoring and Management (PMM) for monitoring and graphing.

i don't know if this is an idiom or not but at my workplace each go repo has a separate tools/ directory, which only has 3 files `tools.go` , `go.mod` and `go.sum` https://github.com/percona/pmm/tree/main/tools

Curious what monitoring solution you've used that's both plug-and-play and in IaC. And in any case, nothing stops you (I like this approach, actually) from running your monitoring solution in K8s. For DBs in particular, I'm a huge fan of PMM, which is a set of extremely thorough Grafana dashboards atop VictoriaMetrics, with some discovery tooling.

Percona Monitoring and Management - Open Source tool has backups included

https://www.percona.com/software/database-tools/percona-moni...

(Percona Founder so kind of biased)

Our next project is Percona Monitoring and Management (PMM). This project is supported by Artem Gavrilov, Backend Software Engineer, and Nurlan Moldomurov, Full-Stack Engineer. PMM is a great project to contribute to during Hacktoberfest. There are minor and easy-to-do issues in Github; it is not necessary to register them in Jira. These contributions are welcome if you have any good ideas, want to improve something or simplify some process. Send your PR; the maintainers will review it as soon as possible. We also have advanced issues if you want to go for more advanced tasks.

sish - Open source ngrok/serveo alternative. SSH-based but uses a custom server written in Go. Supports WebSocket tunneling.

sish uses ssh tunneling that you can read about in their docs: https://ssi.sh/

Tunneling services can be considered as a solution in some cases. Services like ngrok, frp, localtunnel and sish create a public endpoint that tunnels communication to your local endpoint via a tunnel client.

My favourite one is https://github.com/antoniomika/sish

It uses SSH as the method of opening the remote tunnel to the public server.

Why not forget about Cloudflare and a VPN but get a 3 euro Hetzner server and install https://github.com/antoniomika/sish for dynamic DNS through SSH + Traefik with a DNS resolver and have yourself a wildcard certificate. This way you can host any service from home as long as you run a port forwarding service through SSH with a one liner on Ubuntu. Better yet make an alpine docker image with a command to route traffic to your local service for even more isolation. 😘

Personally I’ve been using sish[1] recently, lots of ngrok alternatives out there now, especially as the pricing went a bit weird

[1] https://github.com/antoniomika/sish

i used to use a similar tool called inlets but they removed the open licensing. i now self host a sish server (https://github.com/antoniomika/sish) which also uses ssh for the reverse tunnel client. so much simpler!

- Sish : Because I don't want to pay for ngrok anymore (https://github.com/antoniomika/sish)

They could create a tunneled connection. Take a look at ngrok.io or ssi.sh