by Adamo Tonete | Mar 2, 2018 | Insight for DBAs, MongoDB, Monitoring, Percona Software
In this blog post, we will discuss how to use Percona Monitoring and Management for MongoDB monitoring, and how to get some key graphs to monitor your MongoDB database. All production environments need metrics and historical data for easy and fast comparison of...
by Colin Charles | Mar 2, 2018 | Insight for DBAs, MariaDB, MySQL, Percona Events, Percona Software
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Have you registered for Percona Live already? The tutorial grid, the schedules for day 1 and day 2 are pretty amazing, and...
by Tate McDaniel | Mar 1, 2018 | Monitoring, MySQL, Percona Software
by Borys Belinsky | Mar 1, 2018 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Toolkit 3.0.7 on March 1, 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 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 Tibor Korocz | Feb 28, 2018 | Monitoring, MySQL, Percona Software
In this blog post, we’ll checkout Percona Monitoring and Management vs. gnuplot when it comes to creating great metrics graphs. gnuplot is great, but PMM might provide graphs that are easier to read. Percona Monitoring and Management (PMM) is our free and...
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 27, 2018 | Insight for DBAs, Percona Live
Welcome to the first interview blog for the upcoming Percona Live 2018. Each post in this series highlights a Percona Live 2018 featured talk that will be at the conference and gives a short preview of what attendees can expect to learn from the presenter.This blog...
by Tibor Korocz | Feb 27, 2018 | Insight for DBAs, MySQL, ProxySQL
In this blog post, I’ll look at how to catch slow and frequent queries with ProxySQL. More and more people are using ProxySQL because it is a great tool and it can help DBAs a lot. But many people do not realize that it is more powerful than it looks. It has...
by Marcelo Altmann | Feb 26, 2018 | Insight for DBAs, MySQL
In this blog post, I’ll look at how to execute a MySQL single table Point-In-Time Recovery. I recently wrote a blog post describing a different way of doing Point-In-Time Recovery (PITR). If you want to know the step by step, please visit the mentioned blog...
by Dmitriy Kostiuk | Feb 26, 2018 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona XtraDB Cluster 5.6.39-26.25 (PXC) on February 26, 2018. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.6.39-26.25 is now the current release, based on the following:...
by Mykola Marzhan | Feb 23, 2018 | Cloud, MariaDB, Monitoring, MySQL, Percona Software
Please join Percona’s Build / Release Engineer, Mykola Marzhan, as he presents Monitoring Amazon RDS with Percona Monitoring and Management on February 27, 2018, at 7:00 am PST (UTC-8) / 10:00 am EST (UTC-5). Register Now Are you concerned about how you are monitoring...
by Colin Charles | Feb 23, 2018 | MariaDB, MongoDB, Percona Events, Percona Live, Percona Software, PostgreSQL
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 Percona-land is that besides the tutorial grid, the schedule for day 1 and day 2 are live!...
by Nickolay Ihalainen | Feb 22, 2018 | Hardware and Storage, Insight for DBAs, Monitoring, MySQL
The ability to restore MySQL logical backups is a significant part of disaster recovery procedures. It’s a last line of defense. Even if you lost all data from a production server, physical backups (data files snapshot created with an offline copy or with...
by Dave Avery | Feb 22, 2018 | Insight for DBAs, Insight for Developers, MySQL, Percona Live
Welcome to the first interview blog for the upcoming Percona Live 2018. Each post in this series highlights a Percona Live 2018 featured talk that will be at the conference and gives a short preview of what attendees can expect to learn from the presenter. This blog...
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 20, 2018 | Monitoring, MySQL, Percona Software
In this blog post, I will look at the new dashboards in Percona Monitoring and Management (PMM) for Prometheus exporters. Percona Monitoring and Management (PMM) uses Prometheus exporters to capture metrics data from the system it monitors. Those Prometheus exporters...
by Alexander Rubin | Feb 19, 2018 | Hardware and Storage, Insight for DBAs, MySQL
In this blog post, I will talk about archiving MySQL tables in ClickHouse for storage and analytics. Why Archive? Hard drives are cheap nowadays, but storing lots of data in MySQL is not practical and can cause all sorts of performance bottlenecks. To name just a few...
by Dmitriy Kostiuk | Feb 19, 2018 | MySQL, Percona Events, Percona Software, Storage Engine
Percona announces the GA release of Percona Server for MySQL 5.7.21-20 on February 19, 2018. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository....