Engineering MySQL Subroutines for Integrity

Average rating: ***..
(3.00, 1 rating)

Integrating MySQL subroutines starts with good database design. Good database design requires understanding the business problem and technology stack possibilities. Web 2.0 and AJAX raise the ante with more complex transaction control problems. This presentation addresses how to create MySQL stored programs to solve these problems.

Topics Include:

Merits of functions over procedures
Merits of definer and invoker rights
Merits of MySQL security-layers with stored programs
Simplification of PHP when using stored programs
Transaction control provided by stored programs
Approaches for page and page-fragment refreshes

Photo of Michael McLaughlin

Michael McLaughlin

BYU - Idaho

I teach database technology and systems analysis in the Computer Information Technology Department at BYU – Idaho. I’ve worked as an application developer, DBA, and database designer for over twenty-five years with Oracle, MySQL, and DB2 databases. I’ve authored or co-authored books on PHP and Oracle programming.

Comments on this page are now closed.


Billy Vitro
04/15/2011 4:53am PDT

This presentation covered a lot of ground, and missed depth. It seemed like the presenter should have assumed a level of understanding of stored procedures by the attendees, and given specific examples of how to improve those. For example, covering JavaScript and CSS was mostly a waste of time.

  • EnterpriseDB
  • Amazon Web Services
  • Clustrix
  • Continuent
  • Facebook
  • HTI Consultoria e Tecnologia
  • Monty Program
  • Percona
  • Rackspace Hosting
  • Schooner Information Technology
  • SkySQL
  • Xeround

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at

Media Partners Opportunities

For media partnerships, contact mediapartners@

Press & Media

For media-related inquiries, contact Maureen Jennings at

O'Reilly MySQL Conference Bulletin

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference Contacts