by Sveta Smirnova | Mar 14, 2018 | MySQL, Webinars
In this blog, I will provide answers to the Q & A for the Basic Internal Troubleshooting Tools for MySQL Server webinar. First, I want to thank everybody for attending my February 15, 2018, webinar on troubleshooting tools for MySQL. The recording and slides for...
by Matt Yonkovit | Mar 13, 2018 | Insight for DBAs, Percona Live, Security
In this post, we discuss database security compliance, what you should be looking at and where to get more information. As Percona’s Chief Customer Officer, I get the opportunity to talk with a lot of customers. Hearing about the problems that both their technical...
by Sveta Smirnova | Mar 13, 2018 | Monitoring, MySQL, Percona Software, Webinars
Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents Basic External MySQL Troubleshooting Tools on March 15, 2018 at 10:00 am PDT (UTC-7) / 1:00 pm EDT (UTC-4). In my troubleshooting webinar series, I normally like to discuss built-in...
by Ananias Tsalouchidis | Mar 13, 2018 | Insight for DBAs, MySQL
In this blog post, we’ll look at how to navigate some of the complexities of multi-source GTID replication. GTID replication is often a real challenge for DBAs, especially if this has to do with multi-source GTID replication. A while back, I came across a really...
by Dmitriy Kostiuk | Mar 12, 2018 | Percona Software, ProxySQL
ProxySQL 1.4.6, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Percona’s proxysql-admin tool. ProxySQL is a high-performance proxy, currently for MySQL and its forks (like Percona Server for MySQL...
by David Murphy | Mar 12, 2018 | Insight for DBAs, MongoDB, Percona Software
In this blog post, we’re going to look at how to upgrade MongoDB when leaping versions. Here at Percona, we see every type of upgrade you could imagine. Lately, however, I see an increase very old version upgrades (OVE). This is when you upgrade MongoDB from a...
by Colin Charles | Mar 9, 2018 | Monitoring, MySQL, Percona Live, Security
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Have you been following the Meltdown/Spectre performance regressions? Some of the best blog posts have been coming from...
by Tim Vaillancourt | Mar 9, 2018 | Insight for Developers, MongoDB, Percona Software
In this blog, we will discuss the MongoDB 3.6 expression query operator $expr. To show the power of this functionality, I will demonstrate the use of this feature with a simple example. The $expr Query Operator With the exception of a few basic operators ($and, $or,...
by Alkin Tezuysal | Mar 9, 2018 | Benchmarks, MySQL, ProxySQL
In this blog post, I’ll be looking at a new tool Proxytop for managing MySQL topologies using ProxySQL. Proxytop is a self-contained, real-time monitoring tool for ProxySQL. As some of you already know ProxySQL is a popular open source, high performance and...
by Robert Golebiowski | Mar 8, 2018 | Insight for DBAs, Monitoring, MySQL, Percona Software, Security
In this blog post, we’ll look at how to turn on binlog encryption in Percona Server for MySQL. Why do I need this? As you probably know, Percona Server for MySQL’s binlog contains sensitive information. Replication uses the binlog to copy events between...
by Alok Pathak | Mar 8, 2018 | Cloud, MySQL, Percona Software
In this blog post, we’ll look at what is needed when migrating MySQL users to Amazon RDS. We’ll discuss how we can transform MySQL user grants and make them compatible with Amazon RDS. In order to deliver a managed service experience, Amazon RDS does not provide...
by Tim Vaillancourt | Mar 7, 2018 | Insight for DBAs, Insight for Developers, MongoDB
In this blog post, we will explore MongoDB 3.6 change streams – a powerful new feature that added in the latest version of MongoDB. Streaming data workflows are becoming increasingly popular in open-source due to their ability to allow efficient, asynchronous,...
by Dave Avery | Mar 7, 2018 | Percona Live, PostgreSQL, Security
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 Jericho Rivera | Mar 6, 2018 | MySQL, Security
Security is one of the hottest topics lately, and in this blog post, I will walk you through what needs to be configured to have a working three-node Percona XtraDB Cluster running with InnoDB Tablespace Encryption enabled. This article will not cover the basics of...
by Borys Belinsky | Mar 6, 2018 | MongoDB, MySQL, Percona Events, Percona Software
Percona announces the release of Percona Monitoring and Management 1.8.1. PMM (Percona Monitoring and Management) 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...
by Tim Sharp | Mar 6, 2018 | Insight for DBAs, Monitoring, MySQL
Please join Percona Technical Account Manager Tim Sharp, as he presents How Percona Maintains Optimal Customer Health on Thursday, March 8, 2018 at 11:00 am PST (UTC -8) / 2:00 pm EST (UTC -5). Register Now How do you guarantee optimal database performance for...
by Vadim Tkachenko | Mar 5, 2018 | Benchmarks, Insight for DBAs, MySQL
In this post I’ll look at some of our recent work for benchmark enthusiasts: a TPCC-like workload for Sysbench (version 1.0 or later). Despite being 25 years old, the TPC-C benchmark can still provide an interesting intensive workload for a database in my...
by Hrvoje Matijakovic | Mar 5, 2018 | Percona Events, Percona Software
Percona announces the release of Percona Server for MongoDB 3.4.13-2.11 on March 5, 2018. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB 3.4 is an enhanced, open source, and highly-scalable...
by Peter Zaitsev | Mar 5, 2018 | MongoDB, MySQL, Percona Software, Webinars
Come and listen to Percona CEO Peter Zaitsev on March 6, 2018 at 12:00 pm PST (UTC -8) / 3:00 pm EST (UTC -5) as Peter discusses Percona software news and what’s new in Percona open source software, including Percona Server for MySQL and MongoDB, Percona XtraDB...
by Dmitriy Kostiuk | Mar 2, 2018 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona XtraDB Cluster 5.7.21-29.26 (PXC) on March 2, 2018. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.7.21-29.26 is now the current release, based on the following: Percona...
