by Muhammad Irfan | Jul 15, 2013 | MySQL, Percona Software
Percona Server’s “crash-resistant replication” feature is useful in versions 5.1 through 5.5. However, in Percona Server 5.6 it’s replaced with Oracle MySQL 5.6’s “crash safe replication” feature, which has it’s own...
by Kenny Gryp | Jul 12, 2013 | MySQL
Lefred and I spent a bit of time making innotop 1.9.1. We’ve released a new version mainly to include MySQL 5.6 support as well as including some bugs fixed by Baron Schwartz and Frédéric Descamps. You can download the .tar.gz and rpm’s (new!) at...
by Alexander Rubin | Jul 11, 2013 | Insight for DBAs, MySQL
Dolphin and Elephant: an Introduction This post is intended for MySQL DBAs or Sysadmins who need to start using Apache Hadoop and want to integrate those 2 solutions. In this post I will cover some basic information about the Hadoop, focusing on Hive as well as MySQL...
by Fernando Ipar | Jul 10, 2013 | MySQL, Percona Events, Webinars
Failure is an unavoidable part of IT life, but it does not always have to imply MySQL service downtime. In the years I have been working at Percona, I have been involved in many customer emergency cases, and I have seen a good number of problems that could have been...
by Zardosht.Kasheff | Jul 9, 2013 | MySQL
In my last post, I showed what a Fractal Tree® index is at a high level. Once again, the Fractal Tree index is the data structure inside TokuMX and TokuDB, our MongoDB and MySQL products. One of its strengths is the ability to get high levels of compression on the...
by Yves Trudeau | Jul 9, 2013 | Hardware and Storage, Insight for DBAs, MySQL
For the same customer I am exploring ZFS for backups, the twin server is using regular LVM and XFS. On this twin, I have setup mylvmbackup for a more conservative backup approach. I quickly found some odd behaviors, the backup was taking much longer than what I was...
by Peter Zaitsev | Jul 8, 2013 | MySQL
What programming languages and platforms do you use for large-scale projects in your organization? If something is missing from the list please leave a comment and share your story. Thanks! What Programming languages and platforms do you use ? PHP (25%, 607 Votes)...
by Przemysław Malkowski | Jul 5, 2013 | Insight for DBAs, MySQL
Among many of the improvements you can enjoy in MySQL 5.6, there is one that addresses a huge operational problem that most DBAs and System Administrators encounter in their life: schema changes. While it is usually not a problem for small tables or those in early...
by Jay Janssen | Jul 4, 2013 | MySQL, Webinars
Thanks to all who attended my PXC Operations webinar last week. If you missed it you can watch the video here. I wanted to take some time to answer the questions I didn’t get to during the broadcast. Is there an easy way to leverage the xtrabackup SST and IST...
by Hrvoje Matijakovic | Jul 3, 2013 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.1.70-14.8 on July 3nd, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.70, including all the bug fixes in it, Percona Server 5.1.70-14.8 is now the current...
by Peter Boros | Jul 3, 2013 | Benchmarks, MySQL
Memcache access for MySQL Cluster (or NDBCluster) provides faster access to the data because it avoids the SQL parsing overhead for simple lookups – which is a great feature. But what happens if I try to get multiple records via memcache API (multi-GET) and via...
by Zardosht.Kasheff | Jul 2, 2013 | MySQL
With our recent release of TokuMX 1.0, we’ve made some bold claims about how fast TokuMX can run MongoDB workloads. In this post, I want to dig into one of the big areas of improvement, write performance and reduced I/O. One of the innovations of TokuMX is that it...
by Hrvoje Matijakovic | Jul 2, 2013 | MySQL, Percona Events
Percona is glad to announce the release of Percona Server 5.5.32-31.0 on July 2nd, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.32, including all the bug fixes in it, Percona Server 5.5.32-31.0 is now the current...
by Michael Rikmas | Jul 1, 2013 | Benchmarks, Percona Software
Lots of times we could see different benchmarks performed by tpcc-mysql. So today I want to tell you about how to use tpcc-mysql and how to build graphs with gnuplot in a few easy steps. As an example I’ll compare Percona Server 5.5 (latest version: 5.5.31)...
by Matt Griffin | Jun 28, 2013 | MySQL, Percona Software
Among all of the excellent events going on like YAPC, Velocity, and Percona MySQL University, we recently released Percona Toolkit 2.2.3. It’s a small update that includes the following: pt-online-schema-change did not handle the failure of the DROP TRIGGER...
by Frederic Descamps | Jun 28, 2013 | MySQL, Percona Software
With the last Percona XtraDB Cluster (PXC) release, two major features were added: * a new command to bootstrap the cluster was added to the init script * SST via Xtrabackup now supports Xtrabackup 2.1 features In this post, I want to explain the benefits of these...
by Hrvoje Matijakovic | Jun 27, 2013 | MySQL, Percona Software
Percona is glad to announce the second Release Candidate release of Percona Server 5.6.12-60.4 on June 27th, 2013 (Downloads are available here and from the Percona Software Repositories). Based on the recently released MySQL 5.6.12, including all the bug fixes in it,...
by Nilnandan Joshi | Jun 26, 2013 | Insight for DBAs, MySQL, Percona Software
One very interesting feature, “Compact Backup,” is introduced in Percona XtraBackup 2.1. You can run “compact backups” with the –compact option, which is very useful for those who have limited disk space to keep the MySQL database...
by Vadim Tkachenko | Jun 25, 2013 | Cloud, MySQL
I am actually quite excited about Tokutek’s release of TokuMX. I think it is going to change the landscape of database systems and it is finally something that made me looking into NoSQL. Why is TokuMX interesting? A few reasons: It comes with transactions, and...
by Hrvoje Matijakovic | Jun 25, 2013 | MySQL
Percona is glad to announce the release of Percona XtraDB Cluster 5.5.31-23.7.5 on June 25, 2013. Binaries are available from the downloads area or from our software repositories. New Features: Information about the wsrep sequence number has been added to...
