by Stewart Smith | Dec 6, 2012 | MySQL, Percona Software
Recently there have been discussions on several vulnerabilities in MySQL and closely related projects such as MariaDB and Percona Server. Usually we have inherited security fixes from MySQL when we have updated Percona Server to be based off a new Oracle MySQL...
by Martin.FarachColton | Dec 6, 2012 | MySQL
We get a lot of questions about how Fractal Tree indexes work. It’s a write-optimized index with fast queries, but which write-optimized indexing structure is it? In this ~15 minute video (which uses these slides), I give a quick overview of how they work and...
by Jay Janssen | Dec 5, 2012 | Insight for DBAs, MySQL, Percona Software
I had a customer recently who needed to reduce their database size on disk quickly without a lot of messy schema redesign and application recoding. They didn’t want to drop any actual data, and their index usage was fairly high, so we decided to look for unused...
by Hrvoje Matijakovic | Dec 4, 2012 | MySQL
Percona is glad to announce the release of Percona XtraBackup 2.0.4 on December 4th, 2012. Downloads are available from our download site here and Percona Software Repositories. This release is the current GA (Generally Available) stable release in the 2.0 series....
by Kenny Gryp | Dec 4, 2012 | MySQL, Percona Events, Percona Software
The Web And PHP Magazine just published an article describing Percona XtraDB Cluster written by Liz van Dijk and Kenny Gryp. It is a pretty high-level introduction to the technology, so definitely give it a read if you’ve been wanting to give it a closer look....
by Jay Janssen | Dec 3, 2012 | MySQL, Percona Events
As Percona Live London is raging in the UK, I thought it fitting to remind everyone about the next big Percona Live: MySQL Conference and Expo 2013 in Santa Clara, Californa on April 22-25, 2013. You can register NOW for this conference, and the Super Saving...
by Frederic Descamps | Nov 30, 2012 | MySQL, Percona Events, Percona Software
On Monday I will deliver with Seppo Jaakola from Codership a tutorial on Percona XtraDB Cluster (Percona Server + Galera). Already in London and you don’t know how to consume the hotel’s bandwidth ? If you attend this tutorial, you can download the Virtual...
by Peter Zaitsev | Nov 30, 2012 | MySQL
This Friday we’ll have two polls instead of one to learn about Operating system we’re using to run MySQL. First Poll is about production use and second is about development. I know many developers would run MySQL on Linux in Production but use Windows or...
by Justin Swanhart | Nov 28, 2012 | Insight for DBAs, MySQL
Notice the result of the NOW() function in the following query. The query was run on a real database server and I didn’t change the clock of the server or change anything in the database configuration settings. mysql> SELECT NOW(),SYSDATE();...
by Tokutek | Nov 27, 2012 | MySQL
In this webinar we will show step by step how to install, configure, and test TokuDB for a typical performance evaluation. We’ll also be flagging potential pitfalls that can ruin the eval results. It will describe the differences between installing from scratch...
by Hrvoje Matijakovic | Nov 26, 2012 | MySQL
Percona is glad to announce the release of Percona Playback 0.5 on November 26th, 2012. Downloads are available from our download site and Percona Software Repositories. Percona Playback is a tool for replaying the load of one database server to another. Currently it...
by Jay Janssen | Nov 26, 2012 | MySQL, Percona Software
I learn more and more about Galera every day. As I learn more, I try to keep my myq_gadgets toolkit up to date with what I consider is important to keep any eye on on a PXC node. In that spirit, I just today pushed some changes to the ‘wsrep’ report, and...
by Peter Zaitsev | Nov 24, 2012 | MySQL, Percona Events
Time for another poll! I wonder What CPU Architecture do you use for running MySQL in Production ? I guess most of the game here is between Intel and AMD x86-64 variants though I wonder if there is still a lot of use for others in the wild. If I am missing some...
by Stephane Combaudon | Nov 23, 2012 | Insight for DBAs, Insight for Developers, MySQL
Earlier this week, Cédric blogged about how easy we can get confused between a covering index and a full index scan in the EXPLAIN output. While a covering index (seen with EXPLAIN as Extra: Using index) is a very interesting performance optimization, a full index...
by Bill Karwin | Nov 22, 2012 | Insight for DBAs, MySQL, Percona Events
One of my favorite tools in the Percona Toolkit is pt-query-digest. This tool is indispensable for identifying your top SQL queries, and analyzing which queries are accounting for your database load. But the report you get from pt-query-digest is only as good as the...
by Frederic Descamps | Nov 21, 2012 | MySQL, Percona Events, Percona Software
If you are interested by a great and revolutionary HA solution for MySQL or even if you already have some experience with PXC and/or Galera, I invite you to attend the tutorial I will deliver in Percona Live MySQL Conference London 2012 (PLUK2012), December 3rd :...
by Jay Janssen | Nov 20, 2012 | MySQL, Percona Software
I have addressed previously how multi-node writing causes unexpected deadlocks in PXC, at least, it is unexpected unless you know how Galera replication works. This is a complicated topic and I personally feel like I’m only just starting to wrap my head around...
by Peter Zaitsev | Nov 20, 2012 | MySQL, Percona Events
Have you been using Percona Server ? Interested to Try ? Using Percona Server in Production Tutorial at Percona Live, London is a great talk for you. In my experience working with customers I discovered many people are not aware about number of unique features Percona...
by Tokutek | Nov 19, 2012 | MySQL
One of the great things about the MassTLC unConference is the spontaneity of the ideas. In the morning I ran into an old colleague whose startup was looking at switching databases and struggling with the options. Hence, “Scalable Databases for Startups” seemed like a...
by Peter Zaitsev | Nov 19, 2012 | MySQL, Percona Events
I have a pleasure to deliver Webinar on Industrial-Strength MySQL Applications Using Percona and Continuent together with Robert Hodges next week, Nov 28. We will talk about how you can use technologies from Percona and Continuent to build Highly Performance and...
