May 24, 2013

Presentations Announcement: 2010 O’Reilly MySQL Conference & Expo

April 29, 2010 By 4 Comments

The Percona team participated at this year’s O’Reilly MySQL Conference & Expo held April 12-15, 2010 in Santa Clara, California. We gave a lot of talks on…

Author: Peter Zaitsev, Justin Swanhart

MySQL Graphing and Trending with Cacti

Author: Baron Schwartz

Percona‘s Performance and Feature Enhancements to MySQL and InnoDB

Author: Bill Schuler, Baron Schwartz…a Bottleneck

Author: Morgan Tocker

XtraBackup Hot Backups and More

Author: Vadim Tkachenko, Morgan Tocker

You can also read more about this conference on Percona site.

Filed Under: Events and Announcements Tagged With: , , , , ,

How fast is FLUSH TABLES WITH READ LOCK?

April 24, 2010 By 30 Comments

A week or so ago at the MySQL conference, I visited one of the backup vendors in the Expo Hall. I started to chat with them about their MySQL backup product. One of the representatives told me that their backup product uses FLUSH TABLES WITH READ LOCK, which he admitted takes a global lock on [...]

Filed Under: Insight for Developers, MySQL Tagged With:

Introducing percona-patches for 5.1

February 9, 2010 By 21 Comments

Our patches for 5.0 have attracted significant interest.  You can read about SecondLife’s experience here, as well as what Flickr had to say on their blog.  The main improvements come in both performance gains and improvements to diagnostics (such as the improvements to the slow log output, and INDEX_STATISTICS). Despite having many requests to port [...]

Filed Under: MySQL, Percona Software Tagged With: ,

EC2/EBS single and RAID volumes IO benchmark

August 6, 2009 By 14 Comments

During preparation of Percona-XtraDB template to run in RightScale environment, I noticed that IO performance on EBS volume in EC2 cloud is not quite perfect. So I have spent some time benchmarking volumes. Interesting part with EBS volumes is that you see it as device in your OS, so you can easily make software RAID [...]

Filed Under: Benchmarks Tagged With: , , , ,

When would you use SAN with MySQL ?

March 9, 2009 By 18 Comments

One question which comes up very often is when one should use SAN with MySQL, which is especially popular among people got used to Oracle or other Enterprise database systems which are quite commonly deployed on SAN. My question in such case is always what exactly are you trying to get by using SAN ?

Filed Under: Hardware and Storage Tagged With:

Making replication a bit more reliable

March 4, 2009 By 14 Comments

Running MySQL slave is quite common and regular task which we do every day, taking backups from slave is often recommended solution. However the current state of MySQL replication makes restoring slave a bit tricky (if possible at all). The main problem is that InnoDB transaction state and replication state are not synchronized. If we [...]

Filed Under: Percona Software Tagged With: ,

Faster MySQL failover with SELECT mirroring

February 1, 2009 By 9 Comments

One of my favorite MySQL configurations for high availability is master-master replication, which is just like normal master-slave replication except that you can fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, this is probably the best general-purpose way to get fast failover and a bunch of other benefits (non-blocking ALTER [...]

Filed Under: Insight for DBAs Tagged With: , ,

Should you move from MyISAM to Innodb ?

January 12, 2009 By 59 Comments

There is significant portion of customers which are still using MyISAM when they come to us, so one of the big questions is when it is feasible to move to Innodb and when staying on MyISAM is preferred ? I generally prefer to see Innodb as the main storage engine because it makes life much [...]

Filed Under: Insight for DBAs Tagged With: , ,

How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

Our customers or prospective customers often ask us how we do a performance audit (it’s our most popular service). I thought I should write a blog post that will both answer their question, so I can just reply “read all about it at this URL” and share our methodology with readers a little bit. This [...]

Filed Under: Insight for Developers Tagged With:

Living with backups

November 6, 2008 By 28 Comments

Everyone does backups. Usually it’s some nightly batch job that just dumps all MySQL tables into a text file or ordinarily copies the binary files from the data directory to a safe location. Obviously both ways involve much more complex operations than it would seem by my last sentence, but it is not important right [...]

Filed Under: Insight for DBAs Tagged With: , ,
« Older Posts
Newer Posts »