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

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

MySQL replication out of sync: How to do a full database restore and solve error 1032 (could not execute update_rows)

Published on April 23rd 2021 - Listed in MySQL Database DB - 0 comments

How to do bulk/mass changes on DNS records in PowerDNS with MySQL backend

Published on March 2nd 2021 - Listed in DNS PowerDNS Linux Coding Shell MySQL Database - 0 comments

How to create a user and grant privileges in MySQL 8.x using GRANT

Published on November 23rd 2020 - Listed in MySQL DB Database - 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 Database - 4 comments

Convert database and tables from utf8 to utf8mb4 and solve collation errors in Jira

Published on September 29th 2020 - last updated on October 3rd 2020 - Listed in Atlassian DB MySQL - 6 comments

Atlassian Jira not starting, shows setup page in browser and database is not yet configured in logs

Published on September 8th 2020 - Listed in Atlassian DB MySQL - 0 comments

Install MySQL 5.7 on Ubuntu 20.04 focal (and properly avoid MySQL 8.0 packages)

Published on August 31st 2020 - last updated on September 3rd 2020 - Listed in MySQL Database DB Linux Ubuntu - 5 comments

Galera node unable to sync from donor: Requesting state transfer failed: -113(No route to host)

Published on April 21st 2020 - last updated on December 22nd 2020 - Listed in MySQL DB Database 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 DB 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 DB MySQL MariaDB Databases Galera - 0 comments

How to monitor MySQL or MariaDB Galera Cluster writes and avoid deadlocks

Published on May 24th 2019 - last updated on December 22nd 2020 - Listed in DB MySQL Monitoring Galera - 0 comments

How to solve Rancher 1.x service stuck in removing (in progress)

Published on February 13th 2019 - last updated on March 13th 2019 - Listed in Rancher Docker Linux Database MySQL - 1 comments

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

Published on November 9th 2018 - Listed in MySQL MariaDB DB 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 DB Databases - 0 comments

Rancher 1.6: Github user not able to login (Internal Server Error)

Published on May 31st 2018 - Listed in Docker Rancher Linux DB Database MySQL - 0 comments

Quickly show character sets and collations of all tables in a MySQL database

Published on May 30th 2018 - last updated on September 29th 2020 - Listed in DB Database MySQL - 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 Database DB Galera - 0 comments

Recover a crashed MySQL or MariaDB InnoDB database from ibd files

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

Magento2 Load Balancer Health Check for AWS ELB

Published on June 26th 2017 - Listed in AWS Internet PHP MySQL DB Linux - 0 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 DB Database MariaDB Galera - 0 comments

Tackling Confluence migration issues (Windows+MSSQL to Linux+MariaDB)

Published on March 24th 2017 - Listed in Linux Database MySQL Windows Atlassian - 0 comments

MySQL InnoDB: Operating system error number 13 in a file operation

Published on February 21st 2017 - Listed in Linux Database MySQL - 0 comments

Update MySQL table by appending text to existing column value

Published on October 6th 2016 - Listed in MySQL DB Database - 0 comments

How to measure the size of tables in MariaDB/MySQL

Published on January 27th 2016 - Listed in Database MySQL MariaDB - 0 comments

HAProxy: Make httpchk on different port than application

Published on June 11th 2015 - Listed in PHP Linux HAProxy MySQL - 1 comments

MySQL replication not working - but in SHOW SLAVE STATUS everything is OK

Published on January 16th 2015 - Listed in MySQL Database Solaris Nagios Monitoring - 0 comments

MySQL Galera cluster not starting (failed to open channel)

Published on July 14th 2014 - last updated on December 22nd 2020 - Listed in MySQL Database DB Galera - 3 comments

check_mysql_slavestatus now works with MySQL 5.6

Published on January 6th 2014 - Listed in MySQL Database DB - 0 comments

How to change the collation of a MySQL database

Published on December 11th 2013 - Listed in MySQL Database - 1 comments

check_mysql_slavestatus plugin now handles IO Running in Connecting state

Published on October 17th 2013 - Listed in Nagios MySQL Database Monitoring - 0 comments

New version of check_mysql_slave released (minor bugfixes)

Published on September 27th 2013 - Listed in Nagios MySQL Database Monitoring - 0 comments

You have an error in your SQL syntax - single quote in text issue

Published on September 19th 2013 - Listed in PHP MySQL DB - 2 comments

Changing from PHP mysql to mysqli - what to look out for

Published on September 14th 2013 - last updated on April 28th 2021 - Listed in Internet PHP MySQL - 0 comments

MySQL: Created table did not inherit default collation of database

Published on August 29th 2013 - Listed in Database MySQL - 0 comments

MySQL replication stopped due to crashed table (Error no 144)

Published on July 18th 2013 - Listed in MySQL DB Unix - 0 comments

MySQL (Percona) replication stopped due to corrupt innodb ibd file

Published on June 18th 2013 - Listed in MySQL Solaris SmartOS Unix Database - 0 comments

Updated check_mysql_slavestatus plugin and documentation

Published on April 28th 2013 - Listed in Nagios MySQL DB Monitoring - 0 comments

MySQL: Cannot create or drop Stored Procedures when binary logs active

Published on January 7th 2013 - Listed in DB Linux MySQL - 0 comments

Weird case: MySQL causing high disk IO when ZFS filesystem shrinks

Published on December 18th 2012 - Listed in BSD DB Shell MySQL ZFS - 1 comments

Get MySQL Status - but only some values

Published on November 28th 2012 - Listed in DB Linux Shell MySQL - 2 comments

Some notes on a MySQL downgrade 5.1 to 5.0

Published on August 16th 2012 - Listed in Linux DB MySQL - 0 comments

Basic math calculations with fields in MySQL query (output in new column)

Published on March 7th 2012 - Listed in Linux DB MySQL - 0 comments

Upgrade of VPS server (Xen) from Debian Lenny to Squeeze (MySQL problems)

Published on February 4th 2012 - Listed in Linux MySQL DB - 0 comments

Minor update of Nagios plugin check_mysql_slavestatus

Published on December 27th 2011 - Listed in Nagios DB MySQL Monitoring - 0 comments

Perfdata now in check_mysql_slavestatus

Published on June 22nd 2011 - Listed in Linux Nagios DB MySQL Monitoring - 0 comments

Howto change default MySQL privileges/permissions in Confixx

Published on May 24th 2011 - Listed in Linux Internet DB MySQL - 0 comments

HowTo Change Confixx email account password in Roundcube

Published on August 14th 2010 - Listed in Internet Linux PHP DB MySQL - 0 comments

Wrong latin1 Umlaut entries with phpMyAdmin 3.1.0

Published on December 4th 2008 - Listed in PHP DB MySQL - 0 comments

Cleanup Confixx after a server transfer

Published on October 21st 2008 - Listed in Linux MySQL DB - 0 comments

Update of Nagios Plugin check_mysql_slavestatus.sh

Published on October 16th 2008 - Listed in Nagios Shell MySQL DB Monitoring - 0 comments