PHP? MySQL ?? ? ??? ???? ??? ?? Swoole? Workerman? ??? ???? ?? ?? ??? ?????.

? ??????? ???? ??? ??? ???? ?? ?????? ??? ?????? ?? ???? ?? ? ??? ?????. ??. PHP ???? ????? ???? ?????? ?? ???? ? ??? ?? ??? ?????. ? ??? ?????? ??? ??? ? ?? ??? ???? ??? ??? ?? ? ????? ?? ????, ?? ??? ? ??? ??? ? ??? ?? ?? ?????.

PHP?? ???? MySQL ?? ??? ?? ??, ? ? SQL ?? ??? ?? ??? ??? ????. ??? ??? ?? ??? ?? ??? ?? ???? ?????. ??? ????? ?? ? ??? ???? ??? ??? ??????.

Swoole ? Workerman? PHP ???? ?? ???? ??? ???? ?? ??????, TCP/UDP ??? ???? ?? MySQL ?? ?? ? ?? ??? ?????. ??? PHP? MySQL? ??? ?? Swoole? Workerman? ??? ??? ??? ?????.

1. Swoole? MySQL ? ?? ???

Swoole? MySQL? ? ?? ??? ??? swoole_mysql? ?????. swoole_mysql? ??? ? ?? ????? true? ???? ? ??? ???? ? ????.

$server = new SwooleServer('0.0.0.0', 9501);
$server->on('workerStart', function ($server, $workerId) {
    $server->mysql = new SwooleCoroutineMySQL;
    $server->mysql->connect([
        'host' => 'localhost',
        'port' => 3306,
        'user' => 'root',
        'password' => 'password',
        'database' => 'test',
        'charset' => 'utf8mb4',
        'timeout' => 2,
    ], true);
});

? ???? ?? ????? ? ?? ????? true? ?????. ?? ? ??? ?????? ?????. ?? ?? ???? ???? ?? ?? ?? ??? ??? ?? ????.

2. Swoole? MySQL ?? ?? ???

Swoole? ? ?? ??? MySQL? ?? ??? ?????. ?? ??? ??? ?? ? MySQL ??? ?? ??? ?? ??? ?? ??? ?? ?? ?? ??? ?????. ? ??? ??? ?? ? ?? ?? ??? ???? ???? ??? ??? ?? ? ????.

Swoole? ?? ??? ???? ?? ?? ??? ?? ??? ? ????.

$server = new SwooleServer('0.0.0.0', 9501);
$server->on('workerStart', function ($server, $workerId) {
    $server->mysql = new SwooleCoroutineMySQL;
    $server->mysql->connect([
        'host' => 'localhost',
        'port' => 3306,
        'user' => 'root',
        'password' => 'password',
        'database' => 'test',
        'charset' => 'utf8mb4',
        'timeout' => 2,
        'persistent' => true,
    ]);
});

? ???? ?? ????? ?? ??? true? ?????. ?? ?? ??? ?? ?? ?????.

3. Workerman? MySQL ?? ? ?? ?? ???

Swoole? ???? Workerman? MySQL ?? ? ?? ??? ?????. ??? Workerman? ???? MySQL? ? ??? ???? ??? ????? ?? ?? ?????.

$worker = new Worker();
$worker->onWorkerStart = function ($worker) {
    $worker->mysql = new WorkermanMySQLConnection([
        'host' => 'localhost',
        'port' => 3306,
        'user' => 'root',
        'password' => 'password',
        'database' => 'test',
        'charset' => 'utf8mb4',
    ], $worker->id);
};

? ???? Workerman ????? ???? onWorkerStart ?? ???? MySQL ?? ??? ???? ?? ????? ?????. ??? ???? ? ??? ?????? ?? MySQL ??? ?? ? ??? ???? ??? ???? ? ????.

??:

Swoole? Workerman? ???? PHP? MySQL ??? ??? ???????, ? ? ???? ???? ??? ?? ?? ?? ? ?? ??? ??? ?????? ??? ???? ????? ??? ?? ? ????. ??? ??.

??? ? ??? ?? ??? ?? ?????? ????, ?? ?? ??? ??? ???? ???? ???? ???? ???. ?? ???? ?? ??? ?? ???? ?? ??? ?? ??? ???? ???.

?? ??? ?? ??? ??? ?? ?????? ?? ???? ???? ???? ??? ??, ??????? ???? ??? ???? ?? ??? ?? ???? ??? ?? ?? ???? ??????.

(??: ? ??? ??? ??? ?? ?? ? ?? ????? ?? ???? ???.)

? ??? PHP? MySQL? ? ??? ???? ??? ?? Swoole? Workerman? ??? ??? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!