How to change Icingaweb2 password for icingaadmin user in backend database

Published on January 20th 2025 - Listed in Icinga Monitoring Databases MySQL MariaDB - 0 comments

How to reset MariaDB root login to use unix socket authentication

Published on February 18th 2024 - Listed in MariaDB Linux Databases - 0 comments

How to list and backup only specific MySQL or MariaDB databases using Ansible Playbook

Published on November 16th 2023 - Listed in Ansible Linux MySQL MariaDB - 0 comments

Analyzing and fixing Internal Server Error in PowerDNS API and Opera DNS UI

Published on October 31st 2023 - last updated on March 5th 2025 - Listed in DNS PowerDNS MySQL MariaDB Linux - 0 comments

ERROR 3105 (HY000) at line 554: The value specified for generated column 'column' in table 'table' is not allowed

Published on October 23rd 2023 - Listed in MySQL Databases MariaDB - 1 comments

How to fix a broken MySQL / MariaDB replication (Relay log read failure) after a crash on the slave server

Published on July 26th 2023 - Listed in MySQL MariaDB Databases Linux - 0 comments

Notes for double LTS upgrade: Ubuntu 18.04 to 22.04 and MariaDB 10.3 to 10.6

Published on June 20th 2023 - last updated on September 7th 2023 - Listed in MariaDB Databases Linux - 0 comments

APT upgrade error while upgrading Galera cluster node from MariaDB 10.3 to MariaDB 10.4

Published on June 20th 2023 - Listed in Galera Databases MariaDB - 0 comments

mysqldump: Error 1412: Table definition has changed, please retry transaction when dumping table

Published on June 6th 2023 - Listed in MySQL Databases MariaDB - 0 comments

Galera garbd terminated: Group requested gcs_proto_ver: 2, max supported by this node: 0

Published on May 31st 2023 - Listed in Galera Databases MariaDB - 0 comments

(Performance) Comparison of different compression methods used in combination with mysqldump

Published on February 8th 2023 - Listed in MySQL MariaDB Databases Linux - 0 comments

New version of check_mysql_slavestatus released: Bugfix when using both -H and -S (socket) parameters

Published on January 3rd 2023 - Listed in Monitoring MySQL MariaDB Databases - 0 comments

Ansible and the problem to reset the MySQL root password (unable to connect to database, check login_user and login_password are correct)

Published on August 18th 2022 - Listed in Ansible Linux MySQL MariaDB Databases - 2 comments

After Confluence copy: java.sql.SQLException: The user specified as a definer does not exist

Published on August 17th 2022 - last updated on February 15th 2023 - Listed in Atlassian MySQL MariaDB Databases - 2 comments

check_mysql_write 1.6 available: Plugin now creates monitoring table by itself

Published on June 21st 2022 - Listed in MySQL MariaDB Databases Monitoring - 0 comments

How to append additional key value pair to a JSON object in MySQL or MariaDB

Published on May 13th 2022 - Listed in MySQL MariaDB Databases Linux Coding - 0 comments

MySQL / MariaDB mysqldump error: Cannot load from mysql.proc. The table is probably corrupted (1728)

Published on March 17th 2022 - Listed in MySQL MariaDB Databases Linux Backup - 3 comments

mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table

Published on January 26th 2022 - last updated on January 28th 2022 - Listed in MySQL MariaDB Databases Linux Backup - 0 comments

MySQL / MariaDB not logging errors (log_error file empty) on Ubuntu

Published on October 20th 2021 - Listed in MySQL MariaDB Databases Linux - 0 comments

MySQL syntax error when inserting empty values using PHP (not automatically assigned NULL)

Published on September 22nd 2021 - Listed in PHP MySQL MariaDB Databases Coding - 0 comments

Galera Cluster wsrep sst crash when trying to sync table without PK (Primary Key)

Published on May 7th 2021 - Listed in MySQL Databases MariaDB Galera - 0 comments

How to import MariaDB apt repository key behind an outgoing HTTP proxy

Published on May 1st 2021 - Listed in Linux MariaDB Internet - 0 comments

MySQL and MariaDB multi source replication and how to monitor them with check_mysql_slavestatus

Published on September 30th 2020 - Listed in Monitoring MySQL MariaDB Databases - 7 comments

Galera cluster unable to sync SST: xtrabackup checkpoints missing, failed innobackupex on donor

Published on September 23rd 2019 - last updated on November 12th 2024 - Listed in MariaDB Databases Galera - 0 comments

Monitoring plugin check_mysql_slavestatus now supports mysql option file, socket (and more updates)

Published on August 22nd 2019 - Listed in MySQL MariaDB Databases Monitoring - 0 comments

Comparing Galera cluster wsrep sst methods rsync vs. mariabackup

Published on August 20th 2019 - last updated on December 22nd 2020 - Listed in Databases MySQL MariaDB Galera - 0 comments

MariaDB Galera Cluster: When the data is in sync but the query results differ

Published on November 9th 2018 - Listed in MySQL MariaDB Databases Galera - 0 comments

Fix table increment counter in MariaDB or MySQL after manual row deletion

Published on July 24th 2018 - Listed in PHP MySQL MariaDB Databases - 0 comments

Galera node on Ubuntu 14.04 Trusty not joining after update to MariaDB 10.0.34

Published on April 25th 2018 - last updated on December 22nd 2020 - Listed in MySQL MariaDB Databases Galera - 0 comments

Recover a crashed MySQL or MariaDB InnoDB database from ibd files

Published on December 13th 2017 - Listed in Databases MySQL MariaDB - 2 comments

Galera Arbitrator garbd not starting: Exception in creating receive loop

Published on March 29th 2017 - last updated on December 22nd 2020 - Listed in MySQL Databases MariaDB Galera - 1 comments

How to measure the data size (usage) of single tables or databases in MariaDB or MySQL

Published on January 27th 2016 - last updated on February 6th 2023 - Listed in Databases MySQL MariaDB - 1 comments