The best tips & troubleshooting for MySQL/MariaDB databases.
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
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
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
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
MySQL (MariaDB) is an open-source relational database management system that powers a significant portion of the web. However, to get the most out of it, you need to keep it well-optimized. One of the best ways to achieve that is by using MySQLTuner, a Perl script that quickly reviews your MySQL settings and provides recommendations … Read more
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
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
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
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