… apply any rolling upgrade process. So like for Pacemaker 0.6.x to 1.0.x, you need again to update all nodes… Current DC: percona1 – partition with quorum Version: 1.1.7-6.el6-148fccfd5985c5590cc601123c6c16e966b85d14 3 Nodes configured, 3 expected votes 7 Resources configured. ============ Online: [ percona1....x86_64 [root@percona1 ~]# rpm -q corosync corosync-1.4.1-7.el6_3.1.x86_64 Everything is working 
Let’s update our…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… a lot of people setting up clusters with 3-6+ nodes on 1 Gbps networks. 1 Gbps seems like a lot, doesn’t… interface, eth1: [all nodes]# ip ro add dev eth1 224.0.0.0/4 [all nodes]# ip ro show | grep 224 224….70.2,192.168.70.3,192.168.70.4 wsrep_cluster_address = gcomm://239.192.0.11 And this works fine…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…); Query OK, 0 rows affected, 1 warning (0.56 sec) Records: 0 Duplicates: 0 Warnings: 1 mysql> SHOW WARNINGS\G *************************** 1. row ***************************… # Size Duplicate Indexes 5 # Total Duplicate Indexes 1 # Total Indexes 3 Additionally, pt-duplicate-key-checker …
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… Flight #2 Flight #2 is similar to Flight #1. MyISAM is faster than InnoDB when the …true when the database is hot. SSB Flight #3 Here in some cases MyISAM is substantially faster…recommended to prevent assorted security risks symbolic-links=0 innodb_stats_persistent innodb_stats_auto_update=off …
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… scenarios: For these tests, all servers are running on 127.0.0.1 with ports ranging from 10000 for s0 to 10004 for… all; # For s0 s0> change master to master_host=’127.0.0.1‘,master_user=’rsandbox’,master_password=’rsandbox’,master_port=10001,master…, data may be lost or replication may be broken. Scenario #3: The master has crashed before sending all writes If the…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
since I upgrade percona xtrabackup to 2.1.3. My node is crashed and I have this error in …/sbin/mysqld(handle_fatal_signal+0x4b4)[0x6a9c64] /lib64/libpthread.so.0[0x33e060f500] /usr/sbin/mysqld[0x59636e] /usr/sbin/mysqld(_Z14wsrep_apply… cause the dump to abort. Query (0): is an invalid pointer Connection ID (thread ID): 3 Status: NOT_KILLED You may download…
Comment: Maatkit Now Supports Memcached
May 21, 2013 By 11 Comments
…//) at /usr/bin/pt-query-digest line 2676, chunk 1. Pipeline process 3 (TcpdumpParser) caused an error: Use of uninitialized value $source…/bin/pt-query-digest line 2676, chunk 2. Pipeline process 3 (TcpdumpParser) caused an error: Use of uninitialized value $source in… to bind to a particular IP address (memcached -l 10.0.2.15), and then everything magically started working.
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
… is glad to announce the release of Percona Monitoring Plugins 1.0.3 for MySQL — high-quality components to add enterprise-grade MySQL…-delay to be compatible with pt-hearbeat 2.1.8+ (bug 1103364) * Added 1-second granularity to pmp-check-mysql-deadlocks (bug…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
…TYPE | SPACE | PAGE_NO | +———-+——+———————+———-+——+——-+———+ | 741 | 1679 | PRIMARY | 1 | 3 | 738 | 3 | | 741 | 1680 | idx_actor_last_name | 1 | 0 | 738 | 4 | +———-+——+———————+———-+——+——-+———+ SYS_COLUMNS Table SYS…/lib/mysql/ibdata1 3. Recover SYS_TABLES, SYS_INDEXES, SYS_COLUMNS and SYS_FIELDS from indexes 0-1, 0-3, 0-2 and 0-4 respectively. ./bin…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… myclu P 3 3 node3 Sync T/T 0 29 0 0 0 0 1.0 0 109 0 0 09:22:24 myclu P 3 3 node3 Sync T/T 0 29 0 0 0 0 1.0 0 109 0 0 09:22:25 myclu P 3 3 node3 Sync T/T 0 29 0 0 0 0 1.0 0 109 0 0 09… myclu P 3 3 node3 Sync T/T 0 29 0 0 0 0 1.0 0 109 0 0 09:22:22 myclu P 3 3 node3 Sync T/T 0 29 0 0 0 0 1.0 0 109 0 0 Notice…
