by Hrvoje Matijakovic | Nov 23, 2016 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server for MySQL 5.5.53-38.4 on November 23, 2016. Based on MySQL 5.5.53, including all the bug fixes in it, Percona Server for MySQL 5.5.53-38.5 is now the current stable release in the 5.5 series. Percona Server for MySQL is...
by Krunal Bauskar | Nov 22, 2016 | Insight for DBAs, MySQL, Percona Software
In this blog I will provide answers to the questions and queries that some of you have raised during the webinar on Nov 17th. I would like to say thank you to all of the audience who attended the talk on November 17, 2016. You can also check the recording and slides...
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 Sveta Smirnova | Nov 18, 2016 | MongoDB
In this blog, I will provide answers to the Q & A for the WiredTiger B-Tree versus WiredTiger In-Memory webinar. First, I want to thank everybody for attending the October, 13 webinar. The recording and slides for the webinar are available here. Below is the list...
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 Krunal Bauskar | Nov 16, 2016 | Insight for DBAs, MySQL, Percona Software
This blog discusses some important aspects of GCache. Why do we need GCache? Percona XtraDB Cluster is a multi-master topology, where a transaction executed on one node is replicated on another node(s) of the cluster. This transaction is then copied over from the...
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 Dave Avery | Nov 15, 2016 | Insight for DBAs, MySQL, Percona Software, Webinars
Join Percona’s Percona XtraDB Cluster Lead Software Engineer Krunal Bauskar for a webinar on Thursday, November 17, 2016, at 7:30 am PST on MySQL High Availability with Percona XtraDB Cluster 5.7. Percona XtraDB Cluster 5.7 is our brand new MySQL 5.7 compatible...
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 Rick Golba | Nov 11, 2016 | Cloud, MySQL
This blog post discusses the differences between the Amazon AWS service tiers. Many people want to move to an Amazon environment but are unsure what AWS service makes the most sense (EC2, RDS, Aurora). For database services, the tiering at Amazon starts with EC2, then...
by Tibor Korocz | Nov 11, 2016 | MySQL
by Shahriyar Rzayev | Nov 10, 2016 | Insight for DBAs
This blog discusses column compression with an optional predefined dictionary. Compression, more compression with different algorithms, compress again, compress multiple times! 🙂 Compression is a hot topic in our lives. In general, testing new things is great if the...
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 Wagner Bianchi | Nov 7, 2016 | Insight for DBAs, Percona Software
This blog describes how to upgrade Percona XtraDB Cluster in place from 5.6.24-72.2 to 5.6.32-25.17. This very hands-on blog is the result of some questions such as “can I perform an in-place upgrade for Percona XtraDB Cluster” coming in. We have done these minor...
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...