Skip to main content

Bugfender Databases

Bugfender uses several databases to store data. This document provides an overview of the databases we use, their purpose, and how to access them.

danger

Be careful when running queries in the production database. Always double-check your queries and make sure you are not modifying or deleting any data unintentionally.

Elasticsearch​

Elasticsearch is a distributed, RESTful search and analytics engine capable of solving a growing number of use cases. It is used for storing and searching logs, devices, and issues.

You can access the Elasticsearch cluster using Cerebreo in the following URL:

https://cerebro-aer3coo9shaizae1pohsheen9ree0aho.bugfender.com/#!/connect?host=elasticsearch

In Cerebro, you can see the cluster health, nodes, indices, and perform searches.

Cerebro Interface

MariaDB (MySQL)​

MariaDB is a community-developed, commercially supported fork of MySQL. It is used for storing user data, device data, and other application data. You can access the MySQL database through the VPN, there's no online UI for it (we removed adminer). Some recommended tools to access the database are:

In the following screenshot, you can see how to configure DataGrip to connect to the MySQL database.

DataGrip configuration

Redis​

Redis is an open-source, in-memory data structure store, used as a database, cache, and message broker. It is used for caching and storing temporary data. You can only access the Redis database through the VPN and ssh, there's no UI for it.