by Martin.FarachColton | Jun 19, 2013 | MySQL
Tokutek is known for its full-featured fast-indexing technology. MongoDB is known for its great document-based data model and ease of use. TokuMX, version 1.0, combines the best of both worlds. So what, exactly, is TokuMX? The simplest (but incomplete) answer is that...
by Peter Zaitsev | Jun 19, 2013 | MySQL
In many environments MySQL is not the only technology used to store in-process data. Quite frequently, especially with large-scale or complicated applications, we use MySQL alongside other technologies for certain tasks of reporting, caching as well as main data-store...
by Martin.FarachColton | Jun 11, 2013 | MySQL
As promised, the Enterprise Edition of TokuDB®, Version 7, is ready. TokuDB Version 7, Enterprise Edition, introduces Hot Backup. You can now back up all your TokuDB tables directly from MySQL or MariaDB, with no down time. In addition, TokuDB Enterprise Edition comes...
by Peter Boros | Jun 11, 2013 | MySQL, Percona Events
MySQL can be deployed in several ways, and that means you can choose a tailor-made path that best meets your needs. With simple services or development systems, many people are using a single server with some backups configured, and then simply take the downtime when...
by Tim.Callaghan | Jun 6, 2013 | MySQL
Tokutek created the iiBench benchmark back in 2008. The point of the benchmark is to measure the performance of indexed insertions over time. It uses an extremely simple schema, one table with a sequential insertion pattern for the primary key along with three integer...
by Zardosht.Kasheff | Jun 3, 2013 | MySQL
Over several blog posts, Tim has presented performance results on large data sets of TokuMX, our MongoDB product with fractal tree indexes integrated, side by side with MongoDB. Results look good. We’ve shown improved throughput numbers on a sysbench benchmark,...
by Bill Karwin | Jun 3, 2013 | Insight for Developers, MySQL, Webinars
On Friday I gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended, and especially to folks who asked the great questions. I...
by Jaime Crespo | May 31, 2013 | Insight for DBAs, MySQL, Percona Software
Here at the MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based replication, InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL and several other InnoDB and query optimizer...
by Stephane Combaudon | May 30, 2013 | Insight for DBAs, MySQL
The main benefit of using GTIDs is to have much easier failover than with file-based replication. We will see how to change the replication topology when using GTID-based replication. That will show where GTIDs shine and where improvements are expected. This is the...
by Tim.Callaghan | May 28, 2013 | MySQL
Two months ago I posted a performance comparison running Sysbench on MongoDB versus MongoDB with Fractal Tree Indexes v0.0.2. The benchmark showed a 133% improvement in throughput. Nice, but our engineering team had an effort on our road-map for lock refinement that...
by Yves Trudeau | May 24, 2013 | Hardware and Storage, Insight for DBAs, MySQL
I am currently working with a large customer and I am involved with servers located in two data centers, one with Solaris servers and the other one with Linux servers. The Solaris side is cleverly setup using zones and ZFS and this provides a very low virtualization...
by Justin Swanhart | May 22, 2013 | Benchmarks, MySQL
This blog post is part two in what is now a continuing series on the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage engine. In my testing I discovered that...
by Bill Karwin | May 20, 2013 | MySQL, Webinars
Next Friday, May 31 at 10 a.m. Pacific, I’ll present Percona’s next webinar, “SQL Query Patterns, Optimized.” Based on my experiences solving tough SQL problems for Percona training and consulting, I’ll classify several common types of...
by Tim.Callaghan | May 15, 2013 | MySQL
I finally posted a copy of the slides from my Percona Live presentation, “Creating a Benchmarking Infrastructure that Just Works”. The PDF is available via this link. The content comes from my personal experiences over many years benchmarking and testing...
by Tim.Callaghan | May 13, 2013 | MySQL
At tomorrow’s Effective MySQL Meetup, I’ll be presenting “Fractal Tree Indexes : Theory and Practice (MySQL and MongoDB).” The meetup is at 6:30pm Tuesday, May 14, 2013, and will be held at Alley NYC in New York City. I’ll give an overview on how Fractal...
by Vadim Tkachenko | May 10, 2013 | MySQL
I was reviewing the Percona Live sponsors list the other day and pondering the potential success stories associated with this product or that one…. and as I was preparing to put more thought on the topic, a PlanetMySQL post caught my eye. It was penned by Mike...
by Alexey Stroganov | May 8, 2013 | Benchmarks, MySQL
Around month ago Facebook has announced the Linkbench benchmark that models the social graph OLTP workload. Sources, along with a very nice description of how to setup and run this benchmark, can be found here. We decided to run this benchmark for MySQL Server 5.5.30,...
by Tokutek | May 2, 2013 | MySQL
Last week I had to present a tutorial at Percona Live 2013, a presentation at SkySQL’s MySQL & Cloud Database Solution Day and last but not least, a presentation on a Saturday morning at Linuxfest Northwest. It wasn’t easy, but giving the presentations after...
by Tokutek | Apr 29, 2013 | MySQL
With this version, the source code is now freely available under the GPL License v2. For more details, see our blog here. Open source pioneer Mozilla has been using TokuDB to manage its MySQL-driven Datazilla Data cluster, an open-source system for managing and...
by Leif.Walsh | Apr 26, 2013 | MySQL
Since we had the pleasure to announce that TokuDB is open source on Monday, it’s been a thrilling ride. With several members of the team out west all week, back on the east coast we’ve been seeing quite a lot of questions, suggestions, and exciting results. Here are...
