by Hrvoje Matijakovic | Nov 18, 2016 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server 5.5.53-38.4 on November 18, 2016. Based on MySQL 5.5.53, including all the bug fixes in it, Percona Server 5.5.53-38.4 is now the current stable release in the 5.5 series. Percona Server is open-source and free. You can...
by Peter Zaitsev | Nov 17, 2016 | MongoDB, MySQL, Percona Events
Let us know what you think about Percona, and what we should be thinking about for the future. Over the last ten years, Percona has grown considerably. We’ve moved from being a strictly MySQL company, to a company that supports MongoDB and other open source...
by Jon Tobin | Nov 16, 2016 | Cloud, MongoDB, MySQL
This blog post reviews the appropriateness of Docker and other container solutions for your database environment. A few weeks back, I wrote a fairly high-level blog post about containers. It covered what you should consider when thinking about using Docker, rkt, LXC,...
by Alexey Zhebel | Nov 15, 2016 | MongoDB, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona Monitoring and Management 1.0.6 on November 15, 2016. PMM Server is distributed through Docker Hub PMM Client packages are available on the download page The instructions for installing or upgrading Percona Monitoring and...
by Ceri Williams | Nov 14, 2016 | Insight for DBAs, Insight for Developers, MySQL, Security
Using Vault with MySQL In my previous post I discussed using GPG to secure your database credentials. This relies on a local copy of your MySQL client config, but what if you want to keep the credentials stored safely along with other super secret information? Sure,...
by Barrett Chambers | Nov 14, 2016 | MongoDB, MySQL
This blog post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user. Delving into NoSQL coming from an exclusively SQL background can seem like a daunting task. I have worked with SQL...
by Tibor Korocz | Nov 11, 2016 | MySQL
by Wagner Bianchi | Nov 10, 2016 | Insight for DBAs, MySQL, Percona Services
This post discusses ways of fixing broken GTID replication. This blog series is all about the daily stories we have in Managed Services, dealing with customers’ environments (mostly when we need to quickly restore a service level within the SLA time). One of the...
by Tibor Korocz | Nov 9, 2016 | Insight for DBAs, MySQL, ProxySQL
In this blog post, I am going to show you how can you use Orchestrator and ProxySQL together. In my previous blog post, I showed how to use bash scripts and move virtual IPs with Orchestrator. As in that post, I assume you already have Orchestrator working. If not,...
by Marcelo Altmann | Nov 8, 2016 | MySQL
In this blog post, we will discuss how we can verify if an application transaction executed on the master has been applied to the slaves. In summary, is a good practice to alleviate the load on the master by doing reads on slaves. It is acceptable in most of the cases...
by Kortney Runyan | Nov 8, 2016 | MariaDB, MongoDB, MySQL, Percona Live
We’ve extended the Percona Live Open Source Database Conference 2017 call for papers deadline until November 13th! If you haven’t submitted already, please consider doing so. Speaking at Percona Live is a great way to build your personal and company brands, and...
by Daniel Guzmán Burgos | Nov 4, 2016 | MySQL, Percona Software
In this blog, we’ll discuss changing the tablespace directory using pt-online-schema-change. One of the most annoying situations in the life of a DBA is realizing that the disk where the datadir resides is running out of space. If you’re lucky enough to...
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 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 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 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 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 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...
