…RHBA-2013-0375, RedHat encourages people to use Pacemaker in combination with the CMAN manager… mode before the update, see bellow how to perform this action [root@percona1 percona]#…crmsh (crm shell from another repository) or just install pcs (Pacemaker Configuration System) [root@percona2 …
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… traditional hardware, and I’ve seen situations where even under just a moderate load on the host system, DRBD can end… are using GTID-based replication, it looks like you’ll need to wait for the next release of MHA. Q: How do… this is a viable use case. If someone can prove me wrong, I’d be interested in knowing how you’ve set…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… then you’re laughing, if not don’t despair, you just have a bit more work ahead of you. Most of… child_B it is explicit. This has an impact on how SchemaSpy identifies the relationship, and whether you need to provide… once you’re done. What are some ERD tools you use and how do they compare with SchemaSpy? Feel free to answer…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…last executed event is 219be3a9-c3ae-11e2-b985-0800272864ba:1. How can I instruct mysqlbinlog to start reading from there? …old-style replication positioning. Conclusion Reconfiguring replication when using GTIDs is usually straightforward: just connect the slave to the correct master with…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… another equivalent solution. If you’re talking about using a temporary table to store an interim result … try writing a SQL query optimizer and see how easy it is? ;-) Generative grammars like SQL can… a query automatically would be more costly than just running the query in a suboptimal form. Q: …
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 27, 2013 By 8 Comments
… MariaDB 10.0 or vice versa. You just won’t be able to use the GTID features to automatically pick the correct… that compatibility is good. If you have any suggestion of how to make MariaDB compatible without merging all of the crap…
Comment: Is Synchronous Replication right for your app?
May 16, 2013 By 18 Comments
No, I was trying to describe a system that uses a separate service for a message queue, not MySQL at …. I was just trying to think of a scenario that might address your comment, “I’m not sure how useful it is to…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… SET count = count + 1 where achievement = ‘killed_troll’; How many players might accomplish this achievement at …from: From the same node: This will behave just like standard Innodb. The first transaction will … system requires tradeoffs. Most of us are used to the tradeoffs we take when deploying …
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… abilities of parallel replication but these apply only to some use cases. Many database maintenance operations such as “alter table” are… problem with looking at performance at just high-concurrency values? This might mislead you on how your production will be impacted. Think… at high concurrency (which is the typical situation). If you just look at performance at high concurrency you might not understand…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…-vars is used to set both of these (or any) system variables. For a quick intro to metadata locks and how they… removed. We also removed several options that probably nobody ever used, and changed/renamed other options to be more logical. The… intervals. Now –no-stalk means only that: don’t stalk, just collect, respecting –interval and –iterations as usual. So to collect…
