EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Server 5.5.46-37.6 is now available

 | December 4, 2015 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, 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. Details of the release can be found in the 5.5.46-37.6 […]

Read More

Amazon Aurora in sysbench benchmarks

 | December 3, 2015 |  Posted In: Cloud and MySQL, Cloud and NoSQL, MySQL, Percona Server for MySQL

In my previous post Amazon Aurora – Looking Deeper, I promised benchmark results on Amazon Aurora. There are already some results available from Amazon itself: https://d0.awsstatic.com/product-marketing/Aurora/RDS_Aurora_Performance_Assessment_Benchmarking_v1-2.pdf. There are also some from Marco Tusa: http://www.tusacentral.net/joomla/index.php/mysql-blogs/175-aws-aurora-benchmarking-blast-or-splash.html. Amazon used quite a small dataset in their benchmark: 250 tables, with 25000 rows each, which in my calculation corresponds to 4.5GB […]

Read More

Upcoming Webinar: MySQL 5.7 in a Nutshell

 | December 2, 2015 |  Posted In: MySQL

MySQL 5.7

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. It provides many new optimizer features for developers, a much more powerful […]

Read More

Fixing errant transactions with mysqlslavetrx prior to a GTID failover

 | December 2, 2015 |  Posted In: GTID, MySQL

GTID and errant transactions

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 that tools like MHA have support for GTID replication (starting from 0.56 version), this protocol […]

Read More

How to upgrade your master server with minimal downtime

 | December 1, 2015 |  Posted In: 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 slave. We will assume server-B already produces binlogs and that […]

Read More

Transporting tablespace from MySQL 5.6 to MySQL 5.7 (case study)

 | December 1, 2015 |  Posted In: MySQL, Percona XtraBackup

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:

After some research, I found that there is a similar bug reported to MySQL for this issue (https://bugs.mysql.com/bug.php?id=76142), but […]

Read More

Smallest MySQL Server in the World (under $60) which can even make you toast while fixing MySQL bug #2

 | November 25, 2015 |  Posted In: Hardware and Storage, MySQL, Percona Server for MySQL

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 not have any local storage. If you do not have a reliable […]

Read More

Amazon Aurora – Looking Deeper

 | November 16, 2015 |  Posted In: Cloud and MySQL, Cloud and NoSQL, 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 form my own opinion, and nothing is better than a personal, hands-on experience, which I […]

Read More

pt-online-schema-change and innodb_stats_persistent on MySQL 5.6

 | November 13, 2015 |  Posted In: MySQL

pt-stalk

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 contacted us because pt-online-schema-change caused hundred of queries to […]

Read More

Logical MySQL backup tool Mydumper 0.9.1 now available

 | November 12, 2015 |  Posted In: 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 dependency on using mysqldump to ensure complex schemas are backed up alongside the data. Let’s review […]

Read More