Session::Lock::MySQL(3User Contributed Perl DocumentaSession::Lock::MySQL(3pm)

NAME
       Apache::Session::Lock::MySQL - Provides mutual exclusion using MySQL

SYNOPSIS
        use Apache::Session::Lock::MySQL;

        my $locker = new Apache::Session::Lock::MySQL;

        $locker->acquire_read_lock($ref);
        $locker->acquire_write_lock($ref);
        $locker->release_read_lock($ref);
        $locker->release_write_lock($ref);
        $locker->release_all_locks($ref);

DESCRIPTION
       Apache::Session::Lock::MySQL fulfills the locking interface of
       Apache::Session.  Mutual exclusion is achieved through the use of
       MySQL's GET_LOCK and RELEASE_LOCK functions.  MySQL does not support
       the notion of read and write locks, so this module only supports exclu-
       sive locks.  When you request a shared read lock, it is instead pro-
       moted to an exclusive write lock.

CONFIGURATION
       The module must know how to connect to your MySQL database to acquire
       locks.  You must provide a datasource name, a user name, and a pass-
       word.  These options are passed in the usual Apache::Session style, and
       are very similar to the options for Apache::Session::Store::MySQL.
       Example:

        tie %hash, 'Apache::Session::MySQL', $id, {
            LockDataSource => 'dbi:mysql:database',
            LockUserName   => 'database_user',
            LockPassword   => 'K00l'
        };

       Instead, you may pass in an already opened DBI handle to your database.

        tie %hash, 'Apache::Session::MySQL', $id, {
            LockHandle => $dbh
        };

AUTHOR
       This module was written by Jeffrey William Baker <jwbaker@acm.org>.

SEE ALSO
       Apache::Session

perl v5.8.8                       2004-10-09         Session::Lock::MySQL(3pm)