June 19, 2013

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

…, but trying to run a simple mysqlslap just hung on me, so that’s where I left it. Maybe I’ll… this is a viable use case. If someone can prove me wrong, I’d be interested in knowing how you’ve…

Post: MySQL Query Patterns, Optimized - Webinar questions followup

…, and especially to folks who asked the great questions.  I answered as many as we had time for  during the session, but here are all the questions with my complete answers: Q: Can you compare the use of subqueries/multiple joins…

Comment: Sphinx search performance optimization: multi-threaded search

Thanks Aurimas, I misunderstood the nature of how the indexes would work. Thanks for posting this also, it was a great help to me. I really does speed up the searches.

Post: Experiences with the McAfee MySQL Audit Plugin

… case. Maybe someone more knowledgeable in MySQL internals can enlighten me here. – audit_record_objs : List of database objects (tables, according… achieved with it. It is a very good one for me, since I think proper audit trail support has been an…

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

… for other slaves at the same time? To find an answer to these questions, let’s create a simple replication configuration… has GTID_MODE OFF, Error_code: 1593 These simple tests answer the first two questions: replication works only if all servers… positioning and some other slaves using GTID-based positioning. This answers the second question: we can have different replication modes on…

Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer

… questions about this new features that I wish you can answer me. I am not able to find any information how memcached…

Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster

Hi Peter, Nice article. Recently we shifted on following new dedicated server. … = 12 GB HDD = 1 TB IP Addresses = 2 Please help me if there is something we missed.

Comment: Is Synchronous Replication right for your app?

…’m sure it could make its way into Percona Server. :) @Peter: Yes, you are right, I am talking about commits. I… the hotspot workarounds. @Todd: Early Lock Release is new to me. I can’t imagine it working well with Galera since…

Comment: MySQL Slow query log in the table

Hi Peter, how to implement your slow query logs patch on my server . i am using Mysql Database. Please guide me step by step. It would be thanks.

Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo

… Percona Live MySQL Conference. Percona Live MySQL Conference Keynotes Tuesday Peter Zaitsev, Co-founder and CEO, Percona “Our Ever-Evolving MySQL… 5.6 and its Future in the Cloud”. Moderated by me, the panel will include MySQL industry leaders Simone Brunozzi, senior…, CEO of Continuent; Brian Aker, fellow, HP Cloud Division; and Peter Zaitsev, co-founder and CEO of Percona. The discussion will…