Showing posts with label high-performance. Show all posts
Showing posts with label high-performance. Show all posts

Thursday, 28 May 2015

3 Must-Read Books About Database Performance

SQL Performance Explained: Everything Developers Need to Know about SQL Performance

An in-depth book on how to improve database performance. The focus is on relational databases and it covers all major SQL databases without getting lost in the details of any one specific product. Starting with the basics of indexing and the WHERE clause, SQL Performance Explained guides developers through all parts of an SQL statement and explains the pitfalls of object-relational mapping (ORM) tools like Hibernate.

PostgreSQL 9.0 High Performance

An excellent book for intermediate to advanced PostgreSQL database administrators (DBA). Teaches everything about building, monitoring and maintaining a PostgreSQL installation while also providing useful and interesting information about database internals. If you truly want to understand how PostgreSQL operates and behaves under a high load this is a book for you.

High Performance MySQL: Optimization, Backups, and Replication

Advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover.

Monday, 17 February 2014

TokuMX – High-Performance MongoDB Distribution

TokuMX is a high-performance version of MongoDB. It is an open-source project by Tokutek, a database company that focuses on Big Data solutions. TokuMX is a more performant than MongoDB and has greater operational efficiency. Tokutek claims on their homepage:
"TokuMX is a drop-in replacement for MongoDB, and offers 20X performance improvements, 90% reduction in database size, and support for ACID transactions with MVCC."
TokuMX introduces patented Fractal Tree indexing technology (Technology Overview in PDF), which improves upon MongoDB's default B-tree indexing. Fractal Tree indexing is based on cache-oblivious algorithm and it implements the same operations as a B-tree. Fractal Tree indexes uses large, less frequent writes instead of small and rapid ones, which gives a benefit for compression and insertion performance.

Key features overview:

TokuMX Key Features

Recently Tokutek released TokuMX version 1.4, which brings us improvements to MongoDB sharding and replication among other useful features. For more information on this release, please, check out full release notes.

TokuMX open-source engine can be found on Github as Tokutek/mongo (GNU General Public License). There is also an Enterprise version with proprietary EULA. To obtain Enterprise version, a subscription must be purchased. It gives customers the following benefits: Technical Support, Onboarding Call and access to Advanced Tools (e.g., Hot Backup).

External links
Product homepage - TokuMX
TokuMX is MongoDB on steroids (MySQL Performance Blog)
Wikipedia Article