by Hrvoje Matijakovic | Dec 4, 2015 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.5.46-37.6 on December 4, 2015. Based on MySQL 5.5.46, including all the bug fixes in it, Percona Server 5.5.46-37.6 is now the current stable release in the 5.5 series. Percona Server is open-source and free....
by Vadim Tkachenko | Dec 3, 2015 | Cloud, MySQL, Percona Software
In my previous post Amazon Aurora – Looking Deeper, I promised benchmark results on Amazon Aurora. Amazon used quite a small dataset in their benchmark: 250 tables, with 25000 rows each, which in my calculation corresponds to 4.5GB worth of data. For this...
by Alexander Rubin | Dec 2, 2015 | MySQL
Join Alexander Rubin, Principal Consultant, Percona as he provides an overview of MySQL 5.7 features. Wednesday, December 9, 2015 10:00AM PST (GMT -08:00). MySQL® 5.7 is a great release that has a lot to offer, especially in the areas of development and replication....
by Daniel Guzmán Burgos | Dec 2, 2015 | Insight for DBAs, MySQL
Errant transactions are a major issue when using GTID replication. Although this isn’t something new, the drawbacks are more notorious with GTID than with regular replication. The situation where errant transaction bites you is a common DBA task: Failover. Now...
by Pablo Padua | Dec 1, 2015 | MySQL
Here’s a step-by-step guide on how to invert roles for master and slave so you can perform a master server upgrade, and then switch roles back to the original setup. * While following this guide consider server-A as your original master and server-B as your original...
by Nilnandan Joshi | Dec 1, 2015 | MySQL
Recently, I was working on a MySQL support ticket where a customer was facing an issue while transporting tablespace from MySQL 5.6 to MySQL 5.7. After closely reviewing the situation, I saw that while importing tablespace they were getting errors such as: Shell ERROR...
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 Vadim Tkachenko | Nov 16, 2015 | Cloud, MySQL
Recently my colleague (by Percona) Yves Trudeau and colleague (by industry) Marco Tusa published their materials on Amazon Aurora. Indeed, Amazon Aurora is a hot topic these days, and we have a stream of customer inquiries regarding this technology. I’ve decided to...
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 Alexey Zhebel | Nov 9, 2015 | MySQL, Percona Events, Percona Software
Percona is pleased to announce the availability of Percona Toolkit 2.2.16, released on November 9, 2015. Percona Toolkit is a collection of advanced command-line tools to perform a variety of MySQL server and system tasks that are too difficult or complex for DBAs to...
by Hrvoje Matijakovic | Nov 5, 2015 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.6.27-75.0 on November 5, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.27, including all the bug fixes in it, Percona Server...
by Hrvoje Matijakovic | Nov 5, 2015 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.5.46-37.5 on November 5, 2015. Based on MySQL 5.5.46, including all the bug fixes in it, Percona Server 5.5.46-37.5 is now the current stable release in the 5.5 series. Percona Server is open-source and free....
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 Alexander Rubin | Oct 23, 2015 | MySQL
Personal Projects with the Internet of Things So you want to do a personal project with the Internet of Things (maybe a home automation or metrics collection or something else)? In this blog post I will tell about my recent experience with this. I will give a talk...
