by Tokutek | Sep 25, 2012 | MySQL
TokuDB is the only MySQL/NoSQL solution that allowed us to scale our write throughput in a cost effective way.
by Tokutek | Sep 25, 2012 | MySQL
TokuDB has a clever architecture for managing mixed read/write workloads.
by Mike Benshoof | Sep 25, 2012 | Insight for DBAs, MySQL, Percona Software
I recently worked through an issue with a client trying to detect data drift across some servers that were located in different timezones. Unfortunately, several of the tables had timestamp fields and were set to a default value of CURRENT_TIMESTAMP. From the...
by Vadim Tkachenko | Sep 24, 2012 | MySQL, Percona Software
Not so long ago Fusion-io announced an SDK which provides direct API access to Fusion ioMemory(tm) in addition to providing a native filesystem (directFS) with a goal to avoid overhead from kernel and regular Linux filesystems: ext4 and xfs. This requires a support...
by Tokutek | Sep 24, 2012 | MySQL
On Friday our CEO John Partridge was named a “Tech Luminary” in the 17th annual Innovation All Stars award, which is given jointly by Mass High Tech (MHT) and the Boston Business Journal (BBJ). As noted in MHT by the editor, Chris McIntosh, the Luminary...
by Stewart Smith | Sep 20, 2012 | Benchmarks, MySQL, Percona Software
Yesterday, over at my personal blog, I blogged about the impact of the MySQL slow query log. Since we’re working on Percona Server 5.6, I did wonder if this was a good opportunity to re-examine how we could provide slow query log type functionality to our users....
by Vadim Tkachenko | Sep 20, 2012 | Hardware and Storage, MySQL, Percona Events
Not so far ago Fusion-io announced SDK which provides direct API access to Fusion ioMemory(tm) in addition to providing a native filesystem (directFS) with a goal to avoid overhead from kernel and regular Linux filesystems: ext4 and xfs. Fusion-io will explain these...
by Yves Trudeau | Sep 20, 2012 | MySQL
Just a reminder that Wednesday the 26th at 10am Pacific time, I’ll give a webinar on PRM, the Percona replication manager. During the webinar, I’ll walk you through the setup of a PRM cluster and show you how to perform some basic management tasks. If you...
by Peter Zaitsev | Sep 19, 2012 | MySQL, Percona Events
With Percona Live NYC right around the corner I decide some of attendees what did they like on the last year event and what they are looking forward to in 2012. Here are some responses I got. If you’ve attended in 2011 or planning to join us in 2012 please feel...
by Peter Zaitsev | Sep 19, 2012 | Insight for DBAs, MySQL
Just yesterday I wrote about math of automatic failover today I’ll share my thoughts about what makes MySQL failover different from many other components and why asynchronous nature of standard replication solution is causing problems with it. Lets first think...
by Miguel Angel Nieto | Sep 19, 2012 | Insight for Developers, MySQL
The principal source of information for InnoDB diagnostics is the output of SHOW ENGINE INNODB STATUS but there are some sections that are not very useful. For example, LATEST DETECTED DEADLOCK only shows, as the name implies, the latest error detected. If you have...
by Peter Zaitsev | Sep 18, 2012 | Insight for DBAs, MySQL
There are number of people recently blogging about MySQL automated failover, based on production incident which GitHub disclosed. Here is my take on it. When we look at systems providing high availability we can identify 2 cases of system breaking down. First is when...
by Zardosht.Kasheff | Sep 18, 2012 | MySQL
At next week’s Strange Loop conference, I will give a talk on “Understanding Indexing”. The session is 10 am Monday, September 24th, and will be held in the Midland States Room.
by Stewart Smith | Sep 13, 2012 | Percona Software
We are glad to announce the availability of Percona Playback 0.4, the first release where we’ve released binary packages alongside our source release. Binary packages for RHEL/CentOS 6 are available with Debian/Ubuntu packages soon to come (we are ensuring our...
by Stewart Smith | Sep 13, 2012 | Percona Software
Percona is glad to announce the ALPHA release of Percona Server 5.6.6-60.1 on September 14, 2012 (Downloads are available here and from the EXPERIMENTAL Percona Software Repositories, although currently only for RHEL/CentOS as we are working on ensuring compatibility...
by Tim.Callaghan | Sep 13, 2012 | MySQL
In my three previous blogs I wrote about our implementation of Fractal Tree Indexes on MongoDB, showing a 10x insertion performance increase, a 268x query performance increase, and a comparison of covered indexes and clustered indexes. The benchmarks show the...
by Vadim Tkachenko | Sep 13, 2012 | MySQL, Percona Events
On Percona Live New York I’ll be giving two talks “Percona XtraDB Cluster: HA solution for MySQL”. I will give introduction in MySQL clustering and show how Percona XtraDB Cluster solves HA and scalability problems. MySQL and SSD: usage and tuning....
by Peter Boros | Sep 12, 2012 | MySQL
Next Wednesday, September 19 at 10:00 AM PDT I will present a webinar on Percona XtraDB Cluster. The webinar focuses on the basics of XtraDB Cluster, we will install it, break it, fix it, and use HaProxy with it. If you are looking to deploy XtraDB Cluster, or just...
by Jay Janssen | Sep 12, 2012 | MySQL, Percona Events, Percona Software
I’ve mentioned this before, but I’m delivering a tutorial on Percona XtraDB Cluster / Galera at Percona Live NY 2012 right in midtown-Manhattan on October 1st. I really want this tutorial to be hands-on, not just a 3 hour lecture, so you can actually see...
by Vadim Tkachenko | Sep 11, 2012 | Benchmarks, Hardware and Storage, MySQL
I continue my benchmarks of Intel SSD 910, previous time I compared it with Fusion-io ioDrive https://www.percona.com/blog/2012/09/07/intel-ssd-910-in-tpcc-mysql-benchmark/. Now I want to test this card against RAID over spinning disks. Benchmark date: Sep-2012...
