by Peter Zaitsev | May 29, 2014 | Insight for DBAs, MySQL
MySQL has status variables “questions” and “queries” which are rather close but also a bit different, making it confusing for many people. The manual describing it might not be very easy to understand: Queries The number of statements executed...
by Vadim Tkachenko | May 28, 2014 | Insight for DBAs, MySQL, Percona Software
First, I would like to invite you to my webinar, “this post. Basically our agent allows users to collect ALL MySQL metrics plus important environment’s metrics, like CPU, memory, IO stats. And when I talk all MySQL it is: Metrics from SHOW GLOBAL STATUS (I...
by Frederic Descamps | May 28, 2014 | Insight for DBAs, MySQL
There is one new feature in MySQL 5.6 that didn’t get the attention it deserved (at least from me 😉 ) : “DATA DIRECTORY” for InnoDB tables. This is implemented since MySQL 5.6.6 and can be used only at the creation of the table. It’s not...
by Jericho Rivera | May 26, 2014 | Cloud, Insight for DBAs, MySQL, Percona Software
In my previous post, I blogged about using Percona Server with Docker and have shown you how fast and easy it was to create a virtual environment with just a few commands. This time I will be showing you how to setup a three-node Percona XtraDB Cluster (PXC) 5.6 on...
by Daniel Nichter | May 23, 2014 | Insight for DBAs, MySQL, Percona Software
There are many cool, new things happening with Percona Cloud Tools. To avoid “tl;dr” I will highlight only one new feature after a brief, general announcement. The new feature is a 3-minute MySQL monitor. I’ll blog later about other features. The...
by Yves Trudeau | May 23, 2014 | Benchmarks, Hardware and Storage, Insight for DBAs, MySQL, Percona Live
Update: do not do this, this has been proven to corrupt data! During April’s Percona Live MySQL Conference and Expo 2014, I attended a talk on MySQL 5.7 performance an scalability given by Dimitri Kravtchuk, the Oracle MySQL benchmark specialist. He mentioned at...
by John.Schulz | May 22, 2014 | MySQL
Former AOL chief database architect, now independent database consultant, John Schulz guest blogs about his experience with basic MongoDB (from MongoDB, Inc.) and TokuMX™. If you’d like to speak with John about your own big data challenges you can contact him via...
by Dave Rosenlund | May 22, 2014 | MySQL
MongoDB includes several powerful features like high availability, read scaling, and horizontal scalability in an easy-to-use, schema-free database platform. But, what if you could retain those properties, improve performance, and ensure scalability without...
by Laurynas Biveinis | May 22, 2014 | Insight for Developers, MySQL, Percona Software
The recent WebScaleSQL announcement has made quite a splash in the MySQL community over the last few weeks, and with a good reason. The collaboration between the major MySQL-at-scale users to develop a single code branch that addresses the needs of, well, web scale,...
by Jay Janssen | May 21, 2014 | Insight for DBAs, MySQL, Percona Software
I’ve had the opportunity to train lots of people on Percona Live MySQL Conference and Expo in Santa Clara, California for the last two years. Baron even attended this year and had this say: “Jay Janssen’s tutorial on Percona XtraDB Cluster was impressive....
by Dave Rosenlund | May 20, 2014 | MySQL
If you’re reading this you may be a TokuMX user, or you’re thinking about using TokuMX. If the latter case applies, I bet you’re already using some form MongoDB today. Either way, you’ve probably heard about the MongoDB Innovation Awards announced in...
by Sergei Glushchenko | May 20, 2014 | Insight for DBAs, MySQL, Security
Database auditing is the monitoring of selected actions of database users. It doesn’t protect the database in case privileges are set incorrectly, but it can help the administrator detect mistakes. Audits are needed for security. You can track data access and be...
by Stephane Combaudon | May 19, 2014 | Insight for DBAs, MySQL
I have previously written about the new replication protocol that comes with GTIDs in MySQL 5.6. Because of this new replication protocol, you can inadvertently create errant transactions that may turn any failover to a nightmare. Let’s see the problems and the...
by Dave Rosenlund | May 16, 2014 | MySQL
Are you attending MongoDB World 2014? If so, I’d like to invite you to race ahead of the morning joggers by attending a breakfast meet-up where you’ll be able to discuss your big data challenges with database gurus: Mark Callaghan of Facebook (and the Small Datum...
by David Busby | May 16, 2014 | Benchmarks, Insight for DBAs, MySQL
Github user Adrianlzt provided a python-twisted alternative version of pyclustercheck per discussion on issue 7. Due to sporadic performance issues noted with the original implementation in SimpleHTTPserver, the benchmarks which I’ve included as part of the...
by Sergei Glushchenko | May 16, 2014 | MySQL, Percona Software
Percona has developed an Audit Log feature that is now included in Percona Server since the recent 5.5 and 5.6 releases. This implementation is alternative to the MySQL Enterprise Audit Log Plugin: Percona re-implemented the Audit Plugin code as GPL as Oracle’s code...
by Martin Arrieta | May 15, 2014 | Insight for DBAs, MySQL
In our previous post, we introduced the MySQL Fabric utility and said we would dig deeper into it. This post is the first part of our test of MySQL Fabric’s High Availability (HA) functionality. Today, we’ll review MySQL Fabric’s HA concepts, and...
by Peter Boros | May 15, 2014 | Insight for DBAs, MySQL, Percona Software
Some of us Perconians are at OpenStack summit this week in Atlanta. Matt Griffin, our director of product management, tweeted about the turbo-hipster CI talk about their experience of ALTER TABLEs running faster on Percona Server. Oracle’s Morgan Tocker then...
by Vadim Tkachenko | May 14, 2014 | Benchmarks, MySQL, Percona Software
We just released, as an open source release, our new percona-agent the agent to work with Percona Cloud Tools. This agent is written in Go. There will be more posts about percona-agent, but in the meantime I want to dedicate this one to Go, Go with MySQL and some...
by Miguel Angel Nieto | May 14, 2014 | Insight for DBAs, MySQL
Replication Constraint The combination of max_allowed_packet variable and replication in MySQL is a common source of headaches. In a nutshell, max_allowed_packet is the maximum size of a MySQL network protocol packet that the server can create or read. It has a...
