… new features that MySQL 5.6 brought: GTID-based replication, InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL… are engine-dependent, like redundant suffixes for secondary keys in InnoDB. As some of this redundancies could be necessary, depending on…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
The main benefit of using GTIDs is to have much easier failover than with file-based replication. We will see how to change the replication topology when using GTID-based replication. That will show where GTIDs shine and where improvements are expected. This is the second post of a series of …
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
… (0): is an invalid pointer Connection ID (thread ID): 3 Status: NOT_KILLED You may download the Percona Server operations manual…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…@percona2 percona]# yum -y install pcs [root@percona2 percona]# pcs status Last updated: Thu May 23 09:24:37 2013 Last… in maintenance mode, you should have : [root@percona2 percona]# pcs status Last updated: Thu May 23 09:26:56 2013 Last… @ Thu May 23 10:20:36 2013 Member Status: Quorate Member Name ID Status —— —- —- —— percona1 1 Online percona2 2 Online percona3 3…
Comment: ZFS on Linux and MySQL
May 28, 2013 By 17 Comments
… before. @Nils, In a way that is true. Imagine running InnoDB over XFS, you will end with two sets of checksums – one that of InnoDB and other of XFS itself. In case of InnoDB, the block size – 16k – is much…
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
@JDempster: I could give the SSD to xfs also with Flashcache and the like. Don’t forget all these jbods have a raid controller write cache in front of them. I also did the Innodb tuning. @Nils: no fuse, direct kernel support. Look here: http://zfsonlinux.org/
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… write buffering, so make sure these are turned off in InnoDB.
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… many scripts ready for the task. Snapshots work best with InnoDB, with MyISAM you’ll have to start the snapshot while… ray flip a bit on a drive, instead of crashing InnoDB, it will be caught by ZFS and the data will…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
… MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. With Percona XtraBackup, you can achieve the…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 22, 2013 By 32 Comments
Does Percona have improvements to keep the InnoDB insert buffer from getting full (as in do background reads for ibuf merges when it is getting full)? That is the key to sustaining good throughput for InnoDB on iibench.
