does/will Percona 5.6 include handlersocket? I assume it’s including the memcache nosql interface in mysql 5.6, correct?
Comment: Percona Server 5.6.11-60.3 first Release Candidate now available
June 18, 2013 By 3 Comments
Comment: Sample datasets for benchmarking and testing
June 17, 2013 By 18 Comments
the links here are useful and informative…
Comment: How to calculate a good InnoDB log file size
June 14, 2013 By 38 Comments
According to this link, https://mariadb.atlassian.net/browse/MDEV-4662 Jesper is correct and I am wrong: when InnoDB warns about not enough space in the logs, it’s overwritten its last checkpoint. Thanks to Jeremy Cole for finding out the truth.
Comment: Minimizing Downtime from Lengthy AWS Outages
June 12, 2013 By 7 Comments
Please post your experience on Percona XtraDB Cluster (PXC) on AWS. I would help us since we want to explore this option.
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
MySQL can be deployed in several ways, and that means you … you have to deal with. Even later, when asynchronous or single-threaded replication is not enough, people can use Percona XtraDB Cluster… some possible deployment and scaling scenarios, when it makes sense to use one or an other, and common pitfalls we typically see…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…to set up a relay master (it can be on the same machine if you use the BLACKHOLE storage engine…to admit that this was probably the most interesting question asked; my initial reaction was, honestly, why would you ever want to use MySQL…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…to 6.4, upgrading your distribution to 6.4 may break your cluster. In this post I will explain you how to…to update all nodes to Pacemaker 1.1.8 but to avoid again issues with the next distribution update, I prefer to use…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…using the MySQL Connector/J Install the graphiz package Creating a mysql.properties file While not explicitly required, I prefer to…_INCREMENT, PRIMARY KEY (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child_… you use and how do they compare with SchemaSpy? Feel free to answer …
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
… our VP of Consulting, will explain how to work with BigData effectively Justin Swanhart, our Senior MySQL Instructor, will continue the topic …about using pt-table-checksum tool to verify replication integrity And finally, Andrew Ferlitsch will share with how MySQL can be used to provide access to …
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
…to performance is a case-by-case decision. There are other drawbacks to using temporary tables in this way, for example when using…writing a SQL query optimizer and see how easy it is? ;-) Generative grammars like …the MySQL designers know can be improved. But there’s a finite amount of engineer-…
