Showing entries 11 to 20 of 49
« 10 Newer Entries | 10 Older Entries »
Displaying posts with tag: MySQL-Articles (reset)
MySQL to Galera Cluster Migration, Deadlock, Back to basics

This post is a lab experiment learning from migration to the Percona Xtradb Cluster (Galera) and a very unexpected DEADLOCK scenario which took me back to basics. (root@localhost) [test]>insert into app values (1); ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction Little background: We needed to work on migrating the […]

The post MySQL to Galera Cluster Migration, Deadlock, Back to basics first appeared on ..::CHANGE is INEVITABLE::...

Restoring MySQL Database from xtrabackup – facepalm moments

Learning from facepalm moments of a MySQL database restore from Percona Xtrabackup.

The post Restoring MySQL Database from xtrabackup – facepalm moments first appeared on ..::CHANGE is INEVITABLE::...

corrupted / crashed MyISAM + mysql_repair_threads = stuck “Repair with N threads”

This post explains on the usage of mysql_repair_threads for repairing myisam table & the processlist status Repair with N threads

The post corrupted / crashed MyISAM + mysql_repair_threads = stuck “Repair with N threads” first appeared on ..::CHANGE is INEVITABLE::...

Fixing inconsistency on MySQL Slave of Galera Cluster

This blog post explores the syncing options for an inconsistent MySQL slave of Galera cluster node using pt-table-sync

The post Fixing inconsistency on MySQL Slave of Galera Cluster first appeared on ..::CHANGE is INEVITABLE::...

Setting-up second mysql instance & replication on Linux in 10 steps

This is a quick setup guide of 10-steps to install and configure (multiple) MySQL instance on 3307 port, and make it slave from MySQL running on port 3306.

The post Setting-up second mysql instance & replication on Linux in 10 steps first appeared on ..::CHANGE is INEVITABLE::...

pt-table-checksum & Waiting to check replicas for differences: 0% 00:00 remain

This post discuss the pt-table-checksum & error "Waiting to check replicas for differences: 0% 00:00 remain" with a use-case and solution.

The post pt-table-checksum & Waiting to check replicas for differences: 0% 00:00 remain first appeared on ..::CHANGE is INEVITABLE::...

MySQL 1018 (HY000): Can’t read dir errno: 13 – Permission denied

MySQL ERROR 1018 (HY000): Can't read dir of './sakila/' (errno: 13 - Permission denied) caused due to moving database to a different partition and using softlink on CentOS and it's fix for SELinux.

The post MySQL 1018 (HY000): Can’t read dir errno: 13 – Permission denied first appeared on ..::CHANGE is INEVITABLE::...

Monitoring MySQL Database Backups

It’s important to monitor the (database) backups after you set-it-up. In this post we will answer a few how to monitor MySQL Database backups solutions – monitoring methods. We should see suggestions for: Monitoring Holland MySQL Backup Monitoring mysqldump backups Monitoring Xtrabackup using log Monitoring Backups using Nagios Usually we can have our backup script […]

The post Monitoring MySQL Database Backups first appeared on ..::CHANGE is INEVITABLE::...

Install Percona Monitoring Tools for Nagios – MySQL Plugins

Recently a friend asked about Installing Percona Monitoring Tools for Nagios as he was facing a few issues. I managed to set-it-up on my ubuntu VM. Sharing the the work-log of Nagios and Percona Monitoring Plugins setup steps here for some-one who’s looking for the same! Install Nagios on Ubuntu – steps: (skip to Percona […]

The post Install Percona Monitoring Tools for Nagios – MySQL Plugins first appeared on ..::CHANGE is INEVITABLE::...

UMASK & UMASK_DIR – changing default MySQL file dir permissions

UMASK and UMASK_DIR are amongst few MySQL Environment variables which defines directory and file creation modes (file permissions). In this post we will understand using UMASK & UMASK_DIR for changing the database directory and file permissions from it's default to what we need.

The post UMASK & UMASK_DIR – changing default MySQL file dir permissions first appeared on ..::CHANGE is INEVITABLE::...

Showing entries 11 to 20 of 49
« 10 Newer Entries | 10 Older Entries »