BLOB Streaming: Efficient Reliable BLOB Handling for all Storage Engines

Barry Leslie (PrimeBase Technologies)
Average rating: ***..
(3.00, 2 ratings)

One of the challenges faced by developers using MySQL is how to handle BLOBS in an efficiently and reliable manner. Storing BLOBs directly in the database has the limitation in that the BLOB cannot be larger than the maximum row size and operations involving BLOBs are slow and consume large amounts of memory. Storing the BLOBs outside the database results in loss of control by the database server: no backup or replication of BLOB data and unreferenced blobs or references to no existing blobs is always possible.

My session will show how to create tables that will utilize the PrimeBase BLOB streaming engine (PBMS) to efficiently store BLOB data in the database. It will also demonstrate how to build client applications using the PBMS ā€˜Cā€™ API and PHP to stream BLOB data in and out of the database. The example application will make use of traditional MySQL storage engines such as MYISAM and InnoDB.

In addition to this demonstration I will explain how BLOB streaming works and why it is an improvement over traditional ways of storing BLOBs.

To end the session the future plans for BLOB streaming will be discuss with regards to remote BLOB storage and retrieval.

Photo of Barry Leslie

Barry Leslie

PrimeBase Technologies

Barry Leslie is a core developer of the PrimeBase BLOB Streaming engine and cofounder of SNAP Innovation GmbH, Germany, where he is a senior developer in core technology. He has 20 years of software development experience. Barry has a Bachelor of Science in Computer Science from the University of Victoria and a Bachelor of Technology in Industrial Engineering from Ryerson University Toronto.

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com

Download the MySQL Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.