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...
by Andrew Moore | Sep 3, 2015 | MySQL
After some recent work with systemd I’ve realized it’s power and I can come clean that I am a fan. I realize that there are multitudes of posts out there with arguments both for and against systemd but let’s look at some nice ways to have systemd...
by Tom Diederich | Sep 1, 2015 | MySQL, Percona Live
Booking.com, one of the world’s leading e-commerce companies, helps travels book nearly 1 million rooms per night. Established in 1996, Booking.com B.V. guarantees the best prices for any type of property, from small, family-run bed and breakfasts to executive...
by Jay Janssen | Aug 31, 2015 | MySQL, Percona Software
There can be a lot of confusion and lack of planning in Percona XtraDB Clusters in regards to nodes becoming desynchronized for various reasons. This can happen a few ways: An IST or SST joining node catching up after a state transfer (Joined/Joining state) Using...
by Jay Janssen | Aug 20, 2015 | MySQL, Percona Software
State Snapshot Transfer (SST) at a glance PXC uses a protocol called State Snapshot Transfer to provision a node joining an existing cluster with all the data it needs to synchronize. This is analogous to cloning a slave in asynchronous replication: you take a full...
by Tom Diederich | Aug 13, 2015 | MySQL, Percona Events, Percona Live
Storage. Everyone needs it. Whether your data is in MySQL, a NoSQL, or somewhere in the cloud, with ever-growing data volumes – along with the need for SSDs to cut latency and replication to provide insurance – an organization’s storage footprint is an...
by Jay Janssen | Aug 5, 2015 | MySQL, Percona Software
IST Basics State transfers in Galera remain a mystery to most people. Incremental State transfers (as opposed to full State Snapshot transfers) are used under the following conditions: The Joiner node reports Galera a valid Galera GTID to the cluster The Donor node...
by Vadim Tkachenko | Aug 3, 2015 | MongoDB, MySQL
In my recent benchmarks for MongoDB, we can see that the two engines WiredTiger and TokuMX struggle from periodical drops in throughput, which is clearly related to a checkpoint interval – and therefore I correspond it to a checkpoint activity. The funny thing...
by Sveta Smirnova | Jul 30, 2015 | MySQL
Lately, I saw many cases when users specified the option --base64-output=DECODE-ROWS to print out a statement representation of row events in MySQL binary logs just to get nothing. Reason for this is obvious: option --base64-output=DECODE-ROWS does not convert row...
by Vadim Tkachenko | Jul 24, 2015 | Benchmarks, MySQL, Percona Software
Previously I tested Tokutek’s Fractal Trees (TokuMX & TokuMXse) as MongoDB storage engines – today let’s look into the MySQL area. I am going to use modified LinkBench in a heavy IO-load. I compared InnoDB without compression, InnoDB with 8k...
