InfluxDB

[gobenizzle]

best database to complement grafana. Would be amazing!!

[lukas]

Yes, I would like to see also InfluxDB in Cloudrons App-Store

[cvachery]

What's you take on this @girish ?
I know on some previous posts you were reluctant to package databases as app because of the backups
Does this argument still stand? Maybe it could be installed as an addon then instead, as I believe the backups are done differently?

[girish]

@cvachery yeah, argument still stands. I think we have to incorporate database apps into our backup flow. For example, influx has a separate backup mechanism - https://docs.influxdata.com/influxdb/v2/admin/backup-restore/backup/ .

I think separate argument is whether Cloudron wants to support database apps. It's a whole new category of apps requiring platform work. So far , we have focused on selfhosting web apps. I am sure there is a need for this, but already selfhosting web apps takes all the time.

[cvachery]

Wouldn't it be possible then to backup the folder containing the configuration+backups made by the influxdb tool and not backuping the live data? I didn't have a deep look at how the backup are done by cloudron so maybe it

It would be great to be able to have tools other than purely webapps (thinking of wireguard and for example)but I understand it is a big step and quite a lot of work

[girish]

@cvachery said in InfluxDB:

Wouldn't it be possible then to backup the folder containing the configuration+backups made by the influxdb tool and not backuping the live data? I didn't have a deep look at how the backup are done by cloudron so maybe it

Right, it's possible. There is no code to make this flow happen and that's what I was getting it Currently, the app does not know when Cloudron creates a backup. The app actually keeps running when the backup is being made. We just backup the database and then the /app/data of an app without the app's knowledge. Databases (that we support) have transactions to generate a consistent dump file. Support for specific databases (mysql, redis, mongo, postgres) is part of our backup code/logic and this is why those db backups are safe. There is actually a race between db backup + file system backup . In practice, this has not been a problem because apps usually tend to use one or the other and do not do "transactions"/atomic operations over db+filesystem.