by Hrvoje Matijakovic | Apr 26, 2012 | MySQL
Percona is glad to announce the release of Percona Server 5.5.22-25.2 on April 25, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.22, including all the bug fixes in it, Percona Server 5.5.22-25.2 is now the current...
by Vadim Tkachenko | Apr 25, 2012 | Benchmarks, Hardware and Storage, MySQL
Following my previous benchmark of Samsung 830, today I want to show results for STEC MACH16 SATA card, 200GB size, this card is based on SLC, and regarding STEC website, it is an enterprise grade storage. For tests I use sysbench fileio, 16KiB block size (to match...
by Vadim Tkachenko | Apr 25, 2012 | Benchmarks, Hardware and Storage, MySQL
I personally like PCIe based Flash, but from a pricing point our customers are looking for cheaper alternatives. SATA SSD is an options. There is many products based on MLC technology, and Intel 320 I would say is the most popular. I do not particularly like its write...
by Peter Zaitsev | Apr 20, 2012 | Insight for DBAs, MySQL
Working on customer case today I ran into interesting problem – query joining about 20 tables (thank you ORM by joining all tables connected with foreign keys just in case) which would take 5 seconds even though in the read less than 1000 rows and doing it...
by kuszmaul | Apr 20, 2012 | MySQL
Challenges of Big Databases with MySQL Many database management tasks become difficult as you move from millions of rows and gigabytes of data to billions of rows and terabytes of data. Such tasks include ingesting data while maintaining indexes;...
by Vadim Tkachenko | Apr 20, 2012 | Benchmarks, MySQL, Percona Software
We are running internally a lot of benchmarks on our recently announced Percona XtraDB Cluster, and I am going to publish these results soon. But before that I wanted to mention that proper benchmark of distributed system comes with a lot of challenges. I am saying...
by Yves Trudeau | Apr 19, 2012 | MySQL
The slides and accompanying document of the High availability deep dive tutorial have all been uploaded and can be downloaded from the link below: http://box.com/perconalive2012 For the slides, you’ll find a PDF and a pptx version, the gdocs animations works...
by Kenny Gryp | Apr 19, 2012 | MySQL, Percona Events
Percona has 2 talks lined up at OSDC in Nuremberg, Germany: – Taking hot backups with XtraBackup by Alexey Kopytov – Expert Troubleshooting: Resolving MySQL Problems Quickly by Kenny Gryp Feel free to come and say Hi! On April 25 & 26, 2012 the Open...
by Tokutek | Apr 18, 2012 | MySQL
Thanks to all of those who came by our booth and to see Leif’s presentation on Read Optimization, and to my Lightning Talk on OLTP and OLAP at the Percona MySQL Conference and Expo. It was an incredible week and a great place to launch TokuDB v6.0 from! A big...
by David Hildebrandt | Apr 18, 2012 | MySQL, Percona Events
Over the coming three months, Percona will be holding our highly acclaimed MySQL courses in the following cities: Dallas, Texas – May 14 – 17, 2012 London, England – May 21 – 24, 2012 Orlando, Florida – June 11 – 14, 2012 Raleigh,...
by Baron Schwartz | Apr 17, 2012 | MySQL, Percona Events, Percona Software
I’m happy to announce that version 1.0 of Percona Monitoring Plugins is now available. The Percona Monitoring Plugins are high-quality plugins, templates, and add-ons for Nagios and Cacti, so you can add world-class MySQL monitoring to your existing enterprise...
by Baron Schwartz | Apr 17, 2012 | MySQL, Percona Events
Thanks to all of our sponsors, speakers, speaker selection committee, event staff, and especially the attendees for making last week’s conference a resounding success. With over a thousand people, the event made a good comeback after last year’s event, but...
by Frederic Descamps | Apr 17, 2012 | MySQL, Percona Software
If you have recently attended some Percona Live events or if you have checked some slides from Yves Trudeau, you may have heard about Percona Replication Manager (PRM), a new high availability tool for MySQL. Percona Live DC 2012 Percona Live MySQL Conference &...
by Leif.Walsh | Apr 13, 2012 | MySQL
This week, I was at Percona Live, and it was a lot of fun! I even got to give a talk on write optimization techniques (not just ours), that I’m told will be online soon. But if you missed that, or even if you didn’t, I’m still in the valley until...
by Martin.FarachColton | Apr 12, 2012 | MySQL
Checkpointing — which involves periodically writing out dirty pages from memory — is central to the design of crash recovery for both TokuDB and InnoDB. A key issue in designing a checkpointing system is how often to checkpoint, and TokuDB takes a very...
by Frederic Descamps | Apr 12, 2012 | MySQL, Percona Software
For those wanting to become more familiar with Percona XtraDB Cluster or if you just one to test its capabilities, I have prepared an easy Vagrant setup ready to deploy. It contains the puppet recipes to install and configure a cluster of 3 nodes and a load balancer...
by Martin.FarachColton | Apr 11, 2012 | MySQL
A key feature of our new TokuDB v6.0 release, which I have been blogging about this week, is compression. Compression is always on in TokuDB, and the compression we’ve achieved in the past has been quite good. See a previous post on the 18x compression achieved...
by Martin.FarachColton | Apr 10, 2012 | MySQL
Master/slave replication is an important tool that gets used in many ways: distributing read loads among many slaves for performance, using a slave for backups so the master can handle live load, geographically distributed disaster recovery, etc. The Achilles’...
by Stewart Smith | Apr 10, 2012 | Cloud
The Drizzle team has published the first Drizzle 7.1 stable release. The announcement on the Drizzle blog covers some of the major improvements in this release over the previous stable release, Drizzle 7.0. I plan to write a variety of blog posts on each of the new...
by Baron Schwartz | Apr 10, 2012 | MySQL, Percona Events
I’m delighted to announce a partnership with New Relic. The press release has the details (all new Gold and Platinum support contracts get free New Relic subscriptions) but I wanted to add some of the behind-the-scenes context. The quote from me in the press...
