Zendcon is a difficult conference if you work in an exhibit hall booth. At other shows, attendees ask general questions about MySql or how Oracle is guiding products. Zendcon is much more pointed. When is 5.7 multisource relication going to be available? How does Visual Explain work? How can I make sure replication goes back to semi-sync after going async? It is a great show but the level of questions are a notch or two higher than most other shows.
This is to announce that me and Daniel Nichter (Lead of Percona Toolkit) are coming to the
href="http://www.mysqlnosqlcloud.com/" target="_blank">MYSQL NOSQL & CLOUD CONFERENCE & EXPO in Buenos Aires, Argentina on Oct. 15-16.
/> There also will be local Percona experts in attendance.
class=" wp-image-18273 alignright" alt="MySQL DBA Handson Tutorial" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/10/Screen-Shot-2013-10-03-at-18.23.06.png" width="388" height="272" />Do you want to get more familiar on how to become a MySQL DBA?
Are you a developer familiar with writing applications that use MySQL but you feel a bit limited on how to manage a MySQL Database?
Yesterday we announced
href="http://www.mysqlperformanceblog.com/2013/10/07/percona-server-5-6-13-61-0-first-ga-release-is-now-available/" target="_blank">the GA release of Percona Server 5.6, the latest release of our enhanced, drop-in replacement for MySQL. Percona Server 5.6 is the best free MySQL alternative for demanding applications. Our third major release, Percona Server 5.6 offers all the improvements found in MySQL 5.6 Community Edition plus scalability, availability, backup, and security features some of which are found only in MySQL 5.6 Enterprise Edition.
I occasionally see customers who are taking backups from their PXC clusters that complain that the cluster “stalls” during the backup. As I wrote about in a
href="http://www.mysqlperformanceblog.com/2013/05/02/galera-flow-control-in-percona-xtradb-cluster-for-mysql/">previous blog post, often these stalls are really just Flow Control. But why would a backup cause Flow control?
class="alignright wp-image-12964" alt="MySQL 5.6 Configuration Optimization" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/02/Percona-MySQL-Webinars-285x300.jpg" width="200" height="210" />We had a wonderful time during the Sept. 25 webinar, “
Baron recently wrote about
href="http://www.xaprb.com/blog/2013/09/13/sending-the-query-to-the-data/">sending the query to the data looking at distributed systems like Cassandra. I want to take a look at more simple systems like MySQL and see how we’re doing in this space.
The “Too many connections” problem is a common issue with applications using excessive permissions (and those that grant said global permissions). MySQL will always grant a user with SUPER privileges access to a DB to investigate the problem with a SHOW PROCESSLIST and where you can check the limits. I however found the following.