by Muhammad Irfan | Oct 18, 2016 | MySQL
In this blog, we’ll discuss things to watch out for during a MySQL downgrade. Previously, I wrote the blog MySQL upgrade best practices. Besides upgrading your MySQL version, sometimes you need to downgrade. When it comes to downgrading MySQL, there are two...
by Daniel Kowalewski | Oct 11, 2016 | MySQL
In this blog post, I’ll look at how to use the loose_ option prefix in my.cnf in MySQL. mysqld throws errors at startup – and refuses to start up – if a non-existent options are defined in the my.cnf file. For example: 2016-10-05 15:56:07 23864 [ERROR]...
by Dave Avery | Oct 10, 2016 | Cloud, Insight for DBAs, MariaDB, MongoDB, Monitoring, MySQL
Take Percona’s One-Click 2017 Top Database Concerns Poll. With 2017 coming quick around the corner, it’s time to start thinking about what next year is going to bring to the open source database community. We just finished Percona Live Europe 2017, and at the...
by Dave Avery | Oct 5, 2016 | MySQL, Percona Live
Hello again, from day two of the sold out Percona Live Europe Open Source Database Conference! There is still much excitement here at the conference, and today looks to be just as busy as yesterday. Day two of Percona Live Europe 2016 kicked off once again with a...
by Pablo Padua | Sep 27, 2016 | MySQL
This blog post will discuss how to use the MySQL super_read_only system variable. It is well known that replica servers in a master/slave configuration, to avoid breaking replication due to duplicate keys, missing rows or other similar issues, should not receive write...
by Kortney Runyan | Sep 22, 2016 | MySQL
The Call for Speakers for Percona Live Open Source Database Conference 2017 is open and accepting proposals through Oct. 31, 2016. The Percona Live Open Source Database Conference 2017 is the premier event for the diverse and active open source community, as well as...
by Miguel Angel Nieto | Sep 16, 2016 | Insight for DBAs, MySQL
In this blog post, we’ll look at what MySQL does under the hood to transform NoSQL requests to SQL (and then store them in InnoDB transactional engine) when using the X Plugin. X Plugin allows MySQL to function as a document store. We don’t need to define...
by Nik Vyzas | Sep 16, 2016 | MySQL
When it comes to “decision time” about which type of MySQL HA (high-availability) solution to implement, and how to architect the solution, many questions come to mind. The most important questions are: “What are the best tools to provide HA and Load...
by Bradley Mickel | Sep 14, 2016 | Insight for DBAs, MySQL
In this blog post, we’ll discuss the MySQL default configuration changes between 5.6 and 5.7. MySQL 5.7 has added a variety of new features that might excite you. However, there are also changes in the current variables that you might have overlooked. MySQL 5.7...
by Muhammad Irfan | Sep 14, 2016 | MySQL
Recently, I worked on a customer case where the customer needed to monitor the checksum via Nagios monitoring. The pmp-check-pt-table-checksum plugin from Percona Monitoring Plugins for MySQL achieves this goal. I thought it was worth a blogpost....
by Bob Davis | Sep 13, 2016 | MongoDB, MySQL, Percona Software
Percona announces the availability of Percona Monitoring and Management (PMM), an open source software database monitoring and management tool. Completely open source and free to download and use, Percona Monitoring and Management provides point-in-time visibility and...
by Kenny Gryp | Sep 12, 2016 | MySQL, Security
In this blog post, I will discuss the CVE-2016-6662 vulnerability, how to tell if it affects you, and how to prevent the vulnerability from affecting you if you have an older version of MySQL. I’ll also list which MySQL versions include the vulnerability fixes....
by Dave Avery | Sep 12, 2016 | MySQL, Percona Live
Welcome to another Percona Live Europe featured talk with Percona Live Europe 2016: Amsterdam speakers! In this series of blogs, we’ll highlight some of the speakers that will be at this year’s conference. We’ll also discuss the technologies and outlooks of the...
by Daniel Guzmán Burgos | Sep 9, 2016 | Insight for DBAs, MySQL
In this blog post, we’ll look at some of the basic housekeeping steps for MySQL indexes. We all know that indexes can be the difference between a high-performance database and a bad/slow/painful query ride. It’s a critical part that needs deserves some...
by Sveta Smirnova | Sep 8, 2016 | MySQL, Webinars
In this blog, I will provide answers to the Q & A for the MySQL Replication Troubleshooting webinar. First, I want to thank everybody for attending the August 25 webinar. Below is the list of your questions that I wasn’t able to answer during the webinar, with...
by Miguel Angel Nieto | Sep 2, 2016 | Insight for DBAs, MySQL
by Marco Tusa | Aug 30, 2016 | MySQL
This article demonstrates how MySQL sharding with ProxySQL works. Recently a colleague of mine asked me to provide a simple example on how ProxySQL performs sharding. In response, I’m writing this short tutorial in the hope it will illustrate ProxySQL’s...
by Peter Zaitsev | Aug 25, 2016 | MySQL
Introducing PostgreSQL Day at Percona Live Europe, Amsterdam 2016. As modern open source database deployments change, often including more than just a single open source database, Percona Live has also changed. We changed our model from being a purely MySQL-focused...
by Marco Tusa | Aug 23, 2016 | MySQL, ProxySQL
This blog discusses how to find and address badly written queries using ProxySQL. All of us are very good in writing good queries. We know this to always be true! 😉 But sometimes a bad query escapes our control and hits our database. There is the new guy, the probie,...
by Hrvoje Matijakovic | Aug 23, 2016 | MySQL, Percona Events, Percona Software
Percona announces the GA release of Percona Server 5.7.14-7 on August 23, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.7.14, including all the bug fixes in it, Percona Server 5.7.14-7 is the current...
