by Laurie Coffin | Apr 5, 2018 | Insight for DBAs, Insight for Developers, MariaDB, MongoDB, MySQL, Percona Live, PostgreSQL, ProxySQL, Storage Engine
We’ve been searching for a great venue for Percona Live Europe 2018, and I am thrilled to announce we’ll be hosting it in Frankfurt, Germany! Please block November 5-7, 2018 on your calendar now and plan to join us at the Radisson Blu Frankfurt for the premier open...
by David Murphy | Apr 5, 2018 | Insight for DBAs, Insight for Developers, MongoDB
by Dave Avery | Apr 5, 2018 | Insight for DBAs, Monitoring, MySQL, Percona Live, PostgreSQL
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...
by Sveta Smirnova | Apr 4, 2018 | Insight for DBAs, MySQL
In this blog, I will provide answers to the Q & A for the Performance Schema for MySQL Troubleshooting webinar. First, I want to thank everybody for attending my March 1, 2018, webinar. The recording and slides for the webinar are available here. Below is the list...
by Borys Belinsky | Apr 4, 2018 | Cloud, MongoDB, Monitoring, MySQL, Percona Events, Percona Software
Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL® and MongoDB® performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis...
by Tibor Korocz | Apr 4, 2018 | Insight for DBAs, Insight for Developers, MySQL
In this blog post, we’ll compare the performance of pattern matching queries vs. full-text indexes. In my previous blog post, I looked for a solution on how we can search only a part of the email address and how can we make faster queries where the condition is...
by Marco Tusa | Apr 3, 2018 | Cloud, MySQL, ProxySQL
In this blog post, I’ll look at how you can use ProxySQL with AWS Aurora to further leverage database performance. My previous article described how easy is to replace the native Aurora connector with ProxySQL. In this article, you will see WHY you should do...
by Marco Tusa | Apr 3, 2018 | Cloud, Insight for DBAs, MySQL
In this post, we’ll look at how to implement ProxySQL with AWS Aurora. Recently, there have been a few discussions and customer requests that focused on AWS Aurora and how to make the various architectures and solutions more flexible. Flexible how, you may ask?...
by Tibor Korocz | Apr 2, 2018 | Insight for DBAs, Insight for Developers, Monitoring, MySQL, Percona Software
In this blog post, we’ll show that you can plot MySQL data in real time using Percona Monitoring and Management (PMM). In my previous blog post, I showed how we could load into any metrics, benchmarks into MySQL and visualize it with PMM. But that’s not...
by Daniel Kowalewski | Apr 2, 2018 | Cloud, Insight for DBAs, MySQL
In this blog post, we’ll look at how to migrate to Amazon RDS using Percona XtraBackup. Until recently, there was only one way to migrate your data from an existing MySQL instance into a new RDS MySQL instance: take and restore a logical backup with mysqldump or...
by Corrado Pandiani | Apr 2, 2018 | Insight for DBAs, Insight for Developers, MongoDB, Security
In this post, we’ll look at MongoDB data at rest encryption using eCryptFS, and how to deploy a MongoDB server using encrypted data files. When dealing with data, a good security policy should enforce the use of “no trivial” passwords, the use of...
by Bradley Mickel | Mar 30, 2018 | Insight for DBAs, MySQL
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...
by Tim Vaillancourt | Mar 30, 2018 | Insight for DBAs, Insight for Developers, 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...
by Dmitriy Kostiuk | Mar 30, 2018 | MySQL, Percona Events, Percona Software
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,...
by Vadim Tkachenko | Mar 29, 2018 | Monitoring, MySQL
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...
by Corrado Pandiani | Mar 29, 2018 | MySQL, ProxySQL
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....
by Dave Avery | Mar 28, 2018 | Insight for DBAs, Percona Live
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...
by Vadim Tkachenko | Mar 28, 2018 | Cloud, Insight for DBAs, Percona Software
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...
by Vinicius Grippa | Mar 28, 2018 | Insight for DBAs, Monitoring, MySQL
In this blog post, we’ll discuss some of the options available when purging binary logs. We’ll look at how to safely purge them when you have slaves in your topology and want to avoid deleting any binary log that still needs to be applied. Safely Purging Binary...
by Sveta Smirnova | Mar 27, 2018 | Insight for DBAs, Insight for Developers, MySQL, Webinars
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...
