by Yves Trudeau | Dec 7, 2017 | Hardware and Storage, Insight for DBAs, MySQL, Percona Software
This post is a hands-on look at ZFS with MySQL. In my previous post, I highlighted the similarities between MySQL and ZFS. Before going any further, I’d like you to be able to play and experiment with ZFS. This post shows you how to configure ZFS with MySQL in a...
by Krunal Bauskar | Dec 6, 2017 | Insight for DBAs, MySQL, Webinars
Join Percona’s Software Engineer (PXC Lead), Krunal Bauskar as he presents Percona XtraDB Cluster 101 on Thursday, December 7, 2017, at 7:00 am PST / 10:00 am EST (UTC-8). Tags: Percona XtraDB Cluster, MySQL, High Availability, Clustering Experience Level: Beginner...
by Vadim Tkachenko | Dec 5, 2017 | Insight for DBAs, MySQL
In this post, we’ll briefly look at window functions in MySQL 8.0. One of the major features coming to MySQL 8.0 is the support of Window functions. The detailed documentation is already available here Window functions. I wanted to take a quick look at the cases...
by Michael Coburn | Dec 1, 2017 | MongoDB, Monitoring, MySQL, Percona Software
In this post, we’ll examine how we’ve improved the GUI layout for Percona Monitoring and Management 1.5 by moving the Query Analytics (QAN) functions into the Grafana interface. For Percona Monitoring and Management users, you might notice that QAN appears...
by Borys Belinsky | Nov 29, 2017 | MongoDB, MySQL, Open Source, Percona Events, Percona Software
Percona announces the release of Percona Monitoring and Management 1.5.1. This release contains fixes for bugs found after Percona Monitoring and Management 1.5.0 was released. Bug fixes PMM-1771: When upgrading PMM to 1.5.0 using Docker commands, PMM System...
by Borys Belinsky | Nov 28, 2017 | MongoDB, MySQL, Open Source, Percona Events, Percona Software
Percona announces the release of Percona Monitoring and Management 1.5.0 on November 28, 2017. This release focuses on the following features: Enhanced support for MySQL on Amazon RDS and Amazon Aurora – Dedicated Amazon Aurora dashboard offers maximum visibility into...
by Colin Charles | Nov 22, 2017 | Insight for DBAs, MariaDB, MySQL
In this blog post, we’ll look at a solving Sudoku using MySQL 8.0 recursive common table expression. Vadim was recently having a little Saturday morning fun solving Sudoku using MySQL 8. The whole idea comes from SQLite, where Richard Hipp has come up with some...
by Colin Charles | Nov 13, 2017 | Cloud, Insight for DBAs, MariaDB, MongoDB, MySQL, Percona Live, PostgreSQL
Announcing the opening of the Percona Live Open Source Database Conference 2018 in Santa Clara, CA, call for papers. It will be open from now until December 22, 2017. Our theme is “Championing Open Source Databases,” with topics of MySQL, MongoDB and other open...
by Peter Zaitsev | Nov 9, 2017 | MySQL
In this blog post, I’ll look at MySQL and Linux context switches and what is the normal number per second for a database environment. You might have heard many times about the importance of looking at the number of context switches to indicate if MySQL is...
by Borys Belinsky | Nov 2, 2017 | MongoDB, MySQL, Open Source, Percona Events, Percona Software
Percona announces the release of Percona Monitoring and Management 1.4.1 on Thursday, November 2nd, 2017. This release contains fixes to bugs found after Percona Monitoring and Management 1.4.0 was released. It also introduces two important improvements. We replaced...
by Peter Zaitsev | Oct 31, 2017 | Monitoring, MySQL, Percona Software
In this blog post, I’ll walk through some of the improvements to the Percona Monitoring and Management (PMM) MySQL dashboard in release 1.4.0. As the part of Percona Monitoring and Management development, we’re constantly looking for better ways to visualize...
by Colin Charles | Oct 27, 2017 | MariaDB, MongoDB, MySQL, Percona Events
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. This week was exciting from a Percona exposure standpoint. We were at Open Source Summit Europe. I gave two talks and...
by Marcelo Altmann | Oct 23, 2017 | Insight for DBAs, MySQL
In this blog, I’ll look at how to do MySQL point in time recovery (PITR) correctly. Sometimes we need to restore from a backup, and then replay the transactions that happened after the backup was taken. This is a common procedure in most disaster recovery plans,...
by Borys Belinsky | Oct 20, 2017 | MongoDB, MySQL, Open Source, Percona Events, Percona Software
Percona announces the release of Percona Monitoring and Management 1.4.0. This release introduces the support of external Prometheus exporters so that you can create dashboards in the Metrics monitor even for the monitoring services other than those provided with PMM...
by Colin Charles | Oct 20, 2017 | Insight for DBAs, Insight for Developers, MariaDB, MongoDB, 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. I spent all of this week at O’Reilly Velocity EU London. I gave a tutorial, a talk and generally networked with...
by Tyler Duzan | Oct 19, 2017 | Cloud, Insight for DBAs, Insight for Developers, MongoDB, MySQL
Percona latest blog poll asks how you currently host applications and databases. Select an option below, or leave a comment to clarify your deployment! With the increased need for environments that respond more quickly to changing business demands, many enterprises...
by Peter Zaitsev | Oct 18, 2017 | Insight for DBAs, MySQL
In this blog post, I’ll provide some guidance on how to choose the MySQL innodb_log_file_size. Like many database management systems, MySQL uses logs to achieve data durability (when using the default InnoDB storage engine). This ensures that when a transaction...
by Matthew Boehm | Oct 18, 2017 | Insight for DBAs, MySQL, Open Source, Webinars
Join Percona’s Senior Architect, Matthew Boehm, as he presents What You Need to Get the Most Out of Indexes – Part 2 webinar on Thursday, October 19, 2017, at 11:00 am PDT / 2:00 pm EDT (UTC-7). Register Now Proper indexing is key to database performance. Finely tune...
by Colin Charles | Oct 13, 2017 | MariaDB, MongoDB, Open Source
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Beyond spending time getting ready for Velocity and Open Source Summit Europe this week, there was some feature testing this...
by Sveta Smirnova | Oct 12, 2017 | Insight for DBAs, MySQL, Percona Software
