by Peter Zaitsev | Oct 6, 2013 | Cloud, Insight for Developers, MySQL
Baron recently wrote about sending the query to the data looking at distributed systems like Cassandra. I want to take a look at more simple systems like MySQL and see how we’re doing in this space. It is obvious getting computations as closer to the data as...
by Rich.Prohaska | Oct 3, 2013 | MySQL
One of our customers reported that ‘create table select from’ statements stall for a period of time equal to the TokuDB lock timeout. This indicated a lock conflict between multiple transactions. In addition, other MySQL clients that were opening...
by Dave Rosenlund | Oct 2, 2013 | MySQL
Save Time & Money – Do It Right The First Time SPEAKER: Gerry Narvaja, Tokutek DATE: Tuesday, October 8th TIME: 1pm ET If you are thinking of using the leading open source database in a project, learn just how easy it is to get started with MySQL, and how...
by Alexander Rubin | Oct 1, 2013 | Insight for DBAs, Insight for Developers, MySQL, Webinars
MySQL DBAs know that integrating MySQL and a big data solution can be challenging. That’s why I invite you to join me this Wednesday (Oct. 2) at 10 a.m. Pacific time for a free webinar in which I’ll walk you through how to implement a successful big data strategy with...
by Rich.Prohaska | Sep 20, 2013 | MySQL
One of our customers sometimes observed lots of simple insertions taking far longer than expected to complete. Usually these insertions completed in milliseconds, but the insertions sometimes were taking hundreds of seconds. These stalls indicated the existence of a...
by Christian.Rober | Sep 19, 2013 | MySQL
In my last post, I discussed the existing backup solutions for MySQL. At the end I briefly discussed why the backup solutions for InnoDB do not apply to TokuDB. Now I’m going to outline the backup solution we created. Our solution works for both TokuDB and...
by Christian.Rober | Sep 12, 2013 | MySQL
There are multiple ways to backup a MySQL database. Some are more painful than others. In this two part blog we are going to discuss why the new hot backup system in TokuDB is special amidst the existing solutions. First let’s look at existing backup solutions for...
by Aurimas Mikalauskas | Sep 5, 2013 | MySQL
MySQL 5.6 has a great many new features, including, but certainly not limited to a number of performance improvements. However, besides the widely talked-about features such as InnoDB support for full text search, optimizer, performance schema improvements and GTID,...
by Fernando Ipar | Aug 9, 2013 | MySQL, Percona Software, Webinars
I’m happy to announce that the recording for my recent webinar “5 Proactive Measures to Minimize MySQL Downtime” is now available, along with the slides. They can both be found here. My webinar focused on the top 5 operational measures that prevent...
by Alexander Rubin | Aug 8, 2013 | MySQL
I will be talking about Big Data with MySQL and Hadoop at MySQL Connect 2013 (Sept. 21-22) in San Francisco as well as at Percona University at Washington, DC (September 12, 2013). Apache Hadoop is a very popular Big Data solution and we can nowadays easily integrate...
by Leif.Walsh | Aug 7, 2013 | MySQL
Recently, we’ve seen a few people ask us about building TokuMX from scratch. While it’s best if you just use the binaries you can get from us (they have all the right optimizations, we’ve tested them, and we can interpret coredumps they generate), we...
by Zardosht.Kasheff | Aug 2, 2013 | MySQL
On Wednesday night, the Boston MongoDB User group was kind enough to have me speak about TokuMX Internals. I spoke about Fractal Tree® indexes and the technical reasons behind the benefits they provide to MongoDB applications. Although the talk mostly references...
by Stephane Combaudon | Aug 1, 2013 | Insight for Developers, MongoDB, MySQL
For people used to relational databases and doing MySQL database design, using NoSQL solutions such as MongoDB brings interesting challenges. One of them is schema design: while in the relational world, normalization is a good way to start, how should we design our...
by Stewart Smith | Jul 24, 2013 | MySQL, Percona Software
It was once said that “real artists ship.” In looking over the history of Percona software releases, we are currently shipping more software than ever before. First, let’s look at Percona Server. Let’s look at all major versions: 5.1, 5.5 and...
by Zardosht.Kasheff | Jul 22, 2013 | MySQL
A lot is said about the differences in the data between MySQL and MongoDB. Things such as “MongoDB is document based”, “MySQL is relational”, “InnoDB has a clustering key”, etc.. Some may wonder how TokuDB, our MySQL storage engine, and TokuMX, our MongoDB product,...
by Vadim Tkachenko | Jul 19, 2013 | Insight for DBAs, Insight for Developers, MySQL
In writing a recommendation for our Web development team on how to use MySQL, I came up with the following list, which I want to share: What kind of queries are bad for MySQL? Any query is bad. Send a query only if you must. (Hint: use caching like memcache or redis)...
by Zardosht.Kasheff | Jul 15, 2013 | MySQL
Before creating a unique index in TokuMX or TokuDB, ask yourself, “does my application really depend on the database enforcing uniqueness of this key?” If the answer is ANYTHING other than yes, do not declare the index to be unique. Why? Because unique indexes may...
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 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 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...
