yiisoft/mutex-db-mysql

This package is abandoned and no longer maintained. The author suggests using the yiisoft/mutex-pdo-mysql package instead.

Yii Mutex Library - MySQL PDO Driver

1.1.0 2021-10-19 07:18 UTC

Requires

• php: ^7.4|^8.0
• ext-pdo: *
• yiisoft/mutex: ^1.1

Requires (Dev)

• phpunit/phpunit: ^9.5
• roave/infection-static-analysis-plugin: ^1.9
• spatie/phpunit-watcher: ^1.23
• vimeo/psalm: ^4.9

BSD-3-Clause

• yii
• mutex

README

Yii Mutex Library - MySQL PDO Driver

This library provides a MySQL mutex implementation for yiisoft/mutex.

Requirements

• PHP 7.4 or higher.
• PDO PHP extension.

Installation

The package could be installed with Composer:

composer require yiisoft/mutex-pdo-mysql

General usage

The package provides two classes implementing MutexInterface and MutexFactoryInterface from the yiisoft/mutex package:

/**
 * @var \PDO $connection Configured for MySQL.
 */

$mutex = new \Yiisoft\Mutex\Mysql\MysqlMutex('mutex-name', $connection);

$mutexFactory = new \Yiisoft\Mutex\Mysql\MysqlMutexFactory($connection);

There are multiple ways you can use the package. You can execute a callback in a synchronized mode i.e. only a single instance of the callback is executed at the same time:

$synchronizer = new \Yiisoft\Mutex\Synchronizer($mutexFactory);

$newCount = $synchronizer->execute('critical', function () {
    return $counter->increase();
}, 10);

Another way is to manually open and close mutex:

$simpleMutex = \Yiisoft\Mutex\SimpleMutex($mutexFactory);

if (!$simpleMutex->acquire('critical', 10)) {
    throw new \Yiisoft\Mutex\Exception\MutexLockedException('Unable to acquire the "critical" mutex.');
}

$newCount = $counter->increase();
$simpleMutex->release('critical');

It could be done on lower level:

$mutex = $mutexFactory->createAndAcquire('critical', 10);
$newCount = $counter->increase();
$mutex->release();

And if you want even more control, you can acquire mutex manually:

$mutex = $mutexFactory->create('critical');

if (!$mutex->acquire(10)) {
    throw new \Yiisoft\Mutex\Exception\MutexLockedException('Unable to acquire the "critical" mutex.');
}

$newCount = $counter->increase();
$mutex->release();

The MysqlMutex supports the "wait for a lock for a certain time" functionality. Using the withRetryDelay() method, you can override the number of milliseconds between each try until specified timeout times out:

$mutex = $mutex->withRetryDelay(100);

By default, it is 50 milliseconds - it means that we may try to acquire lock up to 20 times per second.

Documentation

• Internals

If you need help or have a question, the Yii Forum is a good place for that. You may also check out other Yii Community Resources.

License

The Yii Mutex Library - MySQL PDO Driver is free software. It is released under the terms of the BSD License. Please see LICENSE for more information.

Maintained by Yii Software.

Support the project

Follow updates