by Kortney Runyan | Dec 29, 2015 | Cloud, Insight for DBAs, MongoDB, Percona Events, Percona Live
We are excited to announce that the tutorial schedule for the Percona Live Data Performance Conference 2016 is up! The schedule shows all the details for each of our informative and enlightening Percona Live tutorial sessions, including insights into InnoDB, MySQL...
by Przemysław Malkowski | Dec 21, 2015 | Insight for DBAs, MySQL, Percona Software
High Availability Have you ever wondered if your application should be able to work in read-only mode? How important is that question? MySQL seems to be the most popular database solution for web-based products. Most typical Internet application workloads consist of...
by Jervin Real | Dec 18, 2015 | Insight for DBAs, MySQL
Performance Schema In many types of database workloads, using a multi-threaded slave from 5.6+ helps improve replication performance. I’ve had a number of users enable this feature, but have not seen anyone ask how each thread is performing. Here’s a quick...
by Kortney Runyan | Dec 17, 2015 | Percona Events, Percona Live
On behalf of the Percona Live Conference Committee, I am excited to announce the sneak peek schedule for the Percona Live Data Performance Conference and Expo 2016! Percona Live Data Performance Conference and Expo Live 2016 will feature a variety of formal tracks and...
by Alexander Rubin | Nov 25, 2015 | Hardware and Storage, MySQL, Percona Software
Introduction In my last blog post, Internet of Things, Messaging and MySQL, I have showed how to start your own Internet of Things with Particle Photon board. That implementation is great, but requires constant internet (wi-fi) access as the Particle Photon board does...
by Miguel Angel Nieto | Nov 13, 2015 | MySQL
Recently we released an updated version of our Percona Toolkit with an important update for pt-online-schema-change if you use MySQL 5.6. A new parameter has been added, analyze-before-swap. What does it do? Let me explain it in more detail. A bug not a bug A customer...
by Max Bubenick | Nov 12, 2015 | MySQL
The new Mydumper 0.9.1 version, which includes many new features and bug fixes, is now available. You can download the code from here. A significant change included in this version now enables Mydumper to handle all schema objects!! So there is no longer a...
by Muhammad Irfan | Nov 4, 2015 | MySQL
MySQL 5.7 has a lot of enhancements and new features. I summarized this list previously in this blog post. Adding replication filters online is one of the MySQL 5.7 features described in this manual. However, I will describe and summarize a few examples in this blog...
by Yves Trudeau | Nov 2, 2015 | Insight for DBAs, MySQL, Percona Software
Recently, I happened to have an onsite engagement and the goal of the engagement was to move a database service to RDS Aurora. Like probably most of you, I knew the service by name but I couldn’t say much about it, so, I Googled, I listened to talks and I read...
by David Busby | Oct 29, 2015 | MySQL
Symantec published a blog post yesterday regarding MySQL and the Trojan.Chikdos.A as can be seen here The Symantec post gives detail into the behavior of the Trojan and it’s effects on the Windows system registry, yet gives little detail as to how the required...
by Francisco Bordenave | Oct 29, 2015 | Insight for DBAs, MySQL
During the last few weeks I’ve been testing and playing a bit with the new group-replication plugin available for MySQL 5.7. Before continuing I’d like to clarify some aspects: the plugin is only available in labs and is not yet ready for production. The...
by Jervin Real | Oct 26, 2015 | Percona Software
While we should be aiming for small and fast transactions with Galera, it is always possible at some point you might want a single large transaction, but what is involved? First, this is supposed to be controlled by two settings, wsrep_max_ws_rows and...
by Alexey Stroganov | Oct 26, 2015 | Benchmarks, MySQL, Percona Software
This week Oracle will release MySQL 5.7 GA, so it’s a perfect time to do a quick review of the current state of Percona Server 5.6.26, MySQL 5.6.26 and MySQL-5.7.8 RC. We used two boxes from our benchmark lab for this: – Box 1: 16 Cores+HT (32 virt...
by Kortney Runyan | Oct 16, 2015 | Percona Events
The MySQL 101 track was introduced at the 2015 Percona Live MySQL Conference & Expo in Santa Clara, California. This track was tailored specifically for software developers and other specialists with technical backgrounds wanting to acquire the basic skills needed...
by Frederic Descamps | Oct 15, 2015 | MySQL, Percona Software
On September 21st, we released Percona XtraDB Cluster 5.6.25. This is the first PXC release supporting proxy-protocol that has been included in Percona Server since 5.6.25-73.0. With this blog post, I want to promote a new feature that you may have ignored....
by Robert Barabas | Oct 9, 2015 | Insight for DBAs, MySQL
The other day a colleague and friend of mine, Peter Boros, had a case where one of our clients had to track down the process shutting down MySQL. This blog is based on the discussion we had about that internally. Our client wanted Peter to identify the culprit behind...
by Alexander Rubin | Oct 7, 2015 | Insight for DBAs, MySQL
What is Apache Spark? Apache Spark is a cluster computing framework, similar to Apache Hadoop. Wikipedia has a great description of it: Apache Spark is an open source cluster computing framework originally developed in the AMPLab at University of California, Berkeley...
by Jay Janssen | Sep 14, 2015 | Insight for DBAs, MySQL
Thanks to all who attended my webinar last week on Writing Application Code for MySQL High Availability. This blog is for me to address the extra questions I didn’t have time to answer on the stream. What do you think about using Galera Cluster but writing to a...
by Kortney Runyan | Sep 10, 2015 | Percona Events
The countdown for the annual Percona Live Data Performance Conference and Expo in Europe continues with today’s announcement of our keynote speakers! This three-day conference focuses on the latest trends, news and best practices in the MySQL, NoSQL and data in the...
by Tom Diederich | Sep 4, 2015 | MySQL, Percona Live
Facebook, with 1.49 billion monthly active users, is one of the world’s top MySQL users. Simon Martin, a production engineer on Facebook’s MySQL Infrastructure team, has been working with MySQL for most of his career, starting from 2 servers built out of spare...
