June 19, 2013

Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4

error in config: Can’t open logfile ‘/var/log/corosync.log‘ for reason: Permission denied (13).#012. So now you need to update all nodes to… Could not establish cib_ro connection: Connection refused (111) Connection to cluster failed: Transport endpoint is not connected… …but MySQL is still…

Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

…in it. All of Percona’s software is open-source and free, all the details of …log records are overwritten by the new log data. In some corner cases this could lead to assertion errors in the log… fixed #714925. mysql_set_permission was failing on Debian due to missing libdbd-mysql-perl package. Fixed …

Post: Percona XtraBackup 2.0.7 for MySQL available for download

… world’s only open-source, free …log files were bigger than 4G on the source server. Bug fixed #1164979. Due to different implementation in MySQL 5.6 errorfail when copying logs. Fixed by terminating xtrabackup process immediately on log copying failure. Bug fixed #1170806. innobackupex would fail

Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download

… spend a lot of time opening all the tablespaces. Optimization has …to different implementation in MySQL 5.6 error messages were not printed to stderr directly. Because of that all InnoDB error…xtrabackup would fail when copying logs. Fixed by terminating xtrabackup process immediately on log copying …

Post: Percona Server for MySQL 5.5.30-30.2 now available

… implementation has been improved. (Laurynas Biveinis) Bugs Fixed: Due to parse error in the percona-server.spec Percona Server rpm packages couldn… oldest untracked log records are overwritten by the new log data. In some corner cases this could lead to assertion errors in the log parser… metadata lock instead of failing or returning immediately if there is a transaction that executed a query which opened that table. Bug…

Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue

… implementation has been improved. (Laurynas Biveinis) Bugs Fixed: Due to parse error in the percona-server.spec Percona Server rpm packages couldn… oldest untracked log records are overwritten by the new log data. In some corner cases this could lead to assertion errors in the log parser… metadata lock instead of failing or returning immediately if there is a transaction that executed a query which opened that table. Bug…

Post: How to Monitor MySQL with Percona's Nagios Plugins

Failed or full LVM snapshots. LVM backup strategies can fail to delete snapshots after finishing, sometimes due to the backup script failingto open or close tables can indicate LOCK_open contention. Replication is delayed or stopped. Our plugins are structured to

Post: How Percona does a MySQL Performance Audit

to log into the machine via SSH and open up a text editor (gedit, notepad, what have you.) I want to keep this open… query fails, then you know from the errorerror log. The error log shows all sorts of interesting things. Basically, anything but silence in the error log is interesting and needs to

Post: Announcing Percona Server for MySQL version 5.5.29-30.0

…#1042946 (Sergei Glushchenko). Percona Server would fail to install on a vanilla Ubuntu 12…errors. Bugs fixed #934377, bug #1111211, bug #1116447 and #1110102 (Laurynas Biveinis). The XtraDB used to print the open…. When starting the server log tracking initialization would fail. The server would …

Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes

…an SST or in certain case fail to start like this: 120723 23:45:30 [ERROR] WSREP: Local state seqno (6… node clusters. We can see it in the log file: 120724 10:58:09 [Note] WSREP: evs::…269 INFO: Shifting CLOSED -> OPEN (TO: 0) 2012-07-24 11:42:51.271 INFO: Opened channel ‘trimethylxanthine’ 2012-07-…