Monthly Archives - March 2018

Multi-Source Replication Performance with GTID

Multi-Source Replication with GTID

In this blog post, we’ll look at the performance of multi-source replication with GTID.
Note. This blog was edited as I received some comments from Percona colleagues. I’ve updated the contents in the marked EDIT section. Thanks!
Multi-Source Replication is a topology I’ve seen discussed recently, so I decided to look into how it performs with […]

Read more

MongoDB 3.6 Retryable Writes . . . Retryable Writes

Running MongoDB

In this blog post, we will discuss MongoDB 3.6 Retryable Writes, a new application-level feature.
Background
From the beginning, MongoDB replica sets were designed to recover gracefully from many internal problems or events such as node crashes, network partitions/errors/interruptions, replica set member fail-overs, etc.
While these events eventually recover transparently to the overall replica set, in many instances […]

Read more

Percona XtraBackup 2.4.10 Is Now Available

Percona XtraBackup 8.0

Percona announces the GA release of Percona XtraBackup 2.4.10 on March 30, 2018. This release is based on MySQL 5.7.19. You can download it from our download site and apt and yum repositories.
Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot […]

Read more

Analyze MySQL Audit Logs with ClickHouse and ClickTail

ClickHouse and ClickTail

In this blog post, I’ll look at how you can analyze MySQL audit logs (Percona Server for MySQL) with ClickHouse and ClickTail.
Audit logs are available with a free plugin for Percona Server for MySQL (https://www.percona.com/doc/percona-server/LATEST/management/audit_log_plugin.html). Besides providing insights about activity on your server, you might need the logs for compliance purposes.
However, on an active server, […]

Read more

Using ProxySQL and VIRTUAL Columns to Solve ORM Issues

ProxySQL 1.4.12

In this blog post, we’ll look at using ProxySQL and VIRTUAL columns to solve object-relational mapping (ORM) issues.
There are a lot of web frameworks all around. Programmers and web designers are using them to develop and deploy any website and web application. Just to cite some of the most famous names: Drupal, Ruby on […]

Read more

Percona Live 2018 Featured Talk: Databases Have Forgotten About Single Node Performance, A Wrongheaded Trade-Off with Mat Arye

Mat Ayre TimeScale Percona Live 18

Welcome to another interview blog for the rapidly-approaching Percona Live 2018. Each post in this series highlights a Percona Live 2018 featured talk at the conference and gives a short preview of what attendees can expect to learn from the presenter.
This blog post highlights Mat Arye, Core Database Engineer at Timescale. His talk is titled Databases […]

Read more

Percona XtraDB Cluster on Amazon GP2 Volumes

In this blog post, we look at the performance of Percona XtraDB Cluster on Amazon GP2 volumes.
In our overview blog post on Best Practices for Percona XtraDB Cluster on AWS, GP2 volumes did not show good results. However, we allocated only the size needed to fit the database (200GB volumes). Percona XtraDB Cluster did not show […]

Read more

Webinar Thursday March 29, 2018: Effective Testing for Live Applications

Testing for Live Applications

Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents Effective Testing for Live Applications on March 29, 2018, at 10:00 am PDT (UTC-7) / 1:00 pm EDT (UTC-4).
When an application is hit with trouble in a live production environment, it is often difficult to:

Repeat a problematic scenario without the risk of making […]

Read more

ANALYZE TABLE Is No Longer a Blocking Operation

analyze table

In this post, I’ll discuss the fix for lp:1704195 (migrated to PS-2503), which prevents
ANALYZE TABLE from blocking all subsequent queries on the same table.
In November 2017, Percona released a fix for lp:1704195 (migrated to PS-2503), created by Laurynas Biveinis. The fix, included with Percona Server for MySQL since versions 5.6.38-83.0 and 5.7.20-18, stops
ANALYZE TABLE from invalidating […]

Read more