by Jervin Real | Aug 11, 2017 | MySQL
In this post I’ll answer questions I received in my Wednesday, July 19, 2017, webinar Learning MySQL 5.7! First, thank you all who attended the webinar. The link to the slides and the webinar recording can be found here. I received a number of interesting...
by Colin Charles | Aug 10, 2017 | MariaDB, MongoDB, MySQL, Percona Events
Welcome to a new weekly column on the Percona blog. My name is Colin Charles, Percona Chief Evangelist, and I have been involved in MySQL, MariaDB Server and the open source community for over a decade. Now I am at Percona, and this is my weekly column. When you start...
by Peter Zaitsev | Aug 4, 2017 | MariaDB, MongoDB, MySQL, Percona Software
One of the new graphs added to Percona Monitoring and Management (PMM) is saturation metrics. This blog post explains how to use the information provided by these graphs. You might have heard about Brendan Gregg’s USE Method (Utilization-Saturation-Errors) as a way...
by Dave Avery | Aug 3, 2017 | Insight for DBAs, Insight for Developers, MariaDB, MongoDB, MySQL, Percona Live
We are excited to announce that the sneak peek schedule for the Percona Live Open Source Database Conference Europe 2017 is up! The Percona Live Open Source Database Conference Europe 2017 is September 25 – 27, at the Radisson Blu Royal Hotel. The theme of Percona...
by Alexey Zhebel | Aug 2, 2017 | MongoDB, MySQL, Percona Events, Percona Software
Percona announces the release of Percona Toolkit 3.0.4 on August 2, 2017. Percona Toolkit is a collection of advanced command-line tools that perform a variety of MySQL and MongoDB server and system tasks too difficult or complex for DBAs to perform manually. Percona...
by Borys Belinsky | Aug 1, 2017 | MySQL, Percona Events
Percona is glad to announce the release of Percona Server for MySQL 5.6.36-82.1 on August 1, 2017 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.6.36, including all the bug fixes in it, Percona Server for MySQL 5.6.34-79.1...
by Dave Avery | Jul 31, 2017 | MySQL, Security, Webinars
Join Percona’s, Senior Architect, Matthew Boehm as he presents MySQL Disk Encryption with LUKS on Wednesday, August 2, 2017, at 1:00 pm PDT / 4:00 pm EDT (UTC-7). Register Now Clients require strong security measures for PCI, HIPAA or PHI. You must encrypt MySQL...
by Borys Belinsky | Jul 28, 2017 | MySQL, Percona Events
Percona is glad to announce the GA release of Percona Server for MySQL 5.7.18-16 on July 28, 2017 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.7.18, including all the bug fixes in it, Percona Server for MySQL 5.7.18-16 is...
by Dave Avery | Jul 25, 2017 | Insight for DBAs, MySQL, Webinars
Join Percona’s, Architect, Manjot Singh as he presents Database Backup and Recovery Best Practices (with a Focus on MySQL) on Thursday, July 27, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7). Register Now In the case of a failure, do you know how long it will take to...
by Manjot Singh | Jul 20, 2017 | Insight for DBAs, ProxySQL
In this blog post, we’ll look at how to deploy ProxySQL. ProxySQL is a high-performance proxy, currently for MySQL and its forks (like Percona Server for MySQL and MariaDB). It acts as an intermediary for client requests seeking resources from the database. It...
by Dave Avery | Jul 19, 2017 | MariaDB, MongoDB, MySQL
In this post, we’ll use a blog poll to find out what operating system you use to run your development database servers. In our last blog poll, we looked at what OS you use for your production database. Now we would like to see what you use for your development...
by Juan Arruti | Jul 19, 2017 | Insight for DBAs, MySQL
In this blog post, I’ll talk about multi-threaded slave statistics printed in MySQL error log file. MySQL version 5.6 and later allows you to execute replicated events using parallel threads. This feature is called Multi-Threaded Slave (MTS), and to enable it...
by Manjot Singh | Jul 18, 2017 | Insight for DBAs, MySQL, Percona Services
In this post, we’ll look at strategies for backups and disaster recovery. Note: I am giving a talk on Backups and Disaster Recovery Best Practices on July 27th. Register Now When discussing disaster recovery, it’s important to take your business’...
by Dave Avery | Jul 17, 2017 | MariaDB, MongoDB, MySQL, Percona Events, Percona Live
We are extending the Percona Live Open Source Database Conference Europe 2017 call for papers deadline to Monday, July 24, 2017. Get your submissions in now! Between our Conference Committee working hard to review all the outstanding talk ideas, and the many community...
by Alexey Zhebel | Jul 14, 2017 | Insight for DBAs, MariaDB, MongoDB, Monitoring, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona Monitoring and Management 1.2.0 on July 14, 2017. For installation instructions, see the Deployment Guide. Changes in PMM Server PMM Server 1.2.0 introduced the following changes: Updated Components Consul 0.8.5 Grafana 4.3.2...
by Jervin Real | Jul 14, 2017 | Insight for DBAs, MySQL
In this blog post, I’ll look at a trick we use at Percona when upgrading to MySQL 5.7. I covered this subject (and others) in my webinar Learning MySQL 5.7 on Wednesday, July 19, 2017. On Upgrading to MySQL 5.7 We’ve been doing upgrades for quite a while...
by Peter Zaitsev | Jul 12, 2017 | Benchmarks, Insight for DBAs, MySQL
In this blog post, I will run a gh-ost benchmark against the performance of pt-online-schema-change. When gh-ost came out, I was very excited. As MySQL ROW replication became commonplace, you could use it to track changes instead of triggers. This practice is cleaner...
by Alex Poritskiy | Jul 11, 2017 | MySQL, Open Source, Percona Software
In this blog post, we’ll look at how using thread_statistics can cause high memory usage. I was recently working on a high memory usage issue for one of our clients, and made some interesting discoveries: high memory usage with no bounds. It was really tricky to...
by Emily Ikuta | Jul 10, 2017 | Insight for DBAs, MariaDB, MySQL, Security, Webinars
Join Percona’s Chief Evangelist, Colin Charles as he presents Securing Your MySQL/MariaDB Data on Tuesday, July 11, 2017 at 7:00 am PDT / 10:00 am EDT (UTC-7). Register Now This webinar will discuss the features of MySQL/MariaDB that when enabled and used improve the...
by Krunal Bauskar | Jul 5, 2017 | Insight for DBAs, MySQL, Percona Software
In this blog, we’ll look at the differences in how a PREPARE statement handles errors in binary and text protocols. Introduction Since Percona XtraDB Cluster is a multi-master solution, when an application executes conflicting workloads one of the workloads gets...
