June 19, 2013

Post: Experiences with the McAfee MySQL Audit Plugin

the general log enabled. The flexibility comes from the three variables that can be set to control what is logged by the plugin: – audit_recordquery“:”Connect”} In conclusion, the plugin API seems to be opening new possibilities of extending MySQL

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

MySQL, downloads are available  here and from the Percona Software Repositories. Based on MySQL 5.1.69, this release will include all theto a typo. Bug fixed #1175447. Query to the INNODB_CHANGED_PAGES table would cause server to

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

from the other side, things start to degrade. If you’re just setting up a test environment to get familiar with thethe MySQL manual. You can configure the slave to only replicate a specific database, a set of databases, or specific tables; you can also configure the

Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency

getting them from the OS cache, which is another advantage of InnoDB. SSB Flight #2 Flight #2 is similar tothe keys with sort via ALTER TABLE ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql

Post: Percona Server 5.6.11-60.3 first Release Candidate now available

from the Percona Software Repositories). Based on MySQL 5.6.11, including all the bug fixes in it, Percona Server 5.6.11-60.3 is the… thus does not need to read any bitmap files. Bug fixed #1184427. Query to the INNODB_CHANGED_PAGES table would cause server to stop with an…

Post: ZFS on Linux and MySQL

the MySQL instances.  The original idea was to configure them with raid-10 + LVM, making sure to stripe the LV when we need to and align thethe tpcc test and that’s maybe just normal.  We didn’t try too hard to getrecordthe data will be read from the other drive in the

Post: Migrating between MySQL schemas with Percona Xtrabackup

table, run:  ALTER TABLE tblname DISCARD TABLESPACE Copy the .exp and .ibd files from the snapshot to the new instance:  cp /tmp/snapshot/2013-06-03_11-30/orig/*[.exp|.ibd] /var/lib/mysql

Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera

… much as you think.  While the theoretical limit of 1Gbps is actually 120MBps, I start to get nervous around 100MBps. By default Galera… really much different from standard mysql replication.  1 master with 5 async slaves is going to send a separate replication stream to each, so your…

Post: Implementing SchemaSpy in your MySQL environment

the MySQL Connector/J Install the graphiz package Creating a mysql.properties file While not explicitly required, I prefer to create this once so that the

Comment: Percona XtraBackup 2.1.3 for MySQL available for download

….6(clone+0x6d)[0x33dfee890d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0): is an invalid pointer Connection ID (thread ID): 3 Status: NOT_KILLED You may download the Percona… automatically 130528 09:53:56 mysqld_safe mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in an another…