by Michael Coburn | Jun 19, 2015 | Cloud, MySQL, Percona Software, Webinars
Last week I hosted a webinar on using MySQL in the cloud for High Availability (HA) alongside 451 Research analyst Jason Stamper. You can watch the recording and also download the slides (free) here. Just click the “Register” button at the end of that...
by Yves Trudeau | Jun 17, 2015 | Benchmarks, Hardware and Storage, MySQL
IMPORTANT: DON’T TRY THIS IN PRODUCTION. As demonstrated by Marko (see comments), it may corrupt your data. In a post, written a few months ago, I found that using EXT4 transactions with the “data=journal” mount option, improves the write performance...
by David Ducos | Jun 15, 2015 | MySQL
We usually try to avoid subselects because sometimes they force the use of a temporary table and limits the use of indexes. But, when is good to use a subselect? This example was tested over table a (1310723 rows), b, c and d ( 5 rows each) and with MySQL version 5.5...
by Stephane Combaudon | Jun 12, 2015 | MySQL
Percona XtraDB Cluster (PXC) has become a popular option to provide high availability for MySQL servers. However many people are still having a hard time understanding what will happen to the cluster when one or several nodes leave the cluster (gracefully or...
by Kortney Runyan | Jun 10, 2015 | MySQL, Percona Live
Percona Live is moving from London to Amsterdam this year and the event is also expanding to three full days. Percona Live Europe 2015, September 21-23, will be at the Mövenpick Hotel Amsterdam City Centre. The call for speakers and Super Saver registration are now...
by Matthew Boehm | Jun 9, 2015 | MongoDB, MySQL, Percona Software
Greetings everyone! Let’s discuss a 3rd Party auditing solution to MySQL and how we can leverage MongoDB® to make sense out of all of that data. The McAfee MySQL Audit plugin does a great job of capturing, at low level, activities within a MySQL server. It does...
by Yves Trudeau | Jun 8, 2015 | Insight for DBAs, MySQL, Percona Software
Ever since MySQL replication has existed, people have dreamed of a good solution to automatically split read from write operations, sending the writes to the MySQL master and load balancing the reads over a set of MySQL slaves. While if at first it seems easy to...
by David Busby | May 18, 2015 | MySQL, Security
We have recently become a member of oCERT to aid in allowing responsible disclosure for Percona products and services as can be seen on their members page. We are presently working on the verbiage for the responsible disclosure program, and we are also investigating...
by Vadim Tkachenko | May 8, 2015 | MongoDB, MySQL
While our engineering team is working on finalizing the TokuMXse storage engine, I want to provide an experimental build that you can try and test MongoDB 3.0 with our storage engine. It is available here...
by Stephane Combaudon | May 5, 2015 | MySQL
Being schemaless is one of the key features of MongoDB. On the bright side this allows developers to easily modify the schema of their collections without waiting for the database to be ready to accept a new schema. However schemaless is not free and one of the...
by Francisco Bordenave | May 4, 2015 | Insight for DBAs, MariaDB, MySQL
MySQL replication isn’t perfect and sometimes our data gets out of sync, either by a failure in replication or human intervention. We are all familiar with Percona Toolkit’s pt-table-checksum and pt-table-sync to help us check and fix data inconsistencies...
by Stephane Combaudon | Apr 28, 2015 | Insight for DBAs, MySQL, Percona Software
I often talk with people who are very interested in the features of Percona XtraDB Cluster (PXC) such as synchronous and parallel replication, multi-node writing and high availability. However some get confused when operating a real PXC cluster because they do not...
by Tom Diederich | Apr 24, 2015 | MySQL, Percona Events, Percona Live
With highlights that included news of Percona’s acquisition of Tokutek, a lively keynote discussion with Apple legend Steve “Woz” Wozniak, scores of technical sessions, tutorials and a festive MySQL community dinner and game night, last week’s...
by Peter Zaitsev | Apr 21, 2015 | Insight for DBAs, MySQL, Webinars
MySQL sharding is one of the most used and surely the most abused MySQL scaling technology. My April 2 Dzone article, “To Shard, or Not to Shard,” proved there is indeed quite an interest in this topic. As such, I’m hosting a live webinar tomorrow...
by Peter Zaitsev | Apr 14, 2015 | MySQL
It is my pleasure to announce that Percona has acquired Tokutek and will take over development and support for TokuDB® and TokuMX™ as well as the revolutionary Fractal Tree® indexing technology that enables those products to deliver improved performance, reliability...
by Peter Zaitsev | Apr 14, 2015 | MySQL
It is my pleasure to announce that Percona has acquired Tokutek and will take over development and support for TokuDB® and TokuMX™ as well as the revolutionary Fractal Tree® indexing technology that enables those products to deliver improved performance, reliability...
by Jervin Real | Apr 10, 2015 | Benchmarks, MySQL, Percona Software
A few years back Deva wrote about how to use tcpdump on very busy hosts. That post sparked my interest about exploring how to measure the impact of tcpdump on very busy hosts. In this post, I wanted to highlight how much of an impact there really is and what options...
by Nilnandan Joshi | Apr 9, 2015 | MySQL, Percona Live
Recently, I was working on one of the issue related to locks and deadlocks with InnoDB tables and I found very interesting details about how InnoDB locks and deadlocks works with or without index for different Isolation levels. Here, I would like to describe a small...
by Matt Griffin | Apr 8, 2015 | Insight for DBAs, MySQL, Percona Live, Percona Software
In April and May, Percona will hold and participate in two OpenStack events: OpenStack Summit. Join our talks at these events in Santa Clara and Vancouver for new insights into the MySQL operations of the core of OpenStack as well as the latest information on MySQL...
by Matt Yonkovit | Apr 6, 2015 | MySQL, Percona Services
Every day hundreds of millions of dollars are wasted by allowing improperly tuned or misconfigured systems, misunderstood infrastructure, and inefficient IT operations to live and thrive in data centers around the globe. There are both direct and indirect costs...
