Percona Server version 5.6.16-64.1
Based on MySQL 5.6.16, including all the bug fixes in it, Percona Server[Read more...]
|Showing entries 1 to 30 of 183||Next 30 Older Entries|
I am very pleased to announce a new event in conjunction with the Percona Live MySQL Conference and Expo this year: Open Source Appreciation Day on Monday, March 31st in the Santa Clara Convention Center! We are pleased to announce two separate groups holding events this year under this new umbrella. We are hosting an event called “OpenStack Today” for those interested in learning more about developments in the OpenStack world. CentOS is holding the “[Read more...]
Monitoring MySQL and effectively managing it can be challenging. Identifying issues before they grow into performance problems that impact end users can be crucial. Knowing which tools to use, which key metrics to monitor, and how to resolve issues can be enormously important. When considering these facts, we at Percona decided to take steps to provide our Support customers with the tools, alerts, and advice they need to have higher performing, more secure, and easier to manage MySQL deployments.
I am pleased to announce that Percona now provides our Gold and Platinum Percona Support for MySQL customers with the enterprise grade tools and advice they need for better performance, fewer database issues, and effective monitoring of[Read more...]
TL;DR version: The backup locks feature introduced in Percona Server 5.6.16-64.0 is a lightweight alternative to
FLUSH TABLES WITH READ LOCK and can be used to take both physical and logical backups with less downtime on busy servers. To employ the feature with
mysqldump --lock-for-backup --single-transaction. The next release of Percona XtraBackup will also be using backup locks automatically if the target server supports the feature.
Now on to the gory details, but let’s start with some history.
In the beginning there was
FLUSH TABLES, and users messed with their MyISAM tables under a live server and were not ashamed. Users could do nice things like:
mysql> FLUSH TABLES; # execute myisamchk, myisampack, backup / restore some[Read more...]
Percona Server version 5.5.36-34.0
Percona is glad to announce the release of Percona Server 5.5.36-34.0 on March 10th, 2014 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.36, including all the bug fixes in it, Percona Server 5.5.36-34.0 is now the current stable release in the 5.5 series. All of Percona‘s[Read more...]
I spoke last month at linux.conf.au 2014 in Perth, Australia, and one of my sessions focused on the “Continuous Integration (CI) testing of Percona XtraDB Cluster (PXC)” at the Developer,Testing, Release and CI miniconf.
This talk covered the continuous integration[Read more...]
We recently announced Percona ClusterControl supplied in partnership with Severalnines. This enterprise-grade cluster management and monitoring software is available with a Percona Support contract covering Percona XtraDB Cluster, MySQL Cluster, or MySQL Galera. In this blog post I am going to show you how to use Percona ClusterControl to to create a new 3-node cluster with Percona XtraDB Cluster.
The software has three main parts:
One of the more popular support requests we get involves setting up the official Percona
rsync repositories that can be used to set up local mirrors. I’m glad to announce that this was implemented recently. You can now access the
rsync repository at:
Setting up the local mirror can be useful if you have a larger number of systems and you don’t want to download packages from the remote repository multiple times, it can also be useful if the original repository is slower or inaccessible.
Create a folder on disk where the files will be downloaded. Make sure you have enough space for this, currently repository for CentOS 6 is almost 2GB.
Percona is pleased to announce the first General Availability release of the leading open source High Availability solution for MySQL, Percona XtraDB Cluster 5.6 on January 30, 2014. Binaries are available from downloads area or from our software repositories.
Percona XtraDB Cluster 5.6
Percona XtraDB Cluster 5.6 is an active/active cluster solution for High Availability (HA) MySQL that delivers performance and
This release is the current GA (Generally Available) stable release in the 2.1 series. Percona XtraBackup is an open source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases.[Read more...]
This blog, MySQLPerformanceBlog.com, is powered by WordPress, but we never really looked into what kind of queries to MySQL are used by WordPress. So for couple months we ran a Query Analytics (part of Percona Cloud Tools) agent there, and now it is interesting to take a look on queries. Query Analytics uses reports produced by pt-query-digest, but it is quite different as it allows to see trends and dynamics of particular query, in contrast to pt-query-digest, which is just one static report.
Why looking into queries important? I gave an intro in my previous post from this series.
So Query Analytics give the report on the top queries. How to detect which[Read more...]
One of our primary focuses at Percona is performance. Let me make some statements on what is “performance.”
In doing so I will refer to two pieces of content:
I highly recommend that you familiarize yourself with both of them.
Performance is about tasks and time.
We say that the system is performing well if it
Percona Server version 5.5.35-33.0
Percona is glad to announce the release of Percona Server 5.5.35-33.0 on December 20th, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.35, including all the bug fixes in it, Percona Server 5.5.35-33.0 is now the current stable release in the 5.5 series. All of Percona‘s[Read more...]
Percona is glad to announce the release of Percona Toolkit 2.2.6 on December 20th, 2013 (Downloads are available here and from the Percona Software Repositories). This release is the current GA (Generally Available) stable release in the 2.2 series. This release has 16 bug fixes and a few new features. One bug fix is very important, so 2.2 users are strongly encouraged to upgrade:
I recently conducted a test backup of my “master-slave” setup in my VirtualBox as I was migrating from Percona Server 5.6.12 to version 5.6.13-rel61.0 with Percona XtraBackup v2.2.0 rev. 4885. However, doing the backup on my slave, I encountered this problem:
 Compressing and streaming ./test/checksum.ibd  Compressing and streaming ./mysql/slave_master_info.ibd Assertion "to_read % cursor->page_size == 0" failed at fil_cur.cc:293 innobackupex: Error: The xtrabackup child process has died at /usr/bin/innobackupex line 2641.
This is related to a bug posted by my colleague[Read more...]
Recently, I helped a client that was having issues with deployments causing locking in their production databases. At a high level, the two key components used in the environment were:
At a high level, they currently used a CLI call to Liquibase as a sub-task within a larger deployment task. The goal of this engagement was to modify that sub-task to run Liquibase in a non-blocking fashion as opposed to the default that just runs native ALTERS against the database.
As I wasn’t very familiar with Liquibase, I took this opportunity to learn more about it and it seems like a very valuable tool.[Read more...]
In this post I wanted to highlight
percona.com/bugs/<tool>, for example: percona.com/bugs/pt-stalk. This only works for Percona Toolkit. We often advise people to check a tool’s current bugs, but we don’t always say how.
The official link for Percona Toolkit bugs on Launchpad is https://bugs.launchpad.net/percona-toolkit/+bugs, but then you still have search from there. So this quick link is a lot easier if, for example,[Read more...]
Percona Server version 5.5.34-32.0
Percona is glad to announce the release of Percona Server 5.5.34-32.0 on October 28th, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.34, including all the bug fixes in it, Percona Server 5.5.34-32.0 is now the current stable release in the 5.5 series. All of Percona‘s[Read more...]
Percona Server version 5.1.72-14.10
Percona is glad to announce the release of Percona Server 5.1.72-14.10 on October 28th, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.72, including all the bug fixes in it, Percona Server 5.1.72-14.10 is now the current stable release[Read more...]
You are welcome to play with these binaries, but keep in mind:
The post Percona Server 5.6.14 with TokuDB 7.1 Experimental build appeared first on MySQL Performance Blog.
Percona is glad to announce the release of Percona Monitoring Plugins 1.0.5 for MySQL. The components are designed to integrate seamlessly with widely deployed solutions such as Nagios and Cacti, and are delivered in the form of templates, plugins, and scripts.
* Added mysql-ca option to ss_get_mysql_stats.php (bug 1213857)
* Added user info to the idle_blocker_duration check of pmp-check-mysql-innodb (bug 1215317)
* Extended pmp-check-mysql-processlist with more locking states (bug 1213859)
* ss_get_mysql_stats.php did not work with custom mysql port (bug 1213862)
* ss_get_mysql_stats.php silently failed
Yesterday we announced the GA release of Percona Server 5.6, the latest release of our enhanced, drop-in replacement for MySQL. Percona Server 5.6 is the best free MySQL alternative for demanding applications. Our third major release, Percona Server 5.6 offers all the improvements found in MySQL 5.6 Community Edition plus scalability, availability, backup, and security features some of which are found only in MySQL 5.6 Enterprise Edition.
Percona Server 5.6 comes with:
I occasionally see customers who are taking backups from their PXC clusters that complain that the cluster “stalls” during the backup. As I wrote about in a previous blog post, often these stalls are really just Flow Control. But why would a backup cause Flow control?
Most backups I know of (even Percona XtraBackup) take a FLUSH TABLES WITH READ LOCK (FTWRL) at some point in the backup process. This can be disabled in XtraBackup (in certain circumstances), but it is enabled by[Read more...]
Percona Server version 5.6.13-61.0
Based on MySQL 5.6.13, including all the bug fixes in it,[Read more...]
Percona Server provides users with a variety of powerful benefits including enterprise-grade features, high performance in demanding use cases, rich diagnostics, and access to unique Percona XtraBackup capabilities, all for free and open source. In addition, Percona Server is a drop-in MySQL replacement. Compatibility with MySQL has important ramifications (as well as some risks) as Giuseppe Maxia highlighted in a recent blog post about MySQL alternatives. Our commitment to drop-in compatibility with MySQL has important benefits for Percona Server users and drives our[Read more...]
Companies say they value the enterprise-grade features and high performance that Percona Server delivers for free and use the software to power critical business applications, hot new apps, and even a growing web host.
We’d love to hear from you. If you use Percona Server or our other software in a production environment,[Read more...]
I recently blogged on setting up Experimental Git mirror of Oracle MySQL trees up on GitHub. I’m now happy to announce that there are also mirrors for:
I’ve also updated the Oracle MySQL GIT mirror to include MySQL 5.7 and the (now abandoned) MySQL 6.0. I include the abandoned 6.0 tree as it can provide useful archaeology as to where some code came from.
I’d love to hear about any positive/negative experiences using these[Read more...]
|Showing entries 1 to 30 of 183||Next 30 Older Entries|