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

implement ProxySQL with AWS Aurora

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