Ask HN: How to monitoring, backup DB and medias using a VPS

Posted by bapetel on Tuesday August 08, 2023 @05:49AM
from the ask-hn dept.

I use a VPS from Contabo to host my web application

I need some advice regarding :

1. Monitoring performance and resources

2. Logging errors and other messages

3. Backup DB and media file

Why ?

Because I think it's important;

My web app has 132 users, it's a side project I want to monetize, and I need to make sure there won't be anything unexpected or abnormal happens

So, I need some advices from you

What do you think ? What can I do ? What is perfect ?

( 6 comments | 3 points | on HN )

Re:Ask HN: How to monitoring, backup DB and medias using a VPS by tiernano on Tuesday August 08, 2023 @06:33AM (#37046948)

Monitoring, try netdata. Can't remember if it can send alerts, but does show all of what's going on on your machine. For backups, I would use Borg backup or something to b2… as for Logging, there are a good few options, but not sure about free. I would guess you want it as free or cheap as possible if it's not monitizes yet…

[ Parent | on HN ]

Re:Ask HN: How to monitoring, backup DB and medias using a VPS by tiernano on Tuesday August 08, 2023 @06:59AM (#37047161)

I forgot one. Nixstats. It's not free (about 8 euro a month) but that monitors servers and, during their beta period, you get free logging too.

[ Parent | on HN ]

Re:Ask HN: How to monitoring, backup DB and medias using a VPS by shaunpud on Tuesday August 08, 2023 @06:42AM (#37047017)

1. HetrixTools Linux Server Monitoring Agent

2. Usually email/pushover alerts within the webapp itself

3. borgmatic (supports file and database) to borgbase.com

[ Parent | on HN ]

Re:Ask HN: How to monitoring, backup DB and medias using a VPS by KomoD on Tuesday August 08, 2023 @07:10AM (#37047227)

> 1. Monitoring performance and resources

Hetrix

> 3. Backup DB and media file

cronjob that copies over

[ Parent | on HN ]

Re:Ask HN: How to monitoring, backup DB and medias using a VPS by rozenmd on Tuesday August 08, 2023 @07:21AM (#37047300)

- Monitor the web server itself using an uptime checker like https://onlineornot.com (biased here, I founded it)

- Something like Sentry or Logrocket for monitoring errors

- use a cron job to backup your db, and monitor your cronjob actually runs with a heartbeat monitor

[ Parent | on HN ]

Re:Ask HN: How to monitoring, backup DB and medias using a VPS by xu3u32 on Wednesday August 09, 2023 @09:37PM (#37070820)

I use Sentry for application (django) specific errors, onlineornot for site availability.

I have staticfiles going to cloud object storage (s3)

I wrote cron jobs that trigger dumps of the postgres database.

[ Parent | on HN ]