NAME

Apache2::ASP::Session::MySQL - MySQL-persisted Session state for Apache2::ASP

SYNOPSIS

In your httpd.conf:

PerlSetEnv APACHE2_ASP_SESSION_MANAGER Apache2::ASP::Session::MySQL

That's it! Now you're using Apache2::ASP::Session::MySQL to manage all of your Session state in your Apache2::ASP web application.

NOTE: - If you don't specify a value for $ENV{APACHE2_SESSION_MANAGER} then it will automatically default to Apache2::ASP::Session::MySQL.

DESCRIPTION

Apache2::ASP::Session::MySQL is both a reference implementation and the default Session state manager for Apache2::ASP.

Session state is unblessed, serialized via Storable and written to the database as a BLOB.

The data structure itself is simply a hashref.

Because the data is persisted within an SQL database, you can take advantage of load-balanced servers without the need for "session affinity" at the network level.

DATABASE STRUCTURE

Sessions are stored in a SQL database table with the following structure:

CREATE TABLE asp_sessions (
  session_id CHAR(32) PRIMARY KEY NOT NULL,
  session_data BLOB,
  created_on DATETIME,
  modified_on DATETIME
);

AUTHOR

John Drago mailto:jdrago_999@yahoo.com

COPYRIGHT AND LICENSE

Copyright 2007 John Drago, All rights reserved.

This software is free software. It may be used and distributed under the same terms as Perl itself.