Migrate Grafana from SQLite to Postgres

So you have a Grafana with the default storage backend (SQLite) and you want to move it to PostgreSQL ? You’ve come to the right place. Preparing First we need to dump the SQLite database, since it’s just a single file simply shut down Grafana to avoid any corruption and copy the grafana.db somewhere safe. It is usually located at /var/lib/grafana. In your Postgres DB create a grafana user and database then edit your Grafana configuration file to enable postgres storage....

May 29, 2023 · 7 min

How to read the results of fio commands

fio is a versatile tool for measuring I/O performance, and it can produce a lot of output, which can sometimes be difficult to interpret. When fio reports IOPS (Input/Output Operations Per Second), it often provides separate results for read and write operations, as well as an aggregate total. The output from fio might look something like this: read: IOPS=10k, BW=40MiB/s (42MB/s)(1000MiB/25003msec) write: IOPS=15k, BW=60MiB/s (63MB/s)(1500MiB/25003msec) In this example: The read: IOPS=10k means that the system was able to perform 10,000 read operations per second....

May 22, 2023 · 2 min

Making your Scaleway S3 bucket public with Minio/mc

A common use case for S3 buckets is to act as the backend for a CDN or some kind of caching service. Here’s how to make files inside your Scaleway S3 bucket visible with or without allowing file listing using Minio’s mc client. While creating a new bucket you will be asked if you want to make it public or not, this can be a little bit confusing if you’re used to other object storage providers like OVH’s....

May 1, 2022 · 2 min