Featured
Percona Products
Percona Services
Use Cases
Baron SchwartzThe first Percona Live conference in San Francisco in February was a huge success, and we’re planning to run several each year. The next one is May 26th in New York City. We’ve just confirmed a number of sought-after speakers and posted the schedule online. We are in the process of confirming sessions from a […]
Percona, and Yasufumi Kinoshita who works for Percona, received two awards from the O’Reilly MySQL Conference co-chairs on behalf of the committee that voted on the nominees. The awards were: to Yasufumi as O’Reilly MySQL Community Contributor of the Year 2011 for InnoDB performance improvements, and to XtraBackup as O’Reilly MySQL Application of the Year […]
Last week wasn’t so active in terms of new development, because many of us were at the MySQL conference, of course. However, we did push out the XtraBackup 1.6 release, and began work on backporting some features from MySQL 5.6 to 5.1 for a certain large customer. Several of the features we’ve added in 5.0 […]
As you might have heard, at the MySQL Conference this earlier this week we announced our launch of Drizzle support services. We added Drizzle to the list of database servers that is covered under our MySQL support contracts. This includes MySQL, Percona Server, Amazon RDS, MariaDB, and the XtraBackup and Maatkit tools.
Last week was rather less newsworthy in Percona Server land, as we spent a lot of time preparing for the MySQL Conference and Collaborate, and Vadim was on vacation. One interesting tidbit: I wrote some scripts analyze our log files and found that we were massively under-counting the number of downloads for Percona Server, due […]
I just realized that we haven’t blogged a list of our sessions at the O’Reilly MySQL Conference and Expo (#mysqlconf) yet. Here is a hopefully complete list.
Want a free pass to the O’Reilly MySQL Conference next week in Santa Clara, California? It’s the MySQL conference, and the session lineup is awesome this year. We’ve got several free passes to give away. Post a comment here to claim your spot. First come, first served! (But make sure you are serious about committing […]
Here’s the weekly review of Percona Server and XtraBackup news. Before I begin, let me briefly address a common question. We are sometimes asked about our plans in light of developments in the market such as MySQL 5.5, MariaDB, Drizzle, etc. The short answer is that we’re very happy with Oracle’s GPL’ed MySQL releases as […]
This is a continuation of my series of benchmark posts comparing Amazon RDS to a server running on Amazon EC2. Upcoming posts (probably 6 or 8 in total) will extend the scope of the benchmark to include data on our Dell r900 with traditional hard drives in RAID10, and a server in the Joyent cloud. […]
We have web badges for promoting Percona Server and XtraBackup! If you use them and want to put little buttons in your website’s footer or sidebar, now it’s easy. There is copy-paste ready HTML for three styles of badge, for each of them: Percona Server badges and Percona XtraBackup badges.
It’s time for the weekly roundup of news for Percona Server and XtraBackup. To follow up on my note from last week, we’re still checking and validating the download stats. It appears that Percona Server has been downloaded well over 100,000 times, and Percona XtraBackup has been downloaded over 200,000 times. But when we changed […]
Two notes for readers. First, we have been publishing a great deal of video material on our companion site Percona.TV. This includes our recordings from past conferences, user group meetings, screencasts, and most recently our webinars. (I hate the proprietary formats and silly technical restrictions that the webinar companies impose. I figured out how to […]
Many of the prominent companies in the MySQL ecosystem are Percona customers, including hardware manufacturers, software developers, hosted service providers, and appliance developers. We perform paid and unpaid research on their products, and we publish blog posts related to their products or services. Independence and objectivity are core Percona values. How do we balance the […]
We’ve just published a new white paper analyzing the causes of emergency incidents filed by our customers. The numbers contradict the urban myth that bad SQL is the most common problem in databases. There are a number of surprises in other areas, too, such as the causes of data loss. This is the companion to […]
The duration of a benchmark is an important factor that helps determine how meaningful it is. Most systems have some “burstable capacity,” and this can influence the results a lot. You can see this in all areas of life — you can sprint much faster than you can run a 10k race. Your stereo system […]
Here’s what is new in Percona Server and Percona XtraBackup since last week. We are working on compiling and checking download statistics for both pieces of software. The preliminary numbers are far higher than I thought they would be. Both Percona Server and XtraBackup are becoming amazingly popular. I am aware of deployments running into […]
The xtrabackup compiled C binary (as distinct from XtraBackup, which is the combination of the C binary and the Perl script) has support for printing out stats on InnoDB tables and indexes. This can be useful to examine whether you’d benefit from “defragmenting” your MySQL database with OPTIMIZE TABLE, although I have not determined firm […]
Amazon’s Relational Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on standard EC2 servers with EBS volumes (see SSD versus EBS death match), and one of them wanted to evaluate RDS as a replacement. It is built on the same technologies, but the hardware and networking are supposed […]
Welcome to the weekly roundup and progress report. What’s new this week in Percona Server:
Among the many things that can cause a “server stall” is a long-running transaction. If a transaction remains open for a very long time without committing, and has modified data, then other transactions could block and fail with a lock wait timeout. The problem is, it can be very difficult to find the offending code […]