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 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 Sveta Smirnova | Feb 28, 2018 | Insight for DBAs, MySQL, Webinars
Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents Performance Schema for MySQL Troubleshooting on Thursday, March 1, 2018, at 10:00 am PST (UTC-8) / 1:00 pm EST (UTC-5). Register Now Performance Schema, first introduced in version 5.5,...
by Peter Zaitsev | Feb 28, 2018 | Insight for DBAs, Monitoring, MySQL
In this blog post, I’ll look at how you can analyze raw MySQL query logs with ClickHouse. For typical query performance analyses, we have an excellent tool in Percona Monitoring and Management. You may want to go deeper, though. You might be longing for the...
by Borys Belinsky | Feb 27, 2018 | MySQL, Percona Events, Percona Software
The latest release of Percona Monitoring and Management (PMM) 1.8.0 is available as of February 27, 2018. 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...
by Dave Avery | Feb 21, 2018 | Cloud, MariaDB, MongoDB, MySQL, Percona Live
The conference session schedule for the seventh annual Percona Live 2018 Open Source Database Conference, taking place April 23-25 at the Santa Clara Convention Center in Santa Clara, CA is now live and available for review! Advance Registration Discounts can be...
by Peter Zaitsev | Feb 14, 2018 | MySQL
In this blog post, we’ll review additional Amazon Aurora MySQL monitoring capabilities we’ve added in Percona Monitoring and Management (PMM) 1.7.0. You can see them in action in the MySQL Amazon Aurora Metrics dashboard. Amazon Aurora MySQL Transaction...
by Dave Avery | Feb 8, 2018 | Cloud, Insight for DBAs, Insight for Developers, MariaDB, MongoDB, MySQL, Percona Live
Percona has revealed the line-up of in-depth tutorials for the Percona Live 2018 Open Source Database Conference, taking place April 23-25, 2018 at the Santa Clara Convention Center in Santa Clara, Calif. Secure your spot now with Advanced Registration prices...
by Ananias Tsalouchidis | Feb 7, 2018 | Insight for DBAs, MySQL, ProxySQL
In this blog post, I’ll present the ProxySQL query cache functionality. This is a query caching mechanism on top of ProxySQL. As there are already many how-tos regarding the ProxySQL prerequisites and installation process, we are going to skip these steps. For...
by Michael Coburn | Feb 6, 2018 | Monitoring, MySQL, Open Source, Percona Software
In this blog post, we’ll introduce how you can look at some experimental Percona Monitoring and Management (PMM) features using Percona Labs builds on GitHub. Note: PerconaLabs and Percona-QA are open source GitHub repositories for unofficial scripts and tools...
by Peter Zaitsev | Feb 5, 2018 | Insight for DBAs, MySQL
In this blog post, I’ll look into four ways MySQL executes GROUP BY. In my previous blog post, we learned that indexes or other means of finding data might not be the most expensive part of query execution. For example, MySQL GROUP BY could potentially be...
by Alexander Rubin | Jan 29, 2018 | Insight for DBAs, MySQL
In this blog post, we’ll look at ways you can use MySQL 5.7 generated columns (or virtual columns) to improve query performance. Introduction About two years ago I published a blog post about Generated (Virtual) Columns in MySQL 5.7. Since then, it’s been...
by Jervin Real | Jan 16, 2018 | Insight for DBAs, MySQL
In this post, we’ll look at updating and deleting rows with ClickHouse. It’s the second of two parts. In the first part of this post, we described the high-level overview of implementing incremental refresh on a ClickHouse table as an alternative support...
by Jervin Real | Jan 9, 2018 | Insight for DBAs, MySQL
In this post, we’ll look at updating and deleting rows with ClickHouse. It’s the first of two parts. You can see Part 2 of this post here. ClickHouse is fast Blazing fast! It’s quite easy to pick up, and with ProxySQL integrating with existing...
by Peter Zaitsev | Jan 9, 2018 | Insight for DBAs, Insight for Developers, MySQL, Webinars
Join Percona’s, CEO and Co-Founder, Peter Zaitsev as he presents Why We’re Excited About MySQL 8.0 on Wednesday, January 10, 2018, at 11:00 am PST / 2:00 pm EST (UTC-8). Experience: Basic Tags: Developer, DBAs, Operations, Executive, MySQL There are many great...
by Peter Zaitsev | Jan 8, 2018 | Insight for DBAs, MySQL
In this blog post, we’ll look at how ioping can be used with other tools to understand and troubleshoot storage performance, specifically as it relates to MySQL workloads. I recently ran into ioping, a nice little utility by Konstantin Khlebnikov that checks storage...
by Peter Zaitsev | Jan 5, 2018 | MySQL, Webinars
Thank you for attending my webinar on Wednesday, December 20, 2017, InnoDB Performance Optimization. In this blog, I will provide answers to the Q & A for the webinar. Are the T2 CPUs similar to the M4 series? I would expect them to be similar. Amazon does not...
by Colin Charles | Dec 22, 2017 | MySQL
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. I think the biggest news from last week was from cPanel – if you haven’t already read the post, please do – on Being a...
by Dave Avery | Dec 14, 2017 | Cloud, MariaDB, MongoDB, MySQL
Fill out a quick survey on your cloud database plans. Today, keeping your enterprise agile and flexible is not just an advantage, it is a requirement. Many of the systems and processes once controlled by businesses onsite are moving offsite to “service” models. This...
by Colin Charles | Dec 11, 2017 | Insight for DBAs, MariaDB, MongoDB, MySQL, Webinars
Join Percona’s Chief Evangelist, Colin Charles as he presents 2017 Year in Review for Open Source Database Software on Wednesday, December 13, 2017 at 7:00 am PST / 10:00 am EST (UTC-8). Register Here 2017 is soon coming to an end, and it’s good to pause and...
