June 18, 2013

Post: Call for papers: Percona Live London

June 14, 2013 By 1 Comment

… 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…

Filed Under: MySQL, Percona Live Tagged With:

Comment: Sphinx search performance optimization: attribute-based filters

June 13, 2013 By 11 Comments

… 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.

Filed Under: Insight for Developers, MySQL Tagged With: , ,

Post: Percona MySQL University @Portland next Monday!

June 12, 2013 By Leave a Comment

… 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…

Filed Under: Events and Announcements, MySQL, Percona MySQL Consulting, Percona MySQL Support, Percona MySQL Training, Percona MySQL University, Percona Remote DBA Tagged With: ,

Post: Implementing SchemaSpy in your MySQL environment

June 4, 2013 By 2 Comments

… 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…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: ,

Post: ZFS on Linux and MySQL

May 24, 2013 By 17 Comments

… 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…

Filed Under: Hardware and Storage, Insight for DBAs, MySQL Tagged With: , , , ,

Post: Experiences with the McAfee MySQL Audit Plugin

May 23, 2013 By 4 Comments

…-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…

Filed Under: Insight for DBAs, MySQL Tagged With: ,

Post: Migrating between MySQL schemas with Percona Xtrabackup

June 10, 2013 By 2 Comments

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…

Filed Under: Insight for DBAs, MySQL Tagged With: , , ,

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

June 7, 2013 By Leave a Comment

… 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…

Filed Under: Insight for DBAs, Insight for Developers, MySQL, MySQL Webinars Tagged With: , , ,

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

May 30, 2013 By 6 Comments

…; +———-+ | 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…

Filed Under: Insight for DBAs, MySQL Tagged With: , ,

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

May 29, 2013 By 2 Comments

….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…

Filed Under: MySQL, Percona Software Tagged With: ,
« Older Posts