Percona has released a new Percona App for Grafana! Are you using Grafana 3.x with Prometheus’ time-series database? Now there is a “Percona App” available on Grafana.net! The app provides a set of dashboards for MySQL performance and system monitoring with Prometheus’ datasource, and make it easy for users install them. The dashboards rely on the alias label […]
Some time ago, I published the article on AWS Aurora Benchmarking (AWS Aurora Benchmarking – Blast or Splash?), in which I analyzed the behavior of different solutions using synchronous replication in AWS environment. This blog follows up with some of the comments and suggestions I received regarding that post from the community and Amazon engineers. […]
Introduction In this blog, we’ll review MongoDB 3.2 elections and how they work, as well as what is really new and different in the election protocol. MongoDB 3.2 revamped its election protocol for increased stability! Exciting times, with smarter and faster elections are here! With this latest release, you will find that replication (and the […]
Percona is glad to announce the release of Percona Server 5.6.30-76.3 on May 25, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.6.30, including all the bug fixes in it, Percona Server 5.6.30-76.3 is the current GA release in the Percona Server 5.6 series. Percona Server is open-source […]
In this blog, we’ll look at the MySQL 5.7 document store feature, and how it is implemented. Document Store MySQL 5.7.12 is a major new release, as it contains quite a number of new features: Document store and “MongoDB” like NoSQL interface to JSON storage Protocol X / X Plugin, which can be used for asynchronous […]
In this blog post we’ll discuss pt-online-schema-change, and how to correctly use it. Always use pt-osc? Altering large tables can be still a problematic DBA task, even now after we’ve improved Online DDL features in MySQL 5.6 and 5.7. Some ALTER types are still not online, or sometimes just too expensive to execute on busy production […]
Join Sveta on Thursday, May 26, 2016, at 10 am PDT (UTC-7) for her webinar Troubleshooting MySQL hardware resource usage. MySQL does not just run on its own. It stores data on disk, and stores data and temporarily results in memory. It uses CPU resources to perform operations, and a network to communicate with its clients. […]
Wondering what high availability (HA) solutions are most popular? Take our high availability poll below! HA is always a hot topic. The reality is that if your data is not available, your customers cannot do business with you. In fact, estimates show the average cost of downtime is about $5K per minute. With an average […]
As of May 31st, 2016, we will be disabling TLSv1.0 support on www.percona.com, repo.percona.com, etc. This is ahead of the PCI changes that will affect the June 30th 2016 deprecation the TLSv1.0 protocol. (PDF) What does this mean for you the user? Based on analysis of our IDS logs, this will affect around 6.32% of requests. […]
Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on May 20, 2016. Binaries are available from the downloads area or our software repositories. Percona XtraDB Cluster 5.6.29-25.15 is now the current release, based on the following: Percona Server 5.6.29-76.2 Galera Replicator 3.15 Codership wsrep API 25.15 All of Percona software is open-source […]
Percona is glad to announce the GA release of Percona XtraBackup 2.4.3 on May 23rd, 2016. Downloads are available from our download site and from apt and yum repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods […]
In this blog, I will provide answers to the Q & A for the Troubleshooting Slow Queries webinar. First, I want to thank you for attending the April 28 webinar. The recording and slides for the webinar are available here. Below is the list of your questions that I wasn’t able to answer during the webinar, with […]
In this blog post, we’ll discuss fixing MySQL scalability problems using either ProxySQL or thread pool. In the previous post I showed that even MySQL 5.7 in read-write workloads is not able to maintain throughput. Oracle’s recommendation...Show More Summary
Please join David Murphy on Tuesday, May 24 at 10 am PDT (UTC-7) as he presents “Understanding how your MongoDB schema affects scaling, and when to consider sharding for help.” David will discuss the pros and cons of a few MongoDB schema design patterns on a stand-alone machine, and then will look at how sharding […]
Percona is pleased to announce the release of Percona Server for MongoDB 3.0.11-1.6 on May 19, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB 3.0.11-1.6 is...Show More Summary
Percona is glad to announce the release of Percona Server 5.5.49-37.9 on May 19, 2016. Based on MySQL 5.5.49, including all the bug fixes in it, Percona Server 5.5.49-37.9 is now the current stable release in the 5.5 series. Percona Server is open-source and free. Details of the release can be found in the 5.5.49-37.9 […]
In this blog, we’ll discuss how to find the MySQL 5.7 root password. While new MySQL software security features are always welcome, they can impact use and performance. Now by default, MySQL 5.7 creates a...
Please join Alexander Rubin, Percona Principal Consultant, for his webinar MongoDB administration for MySQL DBA on Thursday, May 19 at 10 am PDT (UTC-7). If you are a MySQL DBA and want to learn MongoDB quickly – this webinar...
In this post, we’ll look at the results from some MySQL 5.7 read-write benchmarks. In my past blogs I’ve posted benchmarks on MySQL 5.5 / 5.6 / 5.7 in OLTP read-only workloads. For example: MySQL 5.7...
In this blog post, we’ll discuss the possible reasons for MySQL “Got an error reading communication packet” errors, and how to address them. In Percona’s managed services, we often receive customer questions on communication failure...