by Corrado Pandiani | May 23, 2018 | Insight for DBAs, Insight for Developers, MongoDB, Security
by Michael Coburn | May 22, 2018 | MariaDB, MongoDB, MySQL, Percona Events, Percona Software
Percona announces the release of Percona Toolkit 3.0.10 on May 22, 2018. Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL®, MongoDB® and...
by Dmitriy Kostiuk | May 22, 2018 | Percona Software, ProxySQL
ProxySQL 1.4.8, 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 Adamo Tonete | May 22, 2018 | Insight for DBAs, Insight for Developers, MongoDB, Percona Software, Webinars
Please join Percona’s Senior Support Engineer, Adamo Tonete as he presents What’s New in MongoDB 3.6 on Thursday, May 24th, 2018, at 12:30 PM PDT (UTC-7) / 3:30 PM EDT (UTC-4). In this webinar, Adamo will walk though what’s new in MongoDB 3.6, including: Change...
by Dmitriy Kostiuk | May 21, 2018 | MongoDB, Percona Events, Percona Software
Percona announces the release of Percona Server for MongoDB 3.2.20-3.11 on May 21, 2018. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB is an enhanced, open source, and highly-scalable database...
by Sveta Smirnova | May 21, 2018 | Insight for DBAs, Insight for Developers, MySQL, Webinars
Please join Percona’s Principal Support Escalation Specialist, Sveta Smirnova, as she presents Troubleshooting MySQL Concurrency Issues with Load Testing Tools on Wednesday, May 23, 2018 at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Register Now ...
by Peter Zaitsev | May 21, 2018 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
In this blog post, I will show you how to use Percona Monitoring and Management (PMM) to capture per-process metrics in five minutes or less. While Percona Monitoring and Management (PMM) captures a lot of host metrics, it currently falls short providing per-process...
by Dmitriy Kostiuk | May 18, 2018 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server for MySQL 5.5.60-38.12 on May 18, 2018. Based on MySQL 5.5.60, including all the bug fixes in it, Percona Server for MySQL 5.5.60-38.12 is now the current stable release in the 5.5 series. Percona Server for MySQL is...
by Corrado Pandiani | May 17, 2018 | Insight for DBAs, Insight for Developers, MongoDB, Security
In this article series, we will talk about the basic high availability architecture of a MongoDB: the MongoDB replica set. We’ll cover it in three parts: Part 1 (this post): We’ll introduce basic replica set concepts, how it works and what its main...
by Dov Endress | May 16, 2018 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
MySQL, coupled with the InnoDB engine, provides full ACID compliance. With the addition of “eXtended Architecture” (XA) technology, they can all act in a distributed atomic environment. In distributed systems, several different technologies, platforms and...
by Yves Trudeau | May 15, 2018 | MySQL
If you are a regular reader of this blog, you likely know I like the ZFS filesystem a lot. ZFS has many very interesting features, but I am a bit tired of hearing negative statements on ZFS performance. It feels a bit like people are telling me “Why do you use...
by Peter Zaitsev | May 14, 2018 | Insight for DBAs, MySQL
Do you want to install MySQL 8.0 on Ubuntu 16.04 LTS? In this quick tutorial, I show you exactly how to do it in five minutes or less. This tutorial assumes you don’t have MySQL or MariaDB installed. If you do, it’s necessary to uninstall them or follow a...
by Colin Charles | May 11, 2018 | Cloud, MySQL, Percona Events, Percona Live, Storage Engine
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. rootconf.in 2018 just ended, and it was very enjoyable to be in Bangalore for the conference. The audience was large, the...
by Jeff Sandstrom | May 10, 2018 | Insight for DBAs, Insight for Developers, MongoDB, Percona Software
In this blog post, we’ll look at why we deprecated MongoRocks in Percona Server for MongoDB 3.6, and provide some guidance on switching from MongoRocks to WiredTiger. On April 24, 2018, Percona announced the availability of Percona Server for MongoDB 3.6. If you...
by Tibor Korocz | May 9, 2018 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Yes, it does! In this blog post, I am going to share my recent experiences with ProxySQL and how important the database software version number can be. Migration I was working on a migration to Percona XtraDB Cluster (PXC) with ProxySQL, fortunately on a staging...
by Peter Zaitsev | May 8, 2018 | Cloud, MySQL, Open Source, Percona Software
In this blog, I will show you how to install PMM on Linode as a low-cost database monitoring solution. Many of my friends use Linode to run their personal sites, as well as small projects. While Linode is no match for Big Cloud providers in features, it is really...
by Janos Ruszo | May 8, 2018 | Cloud, Insight for DBAs
It’s easy to enable Amazon RDS remote access when launching an Amazon RDS instance, but there can be many issues. I created this blog as a guide describing the various issues/configurations we might encounter. Enable Amazon RDS Remote Access As the first step, we need...
by Peter Zaitsev | May 7, 2018 | Insight for DBAs, Percona Software, Webinars
Please join Percona’s CEO, Peter Zaitsev as he presents MySQL Troubleshooting and Performance Optimization with PMM on Wednesday, May 9, 2018, at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Optimizing MySQL performance and troubleshooting MySQL problems are two of the...
by Vadim Tkachenko | May 4, 2018 | Benchmarks, Insight for DBAs, MySQL
As part of my benchmarks of binary logs, I’ve decided to check how the recently released MySQL 8.0 performance is affected in similar scenarios, especially as binary logs are enabled by default. It is also interesting to check how MySQL 8.0 performs against the...
by Vadim Tkachenko | May 4, 2018 | Benchmarks, Insight for DBAs, MySQL
I want to take a closer look at MySQL performance with binary logs enabled on different filesystems, especially as MySQL 8.0 comes with binary logs enabled by default. As part of my benchmarks of the MyRocks storage engine, I’ve noticed an unusual variance in...