June 18, 2013

Post: Call for papers: Percona Live London

… blank) in production? Are you managing multiple environments? Are you working with MySQL or its variants at the code level? Share your perspective about the internals or explain how specific features work in depth. These stories are gold! And you owe it…

Comment: Sphinx search performance optimization: attribute-based filters

… note that, as stated in the article, this technique only works well for highly selective attributes. If attributes only have few… selective columns only” section for examples where it doesn’t work well for us too.

Post: Percona MySQL University @Portland next Monday!

… Matt Yonkovit, our VP of Consulting, will explain how to work with BigData effectively Justin Swanhart, our Senior MySQL Instructor, will… event attendees. If you’re in the Portland area and work with MySQL, then this is an event you can’t…

Post: Implementing SchemaSpy in your MySQL environment

… is very straightforward and it does a lot of the work for you.  Basically if your database has Foreign Keys then… you tag the Implied relationships box, but this generally only works if you have used the exact same name (in this… syntax below if specific for MySQL, but note that SchemaSpy works for pretty much all the popular RDBMS out there. java…

Post: ZFS on Linux and MySQL

… script” you’ll many scripts ready for the task.  Snapshots work best with InnoDB, with MyISAM you’ll have to start… write cache use.  Even the fairly slow gzip-1 mode works well.  The tpcc database, which contains a lot of random… way, if a controller dies, the storage will still be working.  Also, instead of having 1 or 2 spare drives per…

Post: Experiences with the McAfee MySQL Audit Plugin

…-wise, I did basic tests on the VM I was working in and didn’t get significant differences between either output… to be a capital Q in Quit for that to work, and no, my code-fu was not enough to understand… to add to my config file for the plugin to work (plus one commented line for switching between file and socket…

Post: Migrating between MySQL schemas with Percona Xtrabackup

Recently, I was working with a client that asked about using Percona Xtrabackup to … to their current data on the current live server.  Mysqldump works well for this, but can quite slow on larger schemas… the buffer pool.  Enter Xtrabackup… As a quick refresher, Xtrabackup works by copying the dirty tablespace files while streaming the redo…

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

… single port. [Don’t try more than 2; the additional work that the kernel has to do in reordering TCP packets… so far (admittedly, not that much – I have personally only worked with one customer that’s using 5.6), is that… look forward to being able to retract them. MHA should work fine with 5.6 if you’re not using GTID…

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

…; +———-+ | count(*) | +———-+ | 2 | +———-+ Great! So again, using GTIDs avoids the tedious work of looking for the binlog position of a specific event… the topic of a future post). Unfortunately, this will not work for every use case, and until this is fixed, it…

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

….4.1-7.el6_3.1.x86_64 Everything is working :-) Let’s update our system to 6.4 on one… 3 Online, Local Now the cluster is fixed and everything works again as expected and you should be ready for the…