June 19, 2013

Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2

… | +———-+ Great! So again, using GTIDs avoids the tedious work of looking for the binlog position of a specific event. The only… a solution of course, but very poor in my opinion: look for the binlog file/position of the last executed event…

Comment: Experiences with the McAfee MySQL Audit Plugin

Peter: The docs say these are offsets in the mysqld binary to some data structures. By looking at the offset extraction script it seems these are query_id, thread_id, main_security_ctx, command and lex from THD, and comment from LEX.

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

… here you are not yet using CMAN. Let’s have look at what happens if we have a cluster with 3…

Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5

… interests you, then register today to reserve your spot.  I look forward to speaking with all of you next week.

Comment: How number of columns affects performance ?

… had to add a data type column. We are probably looking at 2 million records total. Thanks! Jim.

Comment: Percona Server for MySQL 5.5.30-30.2 now available

Sergei – Please have a look at https://bugs.launchpad.net/percona-server/+bug/1169505

Comment: Sphinx search performance optimization: multi-threaded search

… WHERE …), otherwise if it’s more convenient that the index looks as if it was one index, you can create a…

Comment: ZFS on Linux and MySQL

@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/

Post: ZFS on Linux and MySQL

… overhead. I learned quite a lot about these technologies while looking at this, thanks to Corey Mosher. On the Linux side…

Post: Percona XtraBackup 2.1.3 for MySQL available for download

… XtraBackup, you can achieve the following benefits: Backups that complete quickly and reliably Uninterrupted transaction processing during backups Savings on disk…