How To Restart a Galera Cluster in 4 Easy Steps

galera cluster, mariadb, restart galery cluster

On occasion, you may have the need to restart a Galera Cluster. This could be part of a maintenance procedure, system/node recovery after a power failure, or for another reason. Before proceeding, please take a backup of your database to prevent any potential data loss. Also, ensure that all your nodes have the same configuration … Read more

How to Migrate Data From MySQL to InfluxDB Time-Series Database

influxdb, metrics, dashboard

MySQL and InfluxDB are both popular database management systems that serve different purposes. MySQL is a relational database management system (RDBMS) that is primarily used for storing structured data, while InfluxDB is a time-series database that is specifically designed for storing and querying time-stamped data. One of the key differences between MySQL and InfluxDB is … Read more

How to Configure MariaDB/MySQL as a Grafana Datasource

grafana, dashboard, metrics

Grafana is an open-source data visualization and monitoring tool that allows users to create dashboards and panels to display data from various sources in a user-friendly and interactive manner. It supports a wide range of data sources including popular databases like MySQL, PostgreSQL, and Microsoft SQL Server, as well as cloud-based services like Amazon Web … Read more

Enabling MariaDB/MySQL Slow Query Log and How to Analyzing & Improve Performance

mysql slow query log

MySQL (MariaDB) is a popular open-source relational database management system (RDBMS) used by millions of applications worldwide. However, like all software systems, it can sometimes suffer from performance issues. This blog post will walk you through enabling MySQL performance logging in Linux, identifying slow-running queries, recognizing queries without indexes, and understanding the importance of indexing … Read more

Setup a MariaDB Galera Cluster on Ubuntu: Step-by-step Guide

mariadb, mysql, clustering, cluster

In this tutorial, we will show you how to setup a MariaDB Clustering using Galera on Ubuntu. In addition to these easy install instructions, we’ll explain what is MariaDB clustering, how does cluster work, and how to enable clustering in MariaDB on Ubuntu. MariaDB is a popular open-source database management system that offers high performance, … Read more

MySQL 5.6 – How to log slow queries (Linux)

In MySQL 5.6, they introduced a different way for logging slow queries compared to previous versions. This article will show you how to quickly, and correctly enable the slow query log which is extremely useful for debugging application performance issues. Enable Slow Query Log in MySQL 5.6 Login to your MySQL host Open the my.cnf … Read more

SQL ERROR -532 THE RELATIONSHIP CONSTRAINT-NAME RESTRICTS THE DELETION OF ROW WITH RID X’RID-NUMBER’

sqlcode=-532, sqlstate=23504

This article will explain the cause and solution to DB2 SQL Error-532 or sqlcode=-532, sqlstate=23504, which is also similar to MySQL : ERROR 1216: Cannot add or update a child row and SQL Server error: foreign key constraint failed Foreign Key Constraint Error Possible Manifestation The DELETE statement cannot be executed. The contents of the … Read more

Create a compressed MySQL database dump/backup (Linux)

This may go without saying, but backing up your database regularly is important. Hard disks can fail at anytime causing you to lose all your data (We recommend using a RAID configuration when possible for data redundancy!) Often times, we may overlook the database and simply make backups of our /www or /public_html folder that … Read more