… all those drives to ZFS (30 mirrors + spares + OS partition mirror) and I limited the ARC size to 4GB. I don‘t want to start a… second, you could even be more zealous. Pretty interesting to speed up point in time recovery when you dataset is 700GB. If you google… the task. Snapshots work best with InnoDB, with MyISAM you‘ll have to start the snapshot while holding a “flush tables with…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… [Don‘t try more than 2; the additional work that the kernel has to do…You can configure the slave to only replicate a specific database, a set of databases, or specific tables; you can also configure the slave to replicate…, why would you ever want to use MySQL on top of something like that? I can’t…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
…replication, a temporary table could vanish if the slave restarts and then subsequent queries against the temp table fail. Q: Why doesn’t…to add a column to the table, and populate the rows you want to choose (movies, in this case) with values known to be consecutive. Then you…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
If you are using Percona Replication Manager (PRM) with RHEL/CentOS prior to 6.4, upgrading your distribution to 6.4 may break your… if you want to upgrade, you cannot apply any rolling upgrade process. So like for Pacemaker 0.6.x to 1.0.x, you need again to… in maintenance mode (don‘t forget you should have done this even before updating the first node, but I wanted to simulate the problem): [root…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… describes very nicely how to switch to GTID-based replication, I won’t repeat it. Basically …replication to GTID replication. But if you are running a production system, you will probably want to gradually enable GTID replication…: Yes [...] The error log tells us why the IO thread has not started:…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
…replication. Because synchronous replication needs to replicate to all nodes at once, this means 1 copy of your replication message is sent to…/s This isn’t much traffic in my puny local VMs, but you get the idea. … unicast, so we still want to make sure those are configured to use the regular IP of …
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… that MySQL 5.6 brought: GTID-based replication, InnoDB Fulltext, Memcached integration, a more complete performance…for filtering by just the first one. Why can’t MySQL enforce this kind of constraints? For many…1 # Total Indexes 2 By the way, if you want to get more familiar with this and other …
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… but this involves a lot of data you don‘t need too, and isn’t flexible at all. The specific problem …to be a capital Q in Quit for that to work, and no, my code-fu was not enough to understand why… you do not want events written to the log. Just for reference, these are the lines I had to add to …
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 11, 2013 By 3 Comments
Hi Moazam, 1) no, you don‘t have to export databases, you can use the existing mysql data dir. But check http://….com/doc/percona-server/5.1/compatibility.html if you‘re planning to switch back from Percona Server 2) here is the…/5.1/feature_comparison.html 3) we’re not planning to release the windows versions of Percona Server at the moment
Comment: Profiling MySQL Memory Usage With Valgrind Massif
June 5, 2013 By 3 Comments
Aurimas – You-don‘t-run-that-in-production, the slowdown is 10x or more. If you have a server that needs Valgrinding, first you have to reduce the workload to the lightest possible that still exhibits the issue you are investigating.
