by Tibor Korocz | Nov 3, 2016 | Insight for DBAs, MySQL
In this post, I’ll discuss how to moving VIPs during a failover using Orchestrator. In our previous post, we showed you how Orchestrator works. In this post, I am going to give you a proof-of-concept on how Orchestrator can move VIPs in case of failover. For...
by David Busby | Nov 2, 2016 | MySQL, Percona Events, Percona Software
Percona has addressed CVE-2016-6663 and CVE-2016-6664 in releases of Percona Server for MySQL and Percona XtraDB Cluster. Percona is happy to announce that the following vulnerabilities are fixed in current releases of Percona Server for MySQL and Percona XtraDB...
by Dave Avery | Nov 2, 2016 | MySQL
Join Percona’s Chief Evangelist Colin Charles on Thursday, November 3, 2016, at 10 am PDT/ 1:00pm EDT (UTC-7) as he presents “The MySQL Ecosystem in 2016.” MySQL is a unique adult (now 21 years old) in many ways. It supports plugins. It supports...
by Roel Van de Paar | Nov 1, 2016 | MongoDB, MySQL, Percona Software
This blog post discusses an information script for the Percona Monitoring and Management (PMM) tool. In recent news, we announced the fresh-of-the-press Percona Monitoring and Management (or PMM for short) platform. Given the interaction of the...
by Peter Zaitsev | Nov 1, 2016 | MySQL
In this blog post, I’ll discuss the future of TokuDB at Percona. Spoiler: solid. As soon as we announced the fact that MyRocks was coming to Percona Server for MySQL at Percona Live Europe, rumors appeared that this means we’re going to phase out TokuDB at the...
by Alexey Zhebel | Oct 31, 2016 | MongoDB, Percona Events, Percona Software
Percona announces the release of Percona Server for MongoDB 3.2.10-3.0 on October 31, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB 3.2.10-3.0 is an enhanced, open-source, fully compatible,...
by Dave Avery | Oct 31, 2016 | MongoDB, Webinars
Please join us on Wednesday, November 2, 2016 at 10:00 am PDT / 1:00pm EDT (UTC-7) for the webinar MongoDB Backups, All Grown Up, featuring David Murphy, Percona’s Mongo Practice Manager. It has been a long road to stable and dependable backups in the MongoDB...
by Dimitri Vanoverbeke | Oct 28, 2016 | MySQL
MySQL configuration management remains a hot topic, as I’ve noticed on numerous occasions during my conversations with customers. I thought it might be a good idea to start a blog series that goes deeper in detail into some of the different options, and what modules...
by George O. Lorch III | Oct 28, 2016 | MySQL
This blog post discusses a new TokuDB and PerconaFT database file management feature in two Percona Server releases. By now you have hopefully read through Peter’s post and my two prior posts on the TokuDB/PerconaFT file set. If you have not, it is probably a...
by Tibor Korocz | Oct 27, 2016 | MySQL
MySQL 8.0 has a new feature called “invisible indexes,” which allow you to quickly enable/disable indexes from being used by the MySQL Optimizer. I wanted to share some of my first experiences and thoughts about this new feature. Why is it good for us?...
by Dave Avery | Oct 26, 2016 | MariaDB, MongoDB, MySQL
Take Percona’s poll on what database technologies you use in your environment. Different databases get designed for different scenarios. Using one database technology for every situation doesn’t make sense, and can lead to non-optimal solutions for common...
by Kortney Runyan | Oct 26, 2016 | MongoDB, MySQL, Percona Live
The Percona Live Open Source Database Conference 2017 call for papers is closing soon! Get in your submissions ASAP! After this past sold-out Percona Live Europe in Amsterdam, we’ve decided that expansion definitely works! The diverse list of topics at the...
by Roman Vynar | Oct 25, 2016 | Cloud, Insight for DBAs, Percona Software
This article describes how to visualize and monitor OS metrics for Amazon RDS instances using Grafana. We use CloudWatch as a data source, and Grafana to query CloudWatch API in real-time to get data. The setup instructions include just four quick steps (assuming you...
by George O. Lorch III | Oct 24, 2016 | MySQL
This is the second installment of the blog series on TokuDB and PerconaFT data files. You can find my previous post here. In this post we will discuss some common file maintenance operations and how to safely execute these operations. Moving TokuDB data (table/index)...
by Peter Zaitsev | Oct 24, 2016 | MySQL, Percona Software
Announcing MyRocks in Percona Server for MySQL. RocksDB has been taking the world by the storm! RocksDB counts Facebook, LinkedIn, Pinterest, Airbnb and Netflix among its users. It is the storage engine for many open source database technologies, including...
by David Ducos | Oct 21, 2016 | MySQL, Percona Software
In this blog post, we’ll look at how replication triggers a Performance Schema issue on Percona XtraDB Cluster. During an upgrade to Percona XtraDB Cluster 5.6, I faced an issue that I wanted to share. In this environment, we set up three Percona XtraDB Cluster...
by Peter Zaitsev | Oct 21, 2016 | MongoDB, MySQL, Percona Events
As noted in several media outlets, many web sites have been affected by a DDoS attack on Dyn today. Since Percona uses Dyn for its DNS server, we are experiencing issues as well. The attack has impacted the percona.com web site availability and performance,...
by Hrvoje Matijakovic | Oct 21, 2016 | MySQL, Percona Events, Percona Software
Percona announces the GA release of Percona Server 5.7.15-9 on October 21, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.7.15, including all the bug fixes in it, Percona Server 5.7.15-9 is the...
by Alexander Rubin | Oct 20, 2016 | MySQL
In this blog, we’ll discuss descending indexes in MySQL 8.0. Summary The future MySQL 8.0 will (probably) have a great new feature: support for index sort order on disk (i.e., indexes can be physically sorted in descending order). In the MySQL 8.0 Labs release...
by Peter Zaitsev | Oct 19, 2016 | MongoDB, Monitoring, MySQL, Percona Software
As part of the release of Percona Monitoring and Management, we set up an extensive online Percona Monitoring and Management demo at pmmdemo.percona.com. The demo is pretty self-explanatory and easy to explore, but you will probably find it a lot more interesting with...