Part 5/7: MySQL Conference: Inside the PBXT Storage Engine

Abstract:

PBXT is a MVCC (multi-version concurrency control) based, transactional storage engine for MySQL. Developed from scratch for MySQL, the compact and innovative design makes PBXT ideal for understanding how a MySQL storage engine works. At the same time it provides a solid platform for doing high-concurrency, mission-critical, transaction processing.

This session takes a tour of the most important aspects of the PBXT internals: version-control, table-to-file system mapping, disk space management, caching, durability and recovery. Key algorithms and performance considerations are highlighted throughout the discussion.

About Paul McCullagh and PrimeBase Technologies GmbH:

Paul McCullagh is cofounder of SNAP Innovation GmbH, Germany, where he is responsible for core technology. He has 17 years experience in the development of database and internet related systems. Paul has a Master of Science in Computer Science from the University of Cape Town where he specialized in operating system design and implementation.

Paul is the developer of the PBXT transactional storage engine for MySQL (www.primebase.com/xt). Most recently his work has included the development of the BLOB streaming engine for MySQL (www.blobstreaming.org).

Category:

Science & Technology

Tags:

• MySQL
• Conference
• Database
• Paul
• McCullagh
• PBXT
• Storage
• Engine
• PrimeBase
• Technologies