Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 30 of 154 Next 30 Older Entries

Displaying posts with tag: Tokutek (reset)

March 20 Webinar: How to Scale MySQL for Big Data Applications
+0 Vote Up -0Vote Down

You may think that you have to buy, install, and get up to speed on a new database if you want to work with large amounts of data, but you can do more than you think with the MySQL you already have.
Register Now!

SPEAKER: Jon Tobin, Tokutek
DATE: Thursday, March 20th
TIME: 1pm ET

Without having to change your application or do special tuning you can increase performance and save significant time and money when you need to scale.

Join Tokutek’s Jon Tobin as he demonstrates how to use MySQL or MariaDB in Big Data applications by simply upgrading the storage engine with TokuDB, and how to effectively evaluate TokuDB for increased performance, compression and agility.

During this webinar you will learn:

  • How to dramatically increase performance without having to rewrite



  [Read more...]
Tokutek and Percona Live 2014
+1 Vote Up -0Vote Down

I’ve been a little behind in recent blogging efforts, and realized that in less than a month we’ll be back at Percona Live: MySQL Conference and Expo 2014, aka PLMCE. Last year’s PLMCE was my first, as well as the event where Tokutek announced the open sourcing of TokuDB.

It’s hard to believe that a year has gone by, but the customer adoption in both enterprise and community users has been awesome. TokuDB is available from our website for both MySQL and MariaDB, and is also

  [Read more...]
January 28 Webinar: Get More Out of MySQL with TokuDB
+0 Vote Up -0Vote Down

You love MySQL and MariaDB for its ease of deployment, but what if you could increase performance and save significant time and money when your application starts to scale without having to change your applications?
Register Now!

SPEAKER: Tim Callaghan, VP of Engineering at Tokutek
DATE: Tuesday, January 28th
TIME: 1pm ET

Join this interactive webinar with Tokutek’s VP of Engineering, Tim Callaghan, as he walks through the potential pitfalls when using MySQL or MariaDB for Big Data applications, and how to effectively use TokuDB to increase performance, reduce database size and achieve true schema agility.

Attend this webinar to learn:

  • How easy it is to install and configure TokuDB with MySQL or MariaDB
  • How to dramatically increase performance without having to rewrite code



  •   [Read more...]
    Announcing TokuMX v1.2: Hot Backup
    +1 Vote Up -0Vote Down

    We’ve been hard at work on TokuMX since it’s initial release just over 2 months ago. Today we released TokuMX v1.2 which includes Hot Backup in the Enterprise Edition.

    Hot Backup allows users to create a backup of a running TokuMX primary or secondary server in a replica set, with no blocking of writes for clients. We will be blogging more about the Hot Backup technology in the coming weeks. This same technology is used for Hot Backup in TokuDB.

    Also worth noting are the features we’ve added since the initial TokuMX release:

    • Migration Tools. Migrate to TokuMX from MongoDB using our tool that replays MongoDB repication. This allows a TokuMX server to stay in sync with a MongoDB replica set, reducing downtime for production go-live.
    • Bulk Loading.
      [Read more...]
    Announcing TokuMX v1.0: Toku+Mongo = You Can Have It All
    +5 Vote Up -0Vote Down

    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 TokuMX is MongoDB with all its storage code replaced by Tokutek’s Fractal Tree indexes.
    • How do Fractal Tree indexes improve MongoDB? The direct benefits include high-performance indexing, strong compression, and performance stability – in other words, the performance stays high, even when data is larger than RAM.
    • Are there any features in TokuMX that MongoDB doesn’t have? Yes. We have added support for transactions to TokuMX, so that TokuMX is ACID compliant and has MVCC. We have also added support for clustering indexes, which
      [Read more...]
    Announcing TokuDB v7 Enterprise Edition: Hot Backup and Support
    +1 Vote Up -0Vote Down

    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 with a support package.

    TokuDB v7 Enterprise Edition maintains all our established advantages: hot schema changes, excellent compression, fast trickle load, fast bulk load, fast range queries through clustering indexes, no fragmentation, and full MySQL/MariaDB compatibility for ease of installation.

    For details on pricing and supported MySQL and MariaDB versions, please see our FAQ.

    To learn more about TokuDB:

    • Download executables
      [Read more...]
    TokuDB vs Percona XtraDB using Tokutek’s MariaDB distribution
    +1 Vote Up -0Vote Down

    Following are benchmark results comparing Tokutek TokuDB and Percona XtraDB at scale factor 10 on the Star Schema benchmark. I’m posting this on the Shard-Query blog because I am going to compare the performance of Shard-Query on the benchmark on these two engines. First, however, I think it is important to see how they perform in isolation without concurrency.

    Because I am going to be testing Shard-Query, I have chosen to partition the “fact” table (lineorder) by month. I’ve attached the full DDL at the end of the post as well as the queries again for reference.

    I want to note a few things about the results:
    First and foremost, TokuDB was configured to use quicklz compression (the default) and InnoDB compression was not used. No tuning of TokuDB was performed, which means it will use up to 50% of memory by

      [Read more...]
    Understanding Tokutek Fractal Tree Indexes
    +1 Vote Up -0Vote Down

    Download PDF Presentation

    Thanks to Tim Callaghan for speaking Tuesday night at the Effective MySQL New York meetup on Fractal Tree Indexes : Theory and Practice (MySQL and MongoDB). There was a good turnout and a full room to learn how the TokuDB storage engine from Tokutek is changing how to handle big data in MySQL.

    Also interesting is how the same technology has been applied for use in MongoDB including giving MongoDB transactions; a big change for NoSQL.

    Related News: Tokutek Meets Big Data Demand With Open Source TokuDB

    Open Source, the MySQL market (and TokuDB in particular)
    +7 Vote Up -0Vote Down

    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 Hogan and titled, “Thoughts on Xeround and Free!

    For some reason the author of that post makes a connection between a free account in a cloud-based service and Open Source software. I think it’s

      [Read more...]
    The Data Day, A few days: April 29-May 3 2013
    +0 Vote Up -0Vote Down

    Teradata Q1 disappoints. Actian acquires ParAccel. And more.

    For 451 Research clients: Acquisitive Actian adds ParAccel to its growing database portfolio bit.ly/YgeY7k

    — Matt Aslett (@maslett) April 29, 2013

    For 451 Research clients: Tokutek releases TokuDB database storage engine as open source bit.ly/102xsSW

    — Matt Aslett (@maslett) May 1, 2013

    For 451 Research clients: Codership replicates partnership success with Galera Cluster for MySQL bit.ly/15dI8Hh

    — Matt Aslett (@maslett)

      [Read more...]
    Last Week’s Presentations Posted
    +0 Vote Up -0Vote Down

    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 our announcement early in the week about going open source was very exciting given the

      [Read more...]
    May 2nd Webinar: Introduction to TokuDB v7 Community & Enterprise Editions
    +0 Vote Up -0Vote Down

    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 visualizing performance data.

    Date: May 2nd
    Time: 2 PM EST / 11 AM PST
    REGISTER TODAY

    In the past TokuDB has been free for evaluation; the new TokuDB Community Edition extends free use to deployed environments. With this release Tokutek is also planning on making available a TokuDB Enterprise Edition, which includes technical support,



      [Read more...]
    Opening Week for TokuDB
    +0 Vote Up -0Vote Down

    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 some of the highlights of our first week of open source:

    We started hearing back from the community almost immediately after the announcement with discussions in multiple forums. We even reached #2 on Hacker News for a bit.

    On Tuesday,

      [Read more...]
    The Data Day, A few days: April 22-26 2013
    +0 Vote Up -0Vote Down

    Pivotal launches. SkySQL and Mony Program merge. And much, much more

    Our report on the changes in the MySQL ecosystem is now available for 451 clients and non-clients alike at bit.ly/451mysql

    — Matt Aslett (@maslett) April 25, 2013

    For 451 Research clients: VMware expands Serengeti’s horizons with updated Hadoop virtualization project bit.ly/17muQFI

    — Matt Aslett (@maslett) April 26, 2013

    For 451 Research clients: SkySQL, Monty Program merge to support MariaDB following formation of MariaDB Foundation bit.ly/10dsdjf

      [Read more...]
    MySQL Paradise: YouTube Video
    +2 Vote Up -0Vote Down

    Yesterday we posted the photos and lyrics. Now we’ve got the YouTube video (click here)!

    And for those who want some behind the scenes photos, see here and here. (courtesy of @seattlegaucho).

    Thanks to Community for Selecting Tokutek for Prestigious MySQL Award
    +3 Vote Up -0Vote Down

    We wanted to thank everyone for naming Tokutek the Corporate Contributor of the Year 2013 for ongoing contribution to the MySQL community.

    The MySQL Community Awards are given annually to the people and companies that support the MySQL ecosystem. The MySQL Community Award for Corporate Contributor of the Year recognizes a company or other organization or entity that has made valuable contributions to the MySQL ecosystem either in terms of open source code, knowledge,

      [Read more...]
    MySQL Paradise – Percona Live Lightning Talk
    +1 Vote Up -0Vote Down

    Thanks to all of those who came to the lightning talks this evening. We’ve got the audio posted here and the lyrics below.

    A special thanks to Erin Grace O’Malley O’Neill for the great performance. Thanks also to @NuoDB and @geobdz (whose photo is below) for tweets.

    Stay tuned for the video as well….


    MySQL Paradise

    As I browse through  [Read more...]

    Open Source TokuDB Resources
    +2 Vote Up -0Vote Down

    Since we announced that TokuDB is now open source, there has been a lot of positive feedback (thanks!) and also some questions about the details. I want to take this opportunity to give a quick high level guide to describe what our repositories on Github are.

    Here are the repositories:

    • ft-index. This repository is the “magic”. It contains the Fractal Tree data structures we have been talking about for years. This is also the main piece that was previously closed source. Here are some interesting directories:
      • src: This directory is a layer that implements an API that is similar to the BDB API.
      • locktree: an in-memory data structure that maintains transactions’ row-level locks.
      [Read more...]
    Getting Interesting
    +0 Vote Up -0Vote Down

    I enjoyed Stewart Smith’s MySQL storage engine blog last week. In it he noted “I cannot emphasize how much more interesting TokuDB would be if it were open source.” Well, with our open source announcement yesterday, hopefully we are getting interesting.

    We wanted to thank everyone for the great feedback. Here is a sampling from some of the forums where dialogue is occurring:


    Reddit:

    BrianAtDTS: “With this update, this puts MySQL in

      [Read more...]
    Announcing TokuDB v7: Open Source and More
    +3 Vote Up -0Vote Down

    Every few months, I get the fun job of announcing what’s new in TokuDB®, but this time is special. With Version 7, TokuDB for MySQL and MariaDB is going open source.

    The free Community Edition is fully functional and fully performant. It has all the compression you’ve come to expect from TokuDB. It has hot schema changes: no-down-time column insertion, deletion, renaming, etc., as well as index creation. It has clustering secondary keys. We are also announcing an Enterprise Edition (coming soon) with additional benefits, such as a support package and advanced backup and recovery tools.

    Making TokuDB open source is a natural next step for Tokutek’s involvement in the MySQL community. So far, Tokutek has been involved in the community in many ways:

    • We’ve
      [Read more...]
    April is the Coolest Month
    +0 Vote Up -0Vote Down

    If T.S. Eliot were a MySQL DBA, I think he would have been more upbeat about April.

    We are gearing up for an incredible second half of April. We will be presenting three separate sessions at the Percona Live: MySQL Conference and Expo 2013, April 22-25, in Santa Clara, CA. In addition, we will be presenting at SkySQL’s MySQL & Cloud Database Solutions Day on Friday, April 26 at the same location.

    Come by to see us in Booth #114, or stop by one of our sessions:

      [Read more...]
    MongoDB Multi-Statement Transactions? Yes We Can!
    +0 Vote Up -1Vote Down

    Earlier, I talked about the transactional semantics we are introducing to MongoDB. As I hinted at the end of the post, we are actually doing more. We are introducing multi-statement transactions. That’s right, multiple queries, updates, deletes, and inserts will be able to run inside of a single transaction. We are working on the details of the semantics as we develop our beta, but at a high level, think of it as having the same semantics as TokuDB and InnoDB’s multi-statement transactions in MySQL.

    So how will it work? We introduce three new commands:

    db.runCommand({"beginTransaction", "isolation": "mvcc"})

    This begins a transaction with the isolation level of MVCC, which means queries will use a snapshot of the system.

      [Read more...]
    MongoDB Transactions? Yes
    +1 Vote Up -1Vote Down

    People claim that MongoDB is not transactional. It actually is, and that’s a good thing.

    In MongoDB 2.2, individual operations are Atomic. By having per database locks control reads and writes to collections, write operations on collections are Consistent and Isolated. With journaling on, operations may be made Durable. Put these properties together, and you have basic ACID properties for transactions.

    The shortcoming with MongoDB’s implementation is that these semantics apply to individual write operations, such as an individual insert or individual update. If a MongoDB statement updates 10 rows, and something goes wrong with the fifth row, then the statement

      [Read more...]
    TokuDB Fast Update Benchmark
    +1 Vote Up -0Vote Down

    Last month my colleague Rich Prohaska covered the technical details of our “Fast Update” feature which we added to TokuDB in version 6.6.  The message based architecture of Fractal Tree Indexes allows us to defer certain operations while still maintaining the semantics that MySQL users require.

    In the case of Fast Updates, TokuDB is avoiding the read-before-write requirement that the existing MySQL update statement imposes on storage engines.  We can simply inject an update message into the Fractal Tree Index, and apply that message at a later time.  The message is dynamically applied if a user selects that specific

      [Read more...]
    Wanted: Evaluators to Try MongoDB with Fractal Tree Indexing
    +0 Vote Up -0Vote Down

    We recently resumed our discussion around bringing Fractal Tree indexes to MongoDB.  This effort includes Tokutek’s interview with Jeff Kelly at Strata as well as my two recent tech blogs which describe the compression achieved on a generic MongoDB data set and performance improvements we measured using on our implementation of Sysbench for MongoDB.  I have a full line-up of benchmarks and blogs planned for the next few months, as our project continues.  Many of these

      [Read more...]
    Sysbench Benchmark for MongoDB
    +1 Vote Up -0Vote Down

    As we continue to test our Fractal Tree Indexing with MongoDB, I’ve been updating my benchmark infrastructure so I can compare performance, correctness, and resource utilization.  Sysbench has long been a standard for testing MySQL performance, so I created a version that is compatible with MongoDB.  You can grab my current version of Sysbench for MongoDB here.

    So what exactly is Sysbench?  According to the Sysbench homepage, “Sysbench is a modular, cross-platform and multi-threaded benchmark tool for evaluating OS [Operating System] parameters that are important for a system running a database under intensive load.”

    • Sysbench schema
      • 16 copies of the same collection,

      [Read more...]
    The Last Mile for Big Data – Strata Overview with Jeff Kelly of Wikibon (Part 2)
    +0 Vote Up -0Vote Down

    During the second half of our CUBE discussion with Wikibon analyst Jeff Kelly at this year’s Strata Conference in Santa Clara, we talked about the tipping point for Big Data. Strata veterans could see at a glance that this year’s conference was markedly different. No longer the exclusive domain of geeks and database administrators, this year’s Strata featured some of the biggest enterprise vendors around. With heavy weight enterprise players Intel and EMC Greenplum announcing their own Hadoop distributions, big data is clearly going mainstream. Now that we know how to capture, store, access and analyze big data, what’s the next step? Listen in to hear my conversation with Jeff Kelly about taking big data

      [Read more...]
    MySQL and MongoDB – Strata Discussion with Jeff Kelly of Wikibon (Part 1)
    +1 Vote Up -0Vote Down

    We had the opportunity to do a CUBE interview with Wikibon analyst Jeff Kelly at last week’s Strata Conference in Santa Clara. In the first part of our conversation, we discuss how our success in integrating Tokutek’s Fractal Tree® technology into MySQL has led us to another popular database, MongoDB. We explain the results of our recent benchmarking tests with MongoDB, which indicate that adding indexing can also improve performance for this popular NoSQL database with faster insertion rates, lower query latency and

      [Read more...]
    MongoDB + Fractal Tree Indexes = High Compression
    +2 Vote Up -0Vote Down

    One doesn’t have to look far to see that there is strong interest in MongoDB compression. MongoDB has an open ticket from 2009 titled “Option to Store Data Compressed” with Fix Version/s planned but not scheduled. The ticket has a lot of comments, mostly from MongoDB users explaining their use-cases for the feature. For example, Khalid Salomão notes that “Compression would be very good to reduce storage cost and improve IO performance” and Andy notes that “SSD is getting more and more common for

      [Read more...]
    NoSQL is Great, But You Still Need Indexes
    +1 Vote Up -0Vote Down

    I’ve said it before, and, as is the nature of these things, I’ll almost certainly say it again: your database performance is only as good as your indexes.

    That’s the grand thesis, so what does that mean? In any DB system — SQL, NoSQL, NewSQL, PostSQL, … — data gets ingested and organized. And the system answers queries. The pain point for most users is around the speed to answer queries. And the query speed (both latency and throughput, to be exact) depend on how the data is organized. In short: Good Indexes, Fast Queries; Poor Indexes, Slow Queries.

    But building indexes is hard work, or at least it has been for the last several decades, because almost all indexing is done with B-trees. That’s true of

      [Read more...]
    Showing entries 1 to 30 of 154 Next 30 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.