Yearly Archives - 2015

Percona Server 5.5.46-37.6 is now available

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

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 worth of […]

Read more

Upcoming Webinar: MySQL 5.7 in a Nutshell

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

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

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)

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 1808 (HY000): Schema mismatch (Table flags don’t match, server table has 0x10 and the meta-data file has 0x1)

1

ERROR […]

Read more

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

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

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

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 get […]

Read more

Logical MySQL backup tool Mydumper 0.9.1 now available

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 some […]

Read more