How to install TokuDB on Ubuntu?

Follow the build instructions in the README: install dependencies like valgrind, zlib1g-dev, and libdb-dev, then use scripts with specific compiler flags. However, it's complex and may require devtoolset adjustments for compatibility.

TokuDB vs InnoDB: which is better for writes?

TokuDB excels in write-intensive scenarios due to Fractal Tree indexing, offering higher throughput for inserts and updates. InnoDB is more balanced but may lag in pure write performance, especially with large datasets.

Does TokuDB support foreign keys?

TokuDB provides transactional ACID compliance, but foreign key support should be verified with specific documentation or testing, as it might have limitations compared to InnoDB's native implementation.

What compression ratios can I expect with TokuDB?

TokuDB's built-in compression can reduce storage by 50% or more, depending on data types, significantly lowering disk usage and costs for large databases, as highlighted in its value proposition.

Is TokuDB compatible with MySQL 8?

TokuDB is primarily designed for Percona Server 5.6, so compatibility with MySQL 8 is limited and not officially supported, potentially requiring forks or alternative builds for integration.

Open-Awesome

tokudb-engine

GPL-2.0C++tokudb-7.1.6

A high-performance, write-optimized, compressing transactional storage engine for Percona Server and MySQL.

Visit Website GitHub

663 stars128 forks0 contributors

What is tokudb-engine?

TokuDB is a high-performance storage engine for Percona Server and MySQL that uses Fractal Tree indexing to optimize write operations and includes built-in compression. It solves the problem of slow write performance and large storage requirements in traditional database engines by providing faster inserts/updates and reduced disk usage.

Target Audience

Database administrators and developers running MySQL/Percona Server with write-intensive workloads, large datasets, or storage constraints who need better performance than InnoDB provides.

Value Proposition

Developers choose TokuDB for its superior write throughput and compression capabilities compared to standard MySQL storage engines, enabling faster data ingestion and lower storage costs without sacrificing transactional integrity.

Overview

Percona TokuDB is a high-performance, write optimized, compressing, transactional storage engine for Percona Server. Issue tracker: https://tokutek.atlassian.net/browse/DB/ Wiki: https://github.com/Percona/tokudb-engine/wiki Downloads:

Use Cases

Best For

High-velocity data ingestion applications
Logging and time-series data storage
Applications with large datasets requiring compression
Write-intensive MySQL workloads
Scaling MySQL databases with heavy insert/update operations
Reducing storage costs for large MySQL databases

Not Ideal For

Read-heavy applications where query performance is prioritized over write throughput
Teams using standard MySQL or MariaDB without Percona Server
Projects with small datasets that don't benefit from compression or high write scalability

Pros & Cons

Pros

Write-Optimized Performance

Uses Fractal Tree indexing to significantly accelerate insert, update, and delete operations, ideal for write-intensive workloads as described in the key features.

Built-in Compression

Reduces storage footprint by compressing data on disk, lowering I/O and storage costs, which is a core advantage highlighted for large datasets.

Transactional Reliability

Provides full ACID compliance for data integrity in production environments, ensuring reliable transactions as noted in the features.

Scalability for Large Data

Efficiently manages and maintains performance with large datasets, supporting scalable storage as emphasized in the project's philosophy.

Cons

Complex Installation Process

Requires specific C++11 compiler versions, CMake, and libraries like valgrind and Berkeley DB, with build instructions that are non-trivial and platform-dependent, as shown in the README.

Limited to Percona Server 5.6

Tied to an older version of Percona Server, which may lack support for newer MySQL features and updates, as indicated in the download section.

Licensing Complexity

Involves multiple licenses (GPL and AGPL) with patent clauses, complicating commercial use and contribution processes, as detailed in the license section.

Frequently Asked Questions

Related Projects

RocksDB

A library that provides an embeddable, persistent key-value store for fast storage.

Stars31,903

Forks6,880

Last commit19 hours ago

MongoDB source code

The MongoDB Database

Stars28,464

Forks5,790

Last commit23 hours ago

rethinkdb

The open-source database for the realtime web.

Stars27,001

Forks1,851

Last commit3 months ago

postgres

Mirror of the official PostgreSQL GIT repository. Note that this is just a *mirror* - we don't work with pull requests on github. To contribute, please see https://wiki.postgresql.org/wiki/Submitting_a_Patch

Stars21,574

Forks5,798

Last commit1 day ago

Community-curated · Updated weekly · 100% open source

Found a gem we're missing?

Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.

Submit a project Star on GitHub