…node, but I wanted to simulate the problem): [root@percona3 percona]# crm configure property …any more 
It’s still possible to find the command install crmsh (crm shell from… Master/Slave Set: ms_MySQL [p_mysql] Masters: [ percona1 ] Slaves: [ percona2 percona3 ] So if you were in maintenance …
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… to store an interim result set, and then use that to …problem if the keywords were returned in a different order from what you specify in…in this case to force MySQL to scan the `title` table first, grouping by kind_id in… is that sometimes you find unexpected differences in performance like this, so …
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… of articles focused on MySQL 5.6 GTIDs. You can find part one here. …. Notice that this is the same problem for s0 (which will be late …: s1> show slave status\G [...] Executed_Gtid_Set: 219be3a9-c3ae-11e2-b985-0800272864ba:1, …a solution of course, but very poor in my opinion: look for the binlog …
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… for an easier rollback in the event of a problem. And some items in the documentation are …find an answer to these questions, let’s create a simple replication configuration with one master and two slaves, all running MySQL…but only if all servers have gtid_mode set to ON. Could it be interesting to …
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
…check Retrieved_Gtid_Set and Executed_Gtid_Set from the SHOW SLAVE OUTPUT as we can see in the example. …is causing the problems. Since SQL_SLAVE_SKIP_COUNTER doesn’t work with GTID we need to find a … in MySQL 5.6. Here are the slides from that session. I hope you find it useful: MySQL 5.6 GTID in…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…wait_timeout (introduced in MySQL 5.5) for metadata locks. Now –set-vars is used to set both of these…, and tcpdump), so you shouldn’t have a problem finding queries to run and compare. pt-query… the DBD::mysql Perl module that have problems. And there are certain versions of MySQL that have critical…
Post: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
…buzz, but you can find some grains of truth in the article “Dead database walking: MySQL‘s creator on why … not as many as we originally hoped for .. One problem we had was that we needed to prove … in the MySQL market and your product is under proprietary license (not an Open Source one) you set the …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… context. What problem were we trying to solve with these plugins? Why yet another set of MySQL monitoring plugins? The typical problem with Nagios… you will not find it anywhere but in production. The pmp-check-mysql-deadlocks plugin can help you detect such problems, in conjunction with Percona…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…in most cases you do not know where exactly memory is allocated. This was not much of the problem in MySQL… | 126984 | +——————————-+ 1 row in set…MySQL Support contract can be handy. Conclusion Understanding where MySQL can allocate memory can help us to find the cause in…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
… good place to start for finding a symptom that can trigger the problem. If you aren’t sure what… settings, but this is often all you need. Finally, make sure that the script can log into MySQL (… false positive and didn’t really catch the problem in action; or collect isn’t gathering the information …
