Add MariaDB and Setup as Replica
-
I want to install and use Grafana and set up a MariaDB to use for reporting. The MariaDB would be connected to our main server which is hosted at another provider. Is it possible and practical to install the Grafana app then add one or more MariaDB to the app so we can have mirrors from our main database to use for reporting?
-
@brianb If I understand correctly, you want to run MariaDB (which is replica of some external database) next to Grafana and this MariaDB is also added to Grafana as a data source.
Cloudron has no way to run standalone databases. So, you have to run this MariaDB on another VM maybe in the same network/data center as Cloudron. You can then connect it as a datasource in Grafana.
-
@brianb said in Add MariaDB and Setup as Replica:
Can't I just create a mysql database in the grafana once it is setup in cloundron?
Not sure what you mean here. Are you referring to Grafana's database (https://grafana.com/docs/grafana/latest/setup-grafana/configure-grafana/#database) or Grafana's data source (https://grafana.com/docs/grafana/latest/datasources/mysql/)
On Cloudron, Grafana's database cannot be changed. It uses PostgreSQL internally.
If you are referring to data source, then yes, you can can mysql database data source. But I referred to MariaDB only because you mentioned MariaDB in your initial post (in fact, there is no mention of MySQL there).
